xlsColumnTitle (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Column caption
Managing errors

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

xlsColumnTitle (Function)

In french: xlsTitreColonne

Retrieves the title of a column found in an XLS file. The result depends on the opening mode of XLS file:

In multi-sheet mode, the column title is sought for the worksheet selected by xlsCurrentWorksheet.
In compatible mode, the column title is always sought for the first worksheet of workbook.

Remark: The title of a column in an XLS file is returned if:

The XLS file exists.
The XLS file is opened.

Versions 16 and later

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

New in version 16

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

Example

See additional examples

// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectory\File.XLS")
IF XLSFileID <> -1 THEN
// Retrieve the caption of a column
ResColumnTitle = xlsColumnTitle(XLSFileID, 4)
...
END

Syntax

Syntax that is using the xlsDocument type Hide the details

<Result> = xlsColumnTitle(<XLS document> , <Column number> [, <Empty columns>])

<Result>: Character string

Caption of specified column,
xlsTitleError constant if an error occurred. For more details on the error, use xlsMsgError or ErrorInfo with the constant errMessage.

<XLS document>: xlsDocument variable

Name of xlsDocument variable corresponding to the XLS file to use.

<Column number>: Integer

Number of the column to read.

<Empty columns>: Optional boolean

Mode for taking the empty columns into account:
True
(by default) The columns that are entirely empty are ignored
False The columns that are entirely empty are taken into account

Syntax kept for backward compatibility with version 12 Hide the details

<Result> = xlsColumnTitle(<XLS file identifier> , <Column number> [, <Empty columns>])

<Result>: Character string

Caption of specified column,
xlsTitleError constant if an error occurred. For more details on the error, use xlsMsgError or ErrorInfo with the constant errMessage.

<XLS file identifier>: Integer

Identifier of XLS file to handle, returned by xlsOpen.

<Column number>: Integer

Number of the column to read.

<Empty columns>: Optional boolean

Mode for taking the empty columns into account:
True
(by default) The columns that are entirely empty are ignored
False The columns that are entirely empty are taken into account

Remarks

Column caption

The empty columns can be taken into account or not. For example:

xlsColumnTitle(XLSFileID, 3, True) // Returns "Age"
xlsColumnTitle(XLSFileID, 3, False) // Returns ""

Managing errors

xlsColumnTitle throws an error in the following cases:

The specified column does not exist (negative column for example).
The specified XLS file is not opened.

Component: wd270xls.dll