|
|
|
|
- Number of rows in an XLS file
Number of rows in an XLS file The following code is used to find out the number of rows in an XLS file. The rows that are entirely empty are not taken into account ( True). This file was opened by xlsOpen. // Declare the variables XLSFileID is int ResNbRows is int // Open an XLS file XLSFileID = xlsOpen("C:\MyDirectories\MyFiles\File.XLS") IF XLSFileID <> -1 THEN // Number of rows ResNbRows = xlsNbRow(XLSFileID, True) IF ResNbRows <> -1 THEN IF ResNbRows = 0 THEN // No row was found Info("The XLS file contains no row") ELSE // Display the number of rows Info("The file contains: " + ResNbRows + "rows") END ELSE // Display the error message Error(xlsMsgError(XLSFileID)) END ELSE // Display an error message if the opening was not performed Error(xlsMsgError(XLSFileID)) END // Close the XLS file xlsClose(XLSFileID)
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|