PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
ConstantAffectsDetailsUsed by the functions
Versions 20 and later
xlsColumnNum
New in version 20
xlsColumnNum
xlsColumnNum
Type of coordinate to returnColumn number.
Versions 20 and later
xlsNameToCoordinates
New in version 20
xlsNameToCoordinates
xlsNameToCoordinates
xlsCompatibleMode for opening an XLS fileOpening mode compatible with the earlier versions of WINDEV and WEBDEV (manage the first sheet of the workbook only)xlsOpen
xlsDataErrorError (constant kept for backward compatibility)Constant returned if an error occursxlsData
Versions 20 and later
xlsRowNum
New in version 20
xlsRowNum
xlsRowNum
Type of coordinate to returnRow number.
Versions 20 and later
xlsNameToCoordinates
New in version 20
xlsNameToCoordinates
xlsNameToCoordinates
xlsTitleErrorErrorConstant returned if an error occursxlsColumnTitle
xlsTypeCurrencyType of data typed"Currency" columnxlsColumnType, xlsCell variable.
xlsTypeDateType of data typed"Date" columnxlsColumnType, xlsCell variable.
xlsTypeDateTimeType of data typed"DateTime" columnxlsColumnType, xlsCell variable.
xlsTypeDoubleType of data typed"Numeric" columnxlsColumnType, xlsCell variable.
xlsTypeDurationType of data typed"Duration" columnxlsColumnType, xlsCell variable.
xlsTypeEmptyType of data typedColumn entirely emptyxlsColumnType
xlsTypeErrorErrorConstant returned if an error occursxlsColumnType, xlsCell variable.
xlsTypeStringType of data typed"Character string" column or column containing different types of dataxlsColumnType, xlsCell variable.
xlsTypeTimeType of data typed"Time" columnxlsColumnType, xlsCell variable.
xlsWriteMode for opening an XLS fileOpens the Excel file in "Read/Write" mode: the XLS file is opened and locked until it is closed.xlsOpen
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment