Filament•7mo ago

export format column

Hi everyone, Can anyone explain how to set up ExportColumn to use a numeric value? I tried using formatStateUsing, but it is still not working:

ExportColumn::make('balance')
                ->formatStateUsing(fn(int $state): int => $state);

ExportColumn::make('balance')
                ->formatStateUsing(fn(int $state): int => $state);

The result is still a TEXT value (as shown in the screenshot).

4 Replies

Juan Duarte Molina•5mo ago

Did you find any solution? Thanks

Jr.PikongOP•5mo ago

No , I dont have a solution 🙏

Juan Duarte Molina•5mo ago

So, we can not work with the exported excel "out-of-the-box " ? Need convert the columns manually. Maybe we should use https://laravel-excel.com/ instead of the exporter option ...🥺

Laravel Excel

Supercharged Excel exports and imports in Laravel | Laravel Excel

Laravel Excel is intended at being Laravel-flavoured PhpSpreadsheet: a simple, but elegant wrapper with the goal of simplifying exports and imports.

Juan Duarte Molina•5mo ago

Any further help on this topic? will be appreciated

Gaming

Programming

export format column

Did you find this page helpful?