This document describes the specifics of exporting a document to an XLSX
format, introduced by Microsoft in Excel® 2007.
When exporting a document, you can define XLSX-specific export options using the following dialog.
Export mode
Choose one of the available modes to export a document.
- The Single file mode allows export of a document to a single file, without dividing it into pages.
- The Single file page-by-page mode allows export of a document to a single file, with each shown in a separate sheet.
- The Different files mode allows export of a document to multiple files, one for each document page.
Page range
Define the pages which will be included in the result. Separate page numbers with commas; set page ranges using hyphens.
Sheet name
Define the sheet name.
Text export mode
Choose whether value formatting should be converted to the native XLSX format string (if it is possible), or embedded into cell values as plain text.
Show grid lines
Check if it's required to show grid lines in the resulting XLSX file.
Export hyperlinks
Check if it's required to export hyperlinks.
The XSLX format supports a greater number of rows and columns than the XLS format does (16,384
columns and 1,048,576 rows, as opposed to only 256 columns and
65,536 rows in XLS).
Note
Note that only the report controls that don't intersect with each
other can be correctly exported to XLSX. In other cases, the resulting XLSX file
may have a completely broken layout.
To make sure that your report layout will be preserved in your desired format check to ensure there are no exclamation marks shown for intersecting controls
Following is the list of custom text formats that are supported when
exporting data to the XLSX format.
Note
Email This Article
Previous Article
Next Article