ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Print functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Prints the current worksheet of a document in "xlsx" or "xls" format.
Example
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 more details on 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 more details on 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
Component: wd300etat.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/24/2024

Send a report | Local help