PC SOFT

ONLINE HELP
 WINDEV, WEBDEV 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 find out the name of the error, use the function ErrorInfo with the constant errMessage.
<Document>: Corresponding type
XLS or XLSX document to print. This document corresponds to:
  • an xlsDocument variable.
  • the path of a Spreadsheet file (XLS or XLSX file).
  • a 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 find out the name of the error, use the function ErrorInfo with the constant errMessage.
<Path>: Character string (with quotes)
Path of a Spreadsheet file (XLS or XLSX file).
<Password>: Optional character string (with quotes)
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 an xlsDocument variable and change the number of current worksheet via ..Worksheet.
Business / UI classification : Neutral code
Component : wd260etat.dll
See also
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