Displays a link XLSX is a native file format for Microsoft Excel versions 2007 and later. Using XLSX files solves some confusion users experience with CSV file exports; e.g. string values with numbers can be interpreted as floating points, so information appears to be lost.
When the "xlsx export" grid property is true, a link appears in the footer bar, allowing the user to export grid data to Excel using the XLSX format, a native format for Excel 2007 and later.NOTE: Multiple fields within a column will not be exported. Only the first field within a column will be exported with this option.
Promptable? YES
Possible Values: true, false (defaults to false)
Bindable? YES (Rich Display Only)
Products: Rich Display, Genie.
When the link is clicked, the browser prompts the user to save or open the file:
The filename presented to the user can be set using the "export file name" property. Columns headings are exported when the "export with headings" property is true.
Exporting from Handler-driven Grids
Load-all grids can export up to 9999 records. Paging grids only export data from the currently visible page. Grid columns containing only image widgets or buttons are not included in the export. When a column contains multiple fields, only the first field within the column will be exported.
The data-type of the field determines the cell formatting used in the exported XLSX file. For example, data from character fields (data type A) become text-formatted cells. Data from numeric fields become number-formatted cells. Decimal-separator types *I and *J are supported: excel internally stores numbers without decimal separators, but the user's operating system settings determine how these numbers are displayed. Date, time, and timestamps are stored as text cells to preserve the original IBM i formatting.
Exporting from Database-Driven or Custom URL Grids
Database-driven grids and Custom URL grids can export more than 9999 records. The grid attempts to read the database field's data type and choose an appropriate cell formatting. If the field's type cannot be determined, then the data is stored as text-cells to avoid misinterpretation. When a column is computed, the result of an SQL expression, or the data source is "custom url", then the field's data type cannot be read.