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
xlsNbColumns (Function)
In french: xlsNbColonnes
Warning
xlsNbColumns is kept for backward compatibility.
In this version, use xlsNbColumn.
Below is the documentation of xlsNbColumns, available in WINDEV 5.5
 
Purpose
Finding out the number of columns in an XLS file.
Syntax (using the xlsDocument type)
<Result> = xlsNbColumns(<XLS Document>)
  • <Result> is an integer corresponding to the number of columns.
  • <XLS document> is the name of the xlsDocument variable corresponding to the XLS file to use.
Syntax (version 12 compatibility)
<Result> = xlsNbColumns(<FileNum>)
  • <Result> is an integer corresponding to the number of columns.
  • <FileNum> is an integer containing the file identifier returned by xlsOpen
Details
xlsNbColumns returns the number of columns in the XLS file. The empty columns are ignored. For example, in the following case, xlsNbColumns returns 4:
nomFirst nameAgeOccupation
DavonJohn18Student
SmithJack19Student
MontgomeryJohn20Student
Remarks
This function implies that the XLS file has a database structure, which means that a fixed number of columns corresponds to each row.
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