| | | |
Constant | Description | Detail | Used by the functions |
---|
xlsColumnNum | Type of coordinate to return | Column number. | xlsNameToCoordinates |
xlsCompatible | Opening mode of an XLS file | Opening mode compatible with the earlier versions of WINDEV and WEBDEV (manage the first sheet of the workbook only) | xlsOpen |
xlsDataError | Error (constant kept for backward compatibility) | Constant returned if an error occurs | xlsData |
New in version 28xlsMergeAndCenter | Cell merging mode | Merges the cells and centers the contents. | |
New in version 28xlsMergeSimple | Opening mode of an XLS file | Merges the cells without centering the contents. | |
xlsRowNum | Type of coordinate to return | Row number. | xlsNameToCoordinates |
xlsTitleError | Error | Constant returned if an error occurs | xlsColumnTitle |
xlsTypeCurrency | Type of data typed | "Currency" column | xlsColumnType, variable of type xlsCell. |
xlsTypeDate | Type of data typed | "Date" column | xlsColumnType, variable of type xlsCell. |
xlsTypeDateTime | Type of data typed | "DateTime" column | xlsColumnType, variable of type xlsCell. |
xlsTypeDouble | Type of data typed | "Numeric" column | xlsColumnType, variable of type xlsCell. |
xlsTypeDuration | Type of data typed | "Duration" column | xlsColumnType, variable of type xlsCell. |
xlsTypeEmpty | Type of data typed | Column entirely empty | xlsColumnType |
xlsTypeError | Error | Constant returned if an error occurs | xlsColumnType, variable of type xlsCell. |
xlsTypeString | Type of data typed | "Character string" column or column containing different types of data | xlsColumnType, variable of type xlsCell. |
xlsTypeTime | Type of data typed | "Time" column | xlsColumnType, variable of type xlsCell. |
xlsWrite | Opening mode of an XLS file | Opens the Excel file in "Read/Write" mode: the XLS file is opened and locked until it is closed. | xlsOpen |