|
|
|
|
|
|
Category: XLS file functions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Adds or inserts a new worksheet into an Excel document.
|
|
|
|
|
|
|
Deletes a worksheet from the Excel document.
|
|
|
|
|
|
|
Determines if a cell is merged with other cells and gets the merged cell range.
|
|
|
|
|
|
|
Merges the specified cells in an Excel document.
|
|
|
|
|
|
|
Recalculates all formulas in an Excel (XLSX) document.
|
|
|
|
|
|
|
List of constants used by the functions for managing XLS files.
|
|
|
|
|
|
|
List of functions for managing XLS files
|
|
|
|
|
|
|
WINDEV and WEBDEV propose two methods for handling the Excel files...
|
|
|
|
|
|
|
WINDEV and WEBDEV propose two methods for handling the Excel files...
|
|
|
|
|
|
|
List of functions for managing XLS files
|
|
|
|
|
|
|
Adds or inserts a new worksheet into an Excel document.
|
|
|
|
|
|
|
The MaskWD property of the xlsDocument type is used to define the display mask in WINDEV or WEBDEV format that will be used in the Excel cell ("DD/MM/YYYY" for example)...
|
|
|
|
|
|
|
An xlsCell variable is used to describe and modify a cell in an Excel document...
|
|
|
|
|
|
|
Usage example of the xlsClose function
|
|
|
|
|
|
|
The xlsColumn type is used to describe and modify a column in an Excel document...
|
|
|
|
|
|
|
Usage example of the xlsColumnTitle function
|
|
|
|
|
|
|
Retrieves the title of a column found in an XLS file.
|
|
|
|
|
|
|
Usage example of the xlsColumnType function
|
|
|
|
|
|
|
Returns the type of data entered in a column of an XLS file.
|
|
|
|
|
|
|
Retrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates.
|
|
|
|
|
|
|
Used to find out and modify the current worksheet in an XLS file.
|
|
|
|
|
|
|
Usage example of the xlsData function
|
|
|
|
|
|
|
Retrieves the content of a cell found in an XLS file.
|
|
|
|
|
|
|
Deletes a worksheet from the Excel document.
|
|
|
|
|
|
|
Usage example of the xlsDocument type
|
|
|
|
|
|
|
An xlsDocument variable is used to describe and modify an Excel document...
|
|
|
|
|
|
|
Determines if a cell is merged with other cells and gets the merged cell range.
|
|
|
|
|
|
|
The xlsLayout type is used to define all the layout characteristics of a sheet of an XLSX document in a Spreadsheet control.
|
|
|
|
|
|
|
Merges the specified cells in an Excel document.
|
|
|
|
|
|
|
Usage example of the xlsMsgError function
|
|
|
|
|
|
|
Returns the caption of the last error caused by an XLS function.
|
|
|
|
|
|
|
Returns the coordinates of a cell, XLS file or spreadsheet control according to its name.
|
|
|
|
|
|
|
Usage example of the xlsNbColumn function
|
|
|
|
|
|
|
Returns the number of columns found in a worksheet of an XLS file.
|
|
|
|
|
|
|
xlsNbColumns is kept for backward compatibility only.
|
|
|
|
|
|
|
Usage example of the xlsNbRow function
|
|
|
|
|
|
|
Returns the number of rows found in an XLS file.
|
|
|
|
|
|
|
xlsNbRows is kept for backward compatibility only.
|
|
|
|
|
|
|
Returns the number of worksheets found in an XLS file.
|
|
|
|
|
|
|
Usage example of the xlsOpen function
|
|
|
|
|
|
|
Opens an Excel file (xls or xlsx files).
|
|
|
|
|
|
|
Recalculates all formulas in an Excel (XLSX) document.
|
|
|
|
|
|
|
The xlsRow type is used to describe and modify a row in an Excel document...
|
|
|
|
|
|
|
Unmerges a range of cells.
|
|
|
|
|
|
|
Usage example of the xlsVersion function
|
|
|
|
|
|
|
Returns the Excel version that was used to save the file.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|