ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Managing the Graphic worksheets
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
xlsNbWorksheet (Function)
In french: xlsNbFeuille
Returns the number of worksheets found in an XLS file.
Remark: In compatible mode, the number of worksheets is always equal to 1.
New in version SaaS
Android This function is now available for Android applications.
Android Widget This function is now available in Android widget mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
Example
FileIdentifier is int

// Open an XLS file
FileIdentifier = xlsOpen("C:\My documents\MyFile.XLS")
IF FileIdentifier <> -1 THEN
	// Retrieve the numbers of worksheets found in the file
	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.
Component: wd300xls.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help