Constants for managing the XLS files - PC SOFT - Online documentation

PC SOFT

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

Windows

Linux

Universal Windows 10 App

Java

Reports and Queries

User code (UMC)

WEBDEV

Windows

Linux

PHP

WEBDEV - Browser code

WINDEV Mobile

Android

iPhone/iPad

Apple Watch

Mac Catalyst

Universal Windows 10 App

Others

Stored procedures

Constants for managing the XLS files

Constant	Description	Detail	Used by the functions

Versions 20 and later xlsColumnNum New in version 20 xlsColumnNum xlsColumnNum	Type of coordinate to return	Column number.	Versions 20 and later xlsNameToCoordinates New in version 20 xlsNameToCoordinates 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
Versions 20 and later xlsRowNum New in version 20 xlsRowNum xlsRowNum	Type of coordinate to return	Row number.	Versions 20 and later xlsNameToCoordinates New in version 20 xlsNameToCoordinates xlsNameToCoordinates
xlsTitleError	Error	Constant returned if an error occurs	xlsColumnTitle
xlsTypeCurrency	Type of data typed	"Currency" column	xlsColumnType, xlsCell variable.
xlsTypeDate	Type of data typed	"Date" column	xlsColumnType, xlsCell variable.
xlsTypeDateTime	Type of data typed	"DateTime" column	xlsColumnType, xlsCell variable.
xlsTypeDouble	Type of data typed	"Numeric" column	xlsColumnType, xlsCell variable.
xlsTypeDuration	Type of data typed	"Duration" column	xlsColumnType, xlsCell variable.
xlsTypeEmpty	Type of data typed	Column entirely empty	xlsColumnType
xlsTypeError	Error	Constant returned if an error occurs	xlsColumnType, xlsCell variable.
xlsTypeString	Type of data typed	"Character string" column or column containing different types of data	xlsColumnType, xlsCell variable.
xlsTypeTime	Type of data typed	"Time" column	xlsColumnType, xlsCell variable.
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

See also

Minimum version required

Version 9

This page is also available for…

Comments

Click [Add] to post a comment

Last update: 09/01/2021

Send a report | Local help

Close this window

Searching...

Annotate the page

Title:

I accept the terms of the license agreement

How to browse local help?

All you have to do is configure your product as follows:

Go to "Home .. Options .. General options of …".
In the "Help" tab, select "Use the local help database" and specify (if necessary) the path of the "Help" directory of your product.
Validate. The help used by default will be the local help installed on your computer.