PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Excel version of an XLS file
xlsVersion (Example)
Excel version of an XLS file
The following code allows you to identify the Excel version that was used to save an XLS file.
// Declare the variables
XLSFileID is int
ResVersion is int
...
// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectories\MyFiles\File.XLS")
// Excel version
ResVersion = xlsVersion(XLSFileID)
SWITCH ResVersion
CASE 0: Error(xlsMsgError(XLSFileID))
CASE 3: Info("The version used is Excel 3")
CASE 4: Info("The version used is Excel 4")
CASE 5: Info("The version used is Excel 95")
CASE 8: Info("The version used is Excel 97 or Excel 2000")
END
// Close the XLS file
xlsClose(XLSFileID)
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment