|
|
|
|
|
|
|
|
|
|
iSequencingAddXLS (Function) In french: iEnchaînementAjouteXLS Adds a print of XLS or XLSX document into a sequence of report prints.
Note: Report print chaining allows you to print different reports in succession, visible as a single printout in the report viewer. You can add various types of documents in this sequence. For more details, see Sequencing reports. 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:- a variable of type xlsDocument.
- a Spreadsheet control.
- an 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 Full path of a Spreadsheet file (XLS or XLSX file). <Password>: Optional string or Secret string - Password to open the XLS or XLSX file to use,
- Empty string ("") if the file has no password.
 New in version 2025Secret strings: If you use the secret string vault, the type of secret string used for this parameter must be "ANSI or Unicode string". To learn more about secret strings and how to use the vault, see Secret string vault.
Remarks - XLS or XLSX documents are actually added when iSequencingPrint is called.
- The numbering of Excel pages is ignored.
- Only the current worksheet of XLS or XLSX document is added. To add other worksheets, use a variable of type xlsDocument and change the number of current worksheet with the Worksheet property.
Business / UI classification: Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|