PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV 24 feature!
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
Adds a print of XLS orXLSX document into a sequence of report prints.
Example
MyDocument is Document = "c:\temp\generalconditions.docx"
MySpreadsheet is string = "c:\temp\prices.xls"
 
iPreview()
// Add reports into the sequence
iSequencingAdd(RPT_Report_Portrait)
iSequencingAdd(RPT_Report_Landscape, 3)
// Add the general conditions in document format
iSequencingAddDoc(MyDocument)
// Add prices in the format of an XLS worksheet
iSequencingAddXLS(MySpreadsheet)
iSequencingPrint()
Syntax

Adding an XLS or XLSX document to a report printing sequence Hide the details

iSequencingAddXLS(<Document>)
<Document>: Character string
XLS or XLSX document to print. This document corresponds to:
  • an xlsDocument variable.
  • a Spreadsheet control.
  • a HFSQL memo corresponding to an XLS or XLSX document.

Adding an XLS or XLSX file to a report printing sequence Hide the details

iSequencingAddXLS(<File> [, <Password>])
<File>: Character string (with quotes)
Full path of a Spreadsheet file (XLS or XLSX file).
<Password>: Optional character string (with quotes)
  • Password to open the XLS or XLSX file to use,
  • Empty string ("") if the file has no password.
Remarks
  • The XLS or XLSX documents are actually during the call to iSequencingPrint.
  • The numbering of Excel pages is ignored.
  • Only the current worksheet of XLS or XLSX document is added. To add other worksheets, use an xlsDocument variable and change the number of current worksheet via ..Worksheet.
Component : wd240etat.dll
See also
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment