I would like export my table from excel with formatted values, my code from bellow
...
{ headerName : "Date transmission", field : "date_load", type : "dateColumn"
...
const columnTypes = {
dateColumn: {
filter: 'agMultiColumnFilter',
filterParams: {
filters: [
{filter: 'agDateColumnFilter', filterParams: {buttons: ['reset']}},
{filter: 'agSetColumnFilter', filterParams: {buttons: ['reset']}},
]
},
cellStyle: {'textAlign': 'center'},
cellClass: 'dateToExcel',
valueFormatter: params => formatDate(params.value, "fr")
}
}
...
const excelStyles = [
{
id: 'dateToExcel',
dataType: 'dateTime',
numberFormat: { format : 'dd/mm/yyyy'}
}
]
And my ag-grid-react component
<AgGridReact
rowData={rowData}
onGridReady={onGridReady}
defaultColDef={defaultColDef}
columnTypes={columnTypes}
excelStyles={excelStyles}
...
When the export is done, the dateCells wasn't be formatted