ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

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