xlsDocument (Type of variable)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Functions for managing XLS files

Properties specific to the description of xlsDocument variables

Accessing a column of an Excel document

Accessing a cell of an Excel document

Accessing a cell of a column in an Excel document

Accessing a cell of a row in an Excel document

Functions that use the xlsDocument variables

Related examples

See also

xlsDocument (Type of variable)

In french: xlsDocument (Type de variable)

An xlsDocument variable is used to describe and modify an Excel document.

Note: See Declaring a variable for more details.

Versions 16 and later

This type of variable is now available in WINDEV Linux.

This type of variable is now available in WEBDEV Linux.

New in version 16

This type of variable is now available in WINDEV Linux.

This type of variable is now available in WEBDEV Linux.

This type of variable is now available in WINDEV Linux.

This type of variable is now available in WEBDEV Linux.

Example

See additional examples

MyWorksheet is xlsDocument
NameXLSFile is string
NameXLSFile = fSelect(fExeDir(), "", "Select a file...", ...
"All files (*.*)" + TAB + "*.*", "*", fselOpen + fselExist)
IF NameXLSFile = "" THEN RETURN
MyWorksheet = xlsOpen(NameXLSFile, xlsWrite)

// Write OK in the A25 cell
MyWorksheet[25,"A"] = "OK"
// Save
xlsSave(MyWorksheet)

XLSFileID is xlsDocument
NameXLSFile is string = fExeDir + "\Business info1.xls"

XLSFileID = xlsOpen(NameXLSFile, xlsWrite)
IF ErrorOccurred = False THEN
Azz is int = xlsCurrentWorksheet(XLSFileID)
Info("Current worksheet in the Excel file: " + Azz)
// Change worksheet
IF xlsCurrentWorksheet(XLSFileID, 2) = True THEN
Info("The current worksheet was modified.")
// Read a cell for test
Info(xlsData(XLSFileID, 11, 2))
ELSE
Error("The selected file does not include a second worksheet!")
END
ELSE
Error("Caution, the file is already opened on a computer!")
END

Remarks

Properties specific to the description of xlsDocument variables

The following properties can be used to handle an xlsDocument variable:

Name	Type used	Effect

Cell	Array of xlsCell	Cells in the XLS document.
Column	Array of xlsColumn	Column in the XLS document.
Versions 17 and later RightToLeft New in version 17 RightToLeft RightToLeft	Boolean	True if the mode for reading the current worksheet is "Right to left". False if the mode for reading the current worksheet is "Left to right".
Worksheet	Integer	Number of the current worksheet (identical to xlsCurrentWorksheet).
File	Character string	Name and full path of XLS file associated with the document. This property is available in read-only. It is assigned when using xlsOpen. Note: when assigning an xlsDocument variable into another one, this property is not copied (except during the call to xlsOpen).
Row	Array of xlsRow	Row in the XLS document.
Modified	Boolean	True if the document was modified False otherwise. This property is reset to False after the call to xlsSave.
NumberColumn	Integer	Number of columns found in the document (identical to xlsNbColumn). This property is available in read-only.
NumberWorksheet	Integer	Number of worksheets found in the document (identical to xlsNbWorksheet). This property is available in read-only.
NumberRow	Integer	Number of rows found in the document (identical to xlsNbRow). This property is available in read-only.
LeafName	Character string	Name of current worksheet. This property can correspond to a string containing between 1 and 31 characters. It is case insensitive.
Versions 17 and later RecalculateWhenLoading New in version 17 RecalculateWhenLoading RecalculateWhenLoading	Boolean	True if the formulas of the document must be recalculated when the document is opened in Excel or OpenOffice. False if no calculation must be performed when the document is opened in Excel or OpenOffice. Note: Only the formulas initially found in the document can be recalculated.
Version	Integer	Version of XLS document (identical to xlsVersion). This property is available in read-only.

