[data grid] Export to Excel default Date format is "dd.mm.yyyy" and it's too difficult to override for the entire system

[nycgavin]

Summary

The current date format for export to excel feature on Data Grid Premium is dd.mm.yyyy, while this is suitable for Europe countries. In the United States, the default format should be mm/dd/yyyy, and currently the only way to overwrite the default format is at the column style level.

<GridToolbarExport
  excelOptions={{
    columnsStyles: {
      // replace the dd.mm.yyyy default date format
      recruitmentDay: { numFmt: 'dd/mm/yyyy' },
      // set this column in green
      incomes: { font: { argb: 'FF00FF00' } },
    },
  }}
/>

this is too tedious because I will need to define a column style for all date columns in all data grid.

I wish to overwrite the default date and datetime style at the datagrid level, not at the column level.

Examples

No response

Motivation

No response

Search keywords: excel export datagrid
Order ID: 51732

[michelengelen]

There is an option to pas this at the DataGrid level.
You can pass in the excelOptions into the slotProps like this:

const excelOptions = {
  columnsStyles: {
    // replace the dd.mm.yyyy default date format
    recruitmentDay: { numFmt: 'dd/mm/yyyy' },
    // set this column in green
    incomes: { font: { argb: 'FF00FF00' } },
  },
};

export default function ExcelCustomExport() {
  return (
    <DataGridPremium
      rows={rows}
      columns={columns}
      slots={{ toolbar: GridToolbar }}
      slotProps={{ toolbar: { excelOptions } }}
    />
  );
}

Is this a suitable solution for your use-case?

[github-actions]

The issue has been inactive for 7 days and has been automatically closed.