• Login

DataSoft Corporation

Export XLSX Specific Options

An XLSX file is an Excel spreadsheet created by Microsoft Excel or another spreadsheet program, such as OpenOffice Calc or Apple Numbers.

When exporting a document, you can define XLSX specific export options using the following dialog. 

previewExportOptionsXLSX

  • 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, with each shown in a separate sheet.
    • The Different files mode allows export of a document to multiple files, one for each document page.
  • Specifies how a document is exported to XLSX. 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 XLSX file.
  • Text export mode
  • Specifies 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
  • Specifies whether grid lines should be visible in the resulting XLSX file.
  • Export hyperlinks
  • Specifies whether to include hyperlinks into the resulting file.
  • Raw data mode
  • Specifies whether to enable the raw data export mode. In this mode, only a document's actual data is exported to XLSX, ignoring non-relevant elements, such as images, graphic content, font and appearance settings.
Monday, 14 January 2019 Posted in Preview, Print and Export Reports