The XLSX output option displays the label in a Microsoft Excel Workbook format file.
Syntax:
LBLPRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION XLSX
The following OPTION parameters are available to customize the output:
Parameter |
Value |
Description |
FILENAME |
value |
Specifies the full path and filename. If no path is defined, output will be saved in the current working directory. |
PASSWORD |
value |
Specifies the password for the Excel file. Passwords are case sensitive. |
SHOW_CANCEL_DIALOG |
ON (default) OFF |
Specifies whether to suppress cancel dialog box during the print process. |
ROW_SPACING |
value |
Specifies the spacing between spreadsheet rows. |
COLUMN_SPACING |
value |
Specifies the spacing between spreadsheet columns. |
INCLUDE_IMAGES |
ON OFF |
Specifies whether image objects on the report should be included in the exported file. |
INCLUDE_TEXT |
ON OFF |
Specifies whether text is included in the exported file. |
PAGES_PER_WORKSHEET |
ON OFF |
Specifies the page limit per worksheet. |
PRINT_GRID_LINES |
ON OFF |
Specifies whether grid lines are displayed in the exported file. |
PASS_SETTINGS |
value |
Specifies the number of times a report traverses the data before generating pages. |
OPEN |
ON OFF |
Specifies whether the report should be opened after it is generated. |
ON OFF |
Specifies the report output (defined as FILENAME filename.ext ) to be sent via e-mail as an attachment. See additional options when EMAIL value is set to ON. EMAIL SET ON |
Notes:
•Each additional OPTION parameter must be separated by the pipe | symbol.
•When printing to the XLS format, the report objects must be spaced apart appropriately or "padded" in order for the report data to appear correctly in the Excel report output. Experimenting with vertical and horizontal will also allow you to attain your desired output. Also, please refrain from using elaborate fonts that may not be supported within Excel.
Example:
--To print a label as a XLS file
LBLPRINT CustomerLabels WHERE CustID = 128 +
OPTION XLS +
|FILENAME CustLab128.XLS +
|SHOW_CANCEL_DIALOG OFF +
|ROW_SPACING 1 +
|COLUMN_SPACING 1 +
|PRINT_GRID_LINES ON +
|OPEN ON