Note: These properties can be used with one of the following syntaxes:

<Variable Name>..<Property Name>
<Variable Name>.<Property Name>

Accessing a column of an Excel document

The following syntaxes can be used to access a column of an Excel document:

MyXLSDocument.Column[1]: Accesses the column 1 of the Excel file.
MyXLSDocument.Column["A"]: Accesses the column A of the Excel file.

Accessing a cell of an Excel document

The following syntaxes can be used to access a cell of an Excel document:

MyXLSDocument[1,2]: Accesses the cell found in row 1 and column 2 of the Excel file.
MyXLSDocument[5, "A"]: Accesses the cell found in row 5 and column A of the Excel file.

Accessing a cell of a column in an Excel document

The following syntaxes can be used to access a cell of a column in an Excel document:

MyXLSDocument.Column[1].Cell: Returns the value of the cell found in column 1 for the current row.
MyXLSDocument.Column["A"].Cell: Returns the value of the cell found in column "A" for the current row.

Accessing a cell of a row in an Excel document

The following syntax can be used to access a cell of a row in an Excel document:

MyXLSDocument.Row[1].Cell[2]: Accesses the cell found in row 1 and column 2 of the Excel file.
MyXLSDocument.Row[5].Cell["A"]: Accesses the cell found in row 5 and column A of the Excel file.

Functions that use the xlsDocument variables


Versions 24 and later iPrintXLS New in version 24 iPrintXLS iPrintXLS	Prints the current worksheet of a document in "xlsx" or "xls" format.
Versions 24 and later iSequencingAddXLS New in version 24 iSequencingAddXLS iSequencingAddXLS	Adds a print of XLS orXLSX document into a sequence of report prints.
Versions 14 and later xlsAddWorksheet New in version 14 xlsAddWorksheet xlsAddWorksheet	Adds or inserts a new worksheet into an Excel document.
Versions 09 and later xlsClose New in version 09 xlsClose xlsClose	Closes an XLS file.
Versions 09 and later xlsColumnTitle New in version 09 xlsColumnTitle xlsColumnTitle	Retrieves the title of a column found in an XLS file.
Versions 09 and later xlsColumnType New in version 09 xlsColumnType xlsColumnType	Returns the type of data entered in a column of an XLS file.
Versions 11 and later xlsCurrentWorksheet New in version 11 xlsCurrentWorksheet xlsCurrentWorksheet	Used to find out and modify the current worksheet in an XLS file.
Versions 09 and later xlsData New in version 09 xlsData xlsData	Retrieves the content of a cell found in an XLS file.
Versions 14 and later xlsDeleteWorksheet New in version 14 xlsDeleteWorksheet xlsDeleteWorksheet	Deletes a worksheet from the Excel document.
Versions 09 and later xlsMsgError New in version 09 xlsMsgError xlsMsgError	Returns the caption of the last error caused by an XLS function.
Versions 09 and later xlsNbColumn New in version 09 xlsNbColumn xlsNbColumn	Returns the number of columns found in a worksheet of an XLS file.
Versions 09 and later xlsNbRow New in version 09 xlsNbRow xlsNbRow	Returns the number of rows found in an XLS file.
Versions 11 and later xlsNbWorksheet New in version 11 xlsNbWorksheet xlsNbWorksheet	Returns the number of worksheets found in an XLS file.
Versions 09 and later xlsOpen New in version 09 xlsOpen xlsOpen	Opens an Excel file (xls or xlsx files).
Versions 14 and later xlsSave New in version 14 xlsSave xlsSave	Saves an XLS document.
Versions 09 and later xlsVersion New in version 09 xlsVersion xlsVersion	Returns the Excel version that was used to save the file.

Related Examples:

Unit examples (WINDEV): XLS Type

[ + ] Handling the xlsDocument, xlsColumn, xlsRow and xlsCell variables.
The purpose of this example is to explain how these types of variables can be easily handled.