xlsDocument (Type of variable)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

XLS file management functions

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

WLanguage functions that use xlsDocument variables

Related examples

See also

xlsDocument (Type of variable)

In french: xlsDocument

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

Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

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.
File	Character string	Name and full path of XLS file associated with the document. This property is available in read-only mode. It is assigned when using xlsOpen. Remark: when assigning an xlsDocument variable into another one, this property is not copied (except during the call to xlsOpen).
LeafName	Character string	Name of current worksheet. This property can correspond to a string containing between 1 and 31 characters. It is case insensitive.
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 mode.
NumberRow	Integer	Number of rows found in the document (identical to xlsNbRow). This property is available in read-only mode.
NumberWorksheet	Integer	Number of worksheets found in the document (identical to xlsNbWorksheet). This property is available in read-only mode.
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. Remark: Only the formulas initially found in the document can be recalculated.
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".
Row	Array of xlsRow	Row in the XLS document.
Version	Integer	XLS document version (same as xlsVersion). This property is available in read-only mode.
Worksheet	Integer	Number of the current worksheet (identical to xlsCurrentWorksheet).

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.

WLanguage functions that use xlsDocument variables

Standard syntax:


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 24 and later iPrintXLS New in version 24 iPrintXLS iPrintXLS	Prints the current worksheet of a document in "xlsx" or "xls" format.
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 xlsData New in version 09 xlsData xlsData	Retrieves the content of a cell found in an XLS file.
Versions 09 and later xlsClose New in version 09 xlsClose xlsClose	Closes 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 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 11 and later xlsNbWorksheet New in version 11 xlsNbWorksheet xlsNbWorksheet	Returns the number of worksheets found in 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 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 14 and later xlsDeleteWorksheet New in version 14 xlsDeleteWorksheet xlsDeleteWorksheet	Deletes a worksheet from the Excel document.
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 09 and later xlsVersion New in version 09 xlsVersion xlsVersion	Returns the Excel version that was used to save the file.

Prefix syntax:


Versions 24 and later <xlsDocument variable>.AddWorksheet New in version 24 <xlsDocument variable>.AddWorksheet <xlsDocument variable>.AddWorksheet	Adds or inserts a new worksheet into an Excel document.
Versions 24 and later <xlsDocument variable>.Close New in version 24 <xlsDocument variable>.Close <xlsDocument variable>.Close	Closes an XLS file.
Versions 24 and later <xlsDocument variable>.Save New in version 24 <xlsDocument variable>.Save <xlsDocument variable>.Save	Saves an XLS document.
Versions 24 and later <xlsDocument variable>.DeleteWorksheet New in version 24 <xlsDocument variable>.DeleteWorksheet <xlsDocument variable>.DeleteWorksheet	Deletes a worksheet from the Excel document.

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.