|
|
|
|
|
xlsNbColumns (Function) In french: xlsNbColonnes
Warning
xlsNbColumns is kept for backward compatibility. 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: | | | | | nom | First name | | Age | Occupation | Davon | John | | 18 | Student | Smith | Jack | | 19 | Student | Montgomery | John | | 20 | Student |
Remarks This function implies that the XLS file has a database structure, which means that a fixed number of columns corresponds to each row. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|