ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2024

Category: XLS file functions
51 results
Adds or inserts a new worksheet into an Excel document.
Closes an XLS file.
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.
Saves an XLS document.
Unmerges a given cell.
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
Closes an XLS file.
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...
Saves an XLS document.
Unmerges a range of cells.
Usage example of the xlsVersion function
Returns the Excel version that was used to save the file.