ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Constants for managing XLS files
ConstantDescriptionDetailUsed by the functions
xlsColumnNumType of coordinate to returnColumn number.xlsNameToCoordinates
xlsCompatibleOpening mode of 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
xlsMergeAndCenterCell merging modeMerges the cells and centers the contents.xlsMergeCell
xlsMergeSimpleOpening mode of an XLS fileMerges the cells without centering the contents.xlsMergeCell
xlsRowNumType of coordinate to returnRow number.xlsNameToCoordinates
xlsTitleErrorErrorConstant returned if an error occursxlsColumnTitle
xlsTypeCurrencyType of data typed"Currency" columnxlsColumnType, variable of type xlsCell.
xlsTypeDateType of data typed"Date" columnxlsColumnType, variable of type xlsCell.
xlsTypeDateTimeType of data typed"DateTime" columnxlsColumnType, variable of type xlsCell.
xlsTypeDoubleType of data typed"Numeric" columnxlsColumnType, variable of type xlsCell.
xlsTypeDurationType of data typed"Duration" columnxlsColumnType, variable of type xlsCell.
xlsTypeEmptyType of data typedColumn entirely emptyxlsColumnType
xlsTypeErrorErrorConstant returned if an error occursxlsColumnType, variable of type xlsCell.
xlsTypeStringType of data typed"Character string" column or column containing different types of dataxlsColumnType, variable of type xlsCell.
xlsTypeTimeType of data typed"Time" columnxlsColumnType, variable of type xlsCell.
New in version 2024
xlsVersionUndefined
File formatThe format will be defined when the file is Record.. xlsDocument variable
New in version 2024
xlsVersionXls
File formatDocument type XLS. xlsDocument variable
New in version 2024
xlsVersionXlsx
File formatDocument type XLSX. xlsDocument variable
xlsWriteOpening mode of an XLS fileOpens the Excel file in "Read/Write" mode: the XLS file is opened and locked until it is closed.xlsOpen
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/05/2024

Send a report | Local help