ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2025
Result of a query in test mode
After its execution in test mode (see Running the query test), the result of the query can be...
DisableAAF (Function)
Disables an Automatic Application Feature (AAF) on a control, window or on the current application.
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.
WEBDEV - Server codeLinux Note: This feature is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 4.
XLS file functions
List of functions for managing XLS files
PVTToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
WEBDEV - Server codeLinux Note: This feature is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 4.
<xlsDocument variable>.RecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
Handling XLS files
WINDEV and WEBDEV propose two methods for handling Excel files...
ExecuteAAF (Function)
Runs an Automatic Application Feature (AAF) on a control or window.
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.
xlsAddWorksheet (Function)
Adds or inserts a new worksheet into an Excel document.
<xlsDocument variable>.AddWorksheet (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.
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.
<Table>.ToExcel (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...
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
<Source>.ExportXLS (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
>