Prints the current worksheet of a document in "xlsx" or "xls" format.
MyXLSX is string = "c:\temp\Accounts.xlsx"
iDestination(iViewer)
iPrintXLS(MyXLSX)
Syntax
Printing the content of a Spreadsheet control or xlsDocument variable Hide the details
<Result> = iPrintXLS(<Document>)
<Result>: Boolean
- True if the document was sent to the print spooler,
- False otherwise. To get the details of the error, use ErrorInfo with the errMessage constant.
<Document>: Corresponding type
XLS or XLSX document to print. This document corresponds to:- a variable of type xlsDocument.
- the path of a Spreadsheet file (XLS or XLSX file).
- an HFSQL memo corresponding to an XLS or XLSX document.
Printing the content of an "xlsx" or "xls" document Hide the details
<Result> = iPrintXLS(<Path> [, <Password>])
<Result>: Boolean
- True if the document was sent to the print spooler,
- False otherwise. To get the details of the error, use ErrorInfo with the errMessage constant.
<Path>: Character string
Path of a Spreadsheet file (XLS or XLSX file).
<Password>: Optional character string
Password to open the XLS or XLSX file to be printed.
Remarks
Only the current worksheet of XLS or XLSX document is printed. To print other worksheets, use a variable of type
xlsDocument and change the number of current worksheet with the
Worksheet property.
Business / UI classification: Neutral code