ONLINE HELP
 WINDEVWEBDEV 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...
<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...
HExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
XLS file functions
XLS file functions
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.
SpreadsheetSave (Function)
Saves the content of a Spreadsheet control in a file in XLSX format.
Border management constants
List of constants used by the border management functions....
xlsMsgError (Function)
Returns the caption of the last error caused by an XLS function.
The OLE control
The OLE control is used to handle an OLE object......
DateTimeToReal (Function)
Converts a date and time to an 8-byte real.
RealToDateTime (Function)
Converts an 8-byte real to a date and time.
xlsVersion (Example)
Usage example of the xlsVersion function
ConfigureAAF (Function)
Used to specify the behavior of some Automatic Application Features (AAF).
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a Webservice...
xlsNbWorksheet (Function)
Returns the number of worksheets found in an XLS file.
iSequencingAddXLS (Function)
Adds an XLS or XLSX document into a sequence of report print jobs.
SQLConnect (Function)
Connects the current application to a database that must be interrogated via SQL.
rssEnclosure (Variable type)
The rssEnclosure type is used to define and handle an attachment to a RSS feed entry...
xlsData (Function)
Retrieves the content of a cell found in an XLS file.
1
2
3
4
5
6
8
>