Export XLS Specific Options
XLS is a file extension for a spreadsheet file format created by Microsoft for use with Microsoft Excel. Microsoft Excel files use a proprietary format for storing Microsoft Excel documents. This file format is known as the Binary Interchange File Format (BIFF).
When exporting a document, you can define XLS-specific export options using the following dialog.
- Export mode
- 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, divided into pages.
- The Different files mode allows export of a document to multiple files, one for each document page.
- Specifies how a document is exported to XLS. The following modes are available.
- Page range
- Specifies a range of pages which will be included in the resulting file. To separate page numbers, use commas. To set page ranges, use hyphens.
- Sheet name
- Specifies the name of the sheet in the created XLS file.
- Text export mode
- Specifies whether value formatting should be converted to the native XLS format string (if it is possible), or embedded into cell values as plain text.
- Show grid lines
- Specifies whether grid lines should be visible in the resulting XLS file.
- Export hyperlinks
- Specifies whether hyperlinks should be exported to the XLS document.
- Raw data mode
- Specifies whether to enable the raw data export mode. In this mode, only a document's actual data is exported to XLS, ignoring non-relevant elements, such as images, graphic content, font and appearance settings.
Monday, 14 January 2019
Posted in Preview, Print and Export Reports