PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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
xlsMsgError (Function)
In french: xlsMsgErreur
Returns the caption of the last error caused by an XLS function.
Versions 16 and later
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
New in version 16
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Example
// 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 the 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 (with the constant errMessage) also returns the caption of the last error that occurred.
Component: wd260xls.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment