PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Different errors
  • Equivalent function
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns the caption of the last error caused by an XLS function.
Versions 16 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 16
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectories\File.XLS")
IF XLSFileID <> -1 THEN
...
ELSE
// An error occurred in the XLS file
ResError = xlsMsgError(XLSFileID)
...
END
Syntax

Syntax that is using the xlsDocument type Hide the details

<Result> = xlsMsgError(<XLS Document>)
<Result>: Character string
  • Caption of last error that occurred on the XLS file,
  • Empty string ("") if no error occurred.
<XLS Document>: xlsDocument variable
Name of xlsDocument variable corresponding to the current XLS file.

Syntax kept for backward compatibility with version 12 Hide the details

<Result> = xlsMsgError(<Identifier of XLS File>)
<Result>: Character string
  • Caption of last error that occurred on the XLS file,
  • Empty string ("") if no error occurred.
<Identifier of XLS File>: Integer
Identifier of current XLS file, returned by xlsOpen.
Remarks

Different errors

The errors that can occur on the XLS functions are as follows:
  • The XLS file is not found, does not exist, is not opened, is not valid or cannot be opened.
  • The specified row and/or column are empty or do not exist.
  • Insufficient memory to open the file.
  • The version of Excel used is unknown or too old (the XLS functions cannot read the files in Excel version 2 or earlier).

Equivalent function

ErrorInfo (associated with the errMessage constant) also returns the caption of the last error that occurred.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230xls.dll
Linux wd230xls.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment