Add Option to Export Numeric Data as Numbers Instead of Text

[Murkrow02]

Description:

Currently, when exporting data using FilamentPHP's built-in export functionality, numeric values are exported as text. This behavior complicates tasks such as summing columns in spreadsheet applications like Excel.

Proposed Enhancement:

Introduce an option within the ExportColumn configuration to specify whether a column's data should be exported as a number or as text. This would allow developers to control the format of each column individually, facilitating easier data manipulation in spreadsheet applications.

Example:

ExportColumn::make('price')
    ->numeric()
    ->label('Price')
    ->numeric();

In this example, the numeric() method would indicate that the 'price' column should be exported as a numeric value, allowing spreadsheet applications to recognize and handle it appropriately.

Benefits:

• Improved usability for users who need to perform calculations on exported data.
• Reduced need for manual data cleaning after export.
• Enhanced compatibility with spreadsheet applications that rely on numeric data formats.

[fabio-ivona]

@ryangjchandler this is really useful would it be implemented in v4?

[glitterlip]

really need this，exported data cant be calculated

[zaidpirwani]

I realized this when other people started asking me about why cant they sum the items or pivot it in excel.

I was converting to numbers manually by habit on all exported sheets, people didnt knew,

maybe with all the excel customization options in the new v5, this is possible, I will check and respond later
https://filamentphp.com/docs/5.x/actions/export#customizing-xlsx-files

Currently, my exported file has wrap enabled on cells, number is text and the first open view is very bad.