ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
HExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
<Looper>.ToExcel (Function)
Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory).
Handling XLS files (prefix syntax)
WINDEV and WEBDEV propose two methods for handling Excel files...
<xlsDocument variable>.RecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
<Table>.ToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
ExecuteAAF (Function)
Runs an Automatic Application Feature (AAF) on a control or window.
XLS file functions (prefix syntax)
XLS file functions
<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.
DisableAAF (Function)
Disables an Automatic Application Feature (AAF) on a control, window or on the current application.
TableToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
xlsRecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
<Source>.ExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
AAFDisable (Function)
Disables an Automatic Application Feature (AAF) on a control, window or on the current application.
LooperToExcel (Function)
Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory).
Handling XLS files
WINDEV and WEBDEV propose two methods for handling Excel files...
XLS file functions
XLS file functions
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...
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.
AAFExecute (Function)
Runs an Automatic Application Feature (AAF) on a control or window. This function can be used to start the spelling checker on an edit control for example.
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...
xlsRow (Type of variable)
The xlsRow type is used to describe and modify a row in an Excel document...
1
2
>