Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

95
Views
Ag grid React export as excel with style

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

enter image description here

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!