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.

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.
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.
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:


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

Prefix syntax:


<xlsDocument variable>.AddWorksheet	Adds or inserts a new worksheet into an Excel document.
<xlsDocument variable>.Close	Closes an XLS file.
<xlsDocument variable>.Save	Saves an XLS document.
<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.