ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
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
xlsNbRows (Function)
In french: xlsNbLignes
Warning
The xlsNbRows function is retained only for compatibility.
In this version, use xlsNbRow.
Here is the documentation of the function xlsNbRows available with WINDEV 5.5.
 
Purpose
Finding out the number of rows in an XLS file.
Syntax (using the xlsDocument type)
<Result> = xlsNbRows(<XLS Document>)
  • <Result> is an integer.
  • <XLS document> is the name of the xlsDocument variable corresponding to the XLS file to use.
Syntax (version 12 compatibility)
<Result> = xlsNbRows(<FileNum>)
  • <Result> is an integer.
  • <FileNum> is an integer containing the file identifier returned by xlsOpen.
Details
xlsNbRows returns:
  • the number of rows in an XLS file: The empty rows are ignored.
  • -1 if an error occurred: xlsError returns the error details
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help