ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2025
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
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.
XLS file functions
List of functions for managing XLS files
DisableAAF (Function)
Disables an Automatic Application Feature (AAF) on a control, window or on the current application.
AAFDisable (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.
PVTToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
WEBDEV - Server codeLinux Note: This feature is only available from WINDEV Suite SaaS 2025 - Update 4.
For more details, see Using new features exclusive to WINDEV Suite SaaS 2025.
<Looper>.ToExcel (Function)
Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory).
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).
XLS file functions (prefix syntax)
XLS file functions
<Table>.ToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
LooperToExcel (Function)
Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory).
<Pivot Table>.ToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
WEBDEV - Server codeLinux Note: This feature is only available from WINDEV Suite SaaS 2025 - Update 4.
For more details, see Using new features exclusive to WINDEV Suite SaaS 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...
Export your data to Excel
xlsDeleteWorksheet (Function)
Deletes a worksheet from the Excel document.
<xlsDocument variable>.DeleteWorksheet (Function)
Deletes a worksheet from the Excel document.
xlsMergeCell (Function)
Merges the specified cells in an Excel document.
<xlsDocument variable>.MergeCell (Function)
Merges the specified cells in an Excel document.
xlsRecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) document.
<xlsDocument variable>.RecalculateAll (Function)
Recalculates all formulas in an Excel (XLSX) 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).
xlsAddWorksheet (Function)
Adds or inserts a new worksheet into an Excel document.
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
>