|
|
|
|
|
|
|
|
|
|
- Managing the Graphic worksheets
xlsNbWorksheet (Function) In french: xlsNbFeuille Returns the number of worksheets found in an XLS file. Note: In compatible mode, the number of sheets is always set to 1.
 New in version 2025FileIdentifier is int
FileIdentifier = xlsOpen("C:\My documents\MyFile.XLS")
IF FileIdentifier <> -1 THEN
Info("The file contains " + xlsNbWorksheet(FileIdentifier) + " worksheets.")
END
Syntax
Syntax that uses the xlsDocument type Hide the details
<Result> = xlsNbWorksheet(<XLS document>)
<Result>: Integer - Number of worksheets found in the XLS file,
- -1 if an error occurred. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.
<XLS document>: xlsDocument variable Name of the xlsDocument variable corresponding to the XLS file to close. The physical file associated with this variable (if it exists) is closed. The modifications performed in the file will not be saved before it is closed (use xlsSave if necessary).
Syntax kept for backward compatibility with version 12 Hide the details
<Result> = xlsNbWorksheet(<XLS file identifier>)
<Result>: Integer - Number of worksheets found in the XLS file,
- -1 if an error occurred. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.
<XLS file identifier>: Integer Identifier of the XLS file to handle, returned by xlsOpen. Remarks Managing the Graphic worksheets The Excel "Graphic" worksheets are ignored. Indeed, these worksheets have no cell and therefore they cannot be accessed.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|