PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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.
Remark: The sequence of report prints allows you to print different reports one after another, and view them as one in the report viewer. You can add various types of documents in this sequence. See Sequencing reports for more details.
Example
MyDocument is Document = "c:\temp\generalconditions.docx"
MySpreadsheet is string = "c:\temp\prices.xls"
 
// Print in the report viewer
iDestination(iViewer)
// 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:
  • 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.
Business / UI classification : Neutral code
Component : wd250etat.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment