PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Prints the current worksheet of a document in "xlsx" or "xls" format.
Example
MonXLSX is string = "c:\temp\Comptes.xlsx"
iDestination(iViewer)
iPrintXLS(MonXLSX)
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 sheets, it is necessary to use a variable of type xlsDocument and to change the number of the current sheet via Property Sheet.
Business / UI classification: Neutral code
Component: wd270etat.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
video iPrintXLS
https://youtu.be/p3hJtI4hOgY
https://windevdesenvolvimento.blogspot.com/2019/08/dicas-2245-windev-webdev-mobile-24.html
// BTN_IMPRIME_EXCEL
sArquivo_imprimir is string=EDT_PROCURA_ARQUIVO_eXCEL
iPreview(ipvZoom100)
iPrintXLS(sArquivo_imprimir)
amarildo
12 Aug. 2019