exportXLSX( file )



This method initiates a file download of the grid data in the Excel XLSX file format. Ā The call to this method can be attached to a button or a similar element's onclick event to initiate the download manually instead of using the "xlsx export" property on the grid, which creates a paging bar with an export link. Ā The data is output in XLSX (Microsoft Excel Spreadsheet) format. Ā If the grid's "export with headings" property is set to true, grid headings are exported in addition to the grid data.

Parameters:

  • file - specifies the default file name given to the XLSX file (Optional); the file extension should not be part of this name since ".xlsx" is automatically appended; if the file name parameter is omitted, the id of the grid is used

Example:

getObj("Grid1").grid.exportXLSX("invoices");



Note: This API is available in Profound UI Version 5, Fix Pack 14.1 and newer.