ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

xlsRecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
Functions for managing XLS files (prefix syntax)
List of functions for managing XLS files
Handling XLS files (prefix syntax)
WINDEV and WEBDEV propose two methods for handling Excel files...
<Pivot Table>.ToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
XLS file functions
List of functions for managing XLS files
Handling XLS files
WINDEV and WEBDEV propose two methods for handling Excel files...
<xlsDocument variable>.RecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
Export your data to Excel
<xlsDocument variable>.DeleteWorksheet (Function)
Deletes a worksheet from the Excel document.
xlsDeleteWorksheet (Function)
Deletes a worksheet from the Excel document.
<xlsDocument variable>.MergeCell (Function)
Merges the specified cells in an Excel document.
xlsMergeCell (Function)
Merges the specified cells in an Excel document.
<xlsDocument variable>.AddWorksheet (Function)
Adds or inserts a new worksheet into an Excel document.
xlsAddWorksheet (Function)
Adds or inserts a new worksheet into an Excel document.
xlsOpen (Function)
Opens an Excel file (xls or xlsx files).
xlsVersion (Function)
Returns the Excel version that was used to save the file.
PVTToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
xlsDocument (Type of variable)
An xlsDocument variable is used to describe and modify an Excel document...
xlsColumn (Type of variable)
The xlsColumn type is used to describe and modify a column in an Excel document...
xlsCell (Type of variable)
An xlsCell variable is used to describe and modify a cell in an Excel document...
TableToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
xlsRow (Type of variable)
The xlsRow type is used to describe and modify a row in an Excel document...
<Table>.ToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
<Source>.ExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
LooperToExcel (Function)
Creates an Excel file from the data found in a Looper control (browsing Looper control or memory...
<Looper>.ToExcel (Function)
Creates an Excel file from the data found in a Looper control (browsing Looper control or memory...
The Spreadsheet control
Spreadsheets are one of the most used office tools......
GglPrintDocument (Function)
Prints a document (text or PDF file, images, Word or Excel document, ...) by using the Cloud Print...
1
2
>