Excel export PRO
Export data to a spreadsheet file.
Options
Changes below update the Grid and code immediately.
Prepare sample or edited orders and check needed columns and numeric values.
View code
Sample data included in the code · 6 rows
Usage guide
#Continue working with orders in Excel or share them as a workbook.
Try it yourself
- Review the current table
Prepare sample or edited orders and check needed columns and numeric values.
- Click Excel
Click Excel above the table to request syidax-orders.xlsx.
- Open the workbook
Open the file in Excel or another compatible app and compare headings and numbers with the table.
Save order data in a spreadsheet workbook.
This is a Pro feature. Webpage buttons, tooltips, and cell renderers are not reproduced verbatim in workbooks; inspect export settings for required output.
Useful terms
- XLSX
- An Excel workbook file format.
- exportDataAsExcel
- A method exporting current Grid data to a workbook.
Key API examples
Application code that references the registered Grid element as grid.
await grid.exportDataAsExcel({fileName:'orders.xlsx'});Using this feature in your product requires the Pro runtime and a valid license.
API reference
#Methods2
| Method / Arguments | Return type | Description |
|---|---|---|
PRO options?: {
sheetName?: string;
onlySelected?: boolean;
columnKeys?: readonly string[];
skipHeaders?: boolean;
} | Promise<Uint8Array> | serialize the current rows + visible columns to XLSX bytes. |
PRO options?: {
fileName?: string;
sheetName?: string;
onlySelected?: boolean;
columnKeys?: readonly string[];
skipHeaders?: boolean;
} | Promise<void> | build the XLSX workbook and trigger a browser download. |
Explore each feature
Learn when to use each feature and how to configure it. Each guide identifies live examples and features you connect in your app.