iSequencingAddXLS (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InitRequestConnection

iChangeSubReportSource

iInitReportQueryConnection

iReportPrintingStatus

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

iSequencingAddXLS (Function)

In french: iEnchaînementAjouteXLS

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

MonDocument is Document = "c:\temp\conditiongenerales.docx"
MonTableur is string = "c:\temp\tarif.xls"

// Impression dans le visualisateur de rapports
iDestination(iViewer)
// Ajout des états dans l'enchaînement
iSequencingAdd(ETAT_Etat_Portrait)
iSequencingAdd(ETAT_Etat_Paysage, 3)
// Ajout des conditions générales sous forme d'un document
iSequencingAddDoc(MonDocument)
// Ajout des tarifs sous forme d'une feuille XLS
iSequencingAddXLS(MonTableur)
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 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: wd260etat.dll