Excel Export V1

Enable Excel export for the rows currently loaded in DyonaGrid.

<DyonaGrid
  columns={columns}
  rows={rows}
  exportExcel={{
    enabled: true,
    mode: 'loaded',
    fileName: 'cuenta-corriente.xlsx',
    sheetName: 'Facturas',
  }}
/>

Try the complete DyonaGrid example in the Lab

exportExcel

Set enabled: true to show the export button in the grid toolbar. V1 supports only mode: 'loaded' and exports the rows currently loaded by the grid.

For remote grids, export does not fetch or export every page. It exports only the currently loaded page; no additional Data Source requests are made.

fileName controls the downloaded file name. DyonaGrid adds .xlsx when it is missing; the fallback is dyona-grid.xlsx. sheetName controls the worksheet name and defaults to Data.

Exported data

The export includes only visible data columns, in their current logical order. Reordered columns keep their order; hidden columns are excluded. Selection, Actions, and delete columns are technical columns and are never exported.

Cell values retain their semantic value when they are strings, numbers, or booleans. null and undefined become empty cells. The export does not execute renderCell or export React content. Image-formatted columns export their original URL or string value rather than embedding an image.

Aggregates and the Grid footer are not exported in V1.