|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creates an Excel file with data from a Pivot Table control. |
|
|
|
|
|
|
|
| Creates an Excel file with data from a Pivot Table control. |
|
|
|
|
|
|
|
| Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory). |
|
|
|
|
|
|
|
| Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory). |
|
|
|
|
|
|
|
| Usage example of the GetActiveObject function |
|
|
|
|
|
|
|
| Creates an Excel file with the data from a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Creates an Excel file with the data from a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Usage example of the xlsVersion function |
|
|
|
|
|
|
|
| Usage example of the xlsOpen function |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose two methods for handling Excel files... |
|
|
|
|
|
|
|
| Recalculates all formulas in an Excel (XLSX) document. |
|
|
|
|
|
|
|
| Returns the Excel version that was used to save the file. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Recalculates all formulas in an Excel (XLSX) document. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Deletes a worksheet from the Excel document. |
|
|
|
|
|
|
|
| Deletes a worksheet from the Excel document. |
|
|
|
|
|
|
|
| The xlsColumn type is used to describe and modify a column in an Excel document... |
|
|
|
|
|
|
|
| The xlsRow variable type defines and changes the characteristics of a row in an Excel document... |
|
|
|
|
|
|
|
| You want to perform simulations with Excel, Word, OpenOffice... |
|
|
|
|
|
|
|
| WDMAP allows you to export records to ... |
|
|
|
|
|
|
|
| Usage example of the xlsDocument type |
|
|
|
|
|
|
|
| The ActiveX control is used to easily manage the ActiveX technology... |
|
|
|
|
|
|
|
| The OLE control is used to handle an OLE object... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose two methods for handling Excel files... |
|
|
|
|
|
|
|
| Opens an Excel file (xls or xlsx files). |
|
|
|
|
|
|
|
| Returns the caption of the last error caused by an XLS function. |
|
|
|
|
|
|
|
| Spreadsheets are one of the most used office tools... |
|
|
|
|
|
|
|
| An xlsCell variable is used to describe and modify a cell in an Excel document... |
|
|
|
|
|
|
|
| Each Table control found in a window proposes a menu to the user... |
|
|
|
|
|
|
|
| Adds or inserts a new worksheet into an Excel document. |
|
|
|
|
|
|
|
| Loads a file in XLSX format in a Spreadsheet control found in a window. |
|
|
|
|
|
|
|
| Returns the number of worksheets found in an XLS file. |
|
|
|
|
|
|
|
| Adds or inserts a new worksheet into an Excel document. |
|
|
|
|
|
|
|
| An xlsDocument variable is used to describe and modify an Excel document... |
|
|
|
|
|
|
|
| Returns the MIME type of the request received when calling a REST web service. |
|
|
|
|
|
|
|
| Loads a file in XLSX format in a Spreadsheet control found in a window. |
|
|
|
|
|
|
|
| Converts an 8-byte real to a date and time. |
|
|
|
|
|
|
|
| The CtOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| The rssEnclosure type is used to define and handle an attachment to a RSS feed entry... |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| List of Google Documents functions |
|
|
|
|
|
|
|
| Saves the content of a Spreadsheet control in a file in XLSX format. |
|
|
|
|
|
|
|
| Saves the content of a Spreadsheet control in a file in XLSX format. |
|
|
|
|
|
|
|
| Retrieves the content of a cell found in an XLS file. |
|
|
|
|
|
|
|
| List of Google Documents functions |
|
|
|
|
|
|
|
| Converts a date and time to an 8-byte real. |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. |
|
|
|
|
|
|
|
| Converts a date and time to an 8-byte real. |
|
|
|
|
|
|
|
| Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. |
|
|
|
|
|
|
|
| Used to find out and modify the current worksheet in an XLS file. |
|
|
|
|
|
|
|
| Sends a command that will be run on the server. |
|
|
|
|
|
|
|
| Reduces the time needed to load the content of HFSQL items of type "Memo" on the user's computer. |
|
|
|
|
|
|
|
| Returns the number of rows found in an XLS file. |
|
|
|
|
|
|
|
| Starts downloading a file in the browser. |
|
|
|
|
|
|
|
| Displays the contents of a file from a "Memo" item in a web browser. |
|
|
|
|
|
|
|
| Retrieves the title of a column found in an XLS file. |
|
|
|
|
|
|
|
| Opens a file in the browser. |
|
|
|
|
|
|
|
| Writes text or image information into the system clipboard. |
|
|
|
|
|
|
|
| Returns the number of columns found in a worksheet of an XLS file. |
|
|
|
|
|
|
|
| Retrieves the text or image found in the system clipboard. |
|
|
|
|
|
|
|
| Copies the content of a Table or TreeView Table control to the clipboard. |
|
|
|
|
|
|
|
| Allows to use an Automation object already started on the current computer. |
|
|
|
|
|
|
|
| Allows you to specify the behavior of some Automatic Application Features (AAF). You can for example configure the option for exporting to Excel used by the automatic menu of tables. |
|
|
|
|
|
|
|
| WDStatistics can be used once the log files have been imported... |
|
|
|
|
|
|
|
| Returns the type of data entered in a column of an XLS file. |
|
|
|
|
|
|
|
| The result of a select query can be... |
|
|
|
|
|
|
|
| The Automatic Application Features (AAF) allow you to add features to your application without having to write a single line of code... |
|
|
|
|
|
|
|
| Used to specify the behavior of some Automatic Application Features (AAF). |
|
|
|
|
|
|
|
| Creates a character string from the data found in a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| The TreeView control is a tree structure used to simplify the display of information that can be represented hierarchically... |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| The "Export" pane in the report viewer allows you to perform the following operations... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Indicates the MIME type of the response returned by the web service (case of a call to a REST web service). |
|
|
|
|
|
|
|
| List of constants used by the functions for managing the Drag and Drop. |
|
|
|
|
|
|
|
| Associates an OLE control with an OLE object by invoking a specific OLE server. |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
|
|
|
|
|
|
|
| The nfcData type is used to describe and handle the data of a variable of type nfcTag. |
|
|
|
|
|
|
|
| Each TreeView control found in a window proposes a popup menu to the user... |
|
|
|
|
|
|
|
| The ribbon of the Spreadsheet control proposes several features and it allows you to define several settings... |
|
|
|
|
|
|
|
| Associates an OLE control with an OLE object while specifying a base file. |
|
|
|
|
|
|
|
| Creates a Word file (.RTF) from the data found in a Table or TreeView Table control. |
|
|
|
|
|
|
|
| WINDEV allows you to easily insert automatic calculations into the columns found in the Table and TreeView Table controls. It is also possible to perform custom calculations in the columns of Table and Hierarchical Table fields. These calculations are performed programmatically. |
|
|
|
|
|
|
|
| WINDEV, WINDEV Mobile and WEBDEV propose several functions allowing you to manage the external files from your WINDEV/WINDEV Mobile applications or from your WEBDEV websites... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
The VisibleInExportAndPrint property is used to: - Find out whether a column of a Table or TreeView Table control is visible for export and printing.
- Modify the visibility of a column in a Table or TreeView Table control for export and printing.
|
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Adds an XLS or XLSX document into a sequence of report print jobs. |
|
|
|
|
|
|
|
| WINDEV applications automatically include a context menu for Table controls, TreeView Table controls and their columns... |
|
|
|
|
|
|
|
| Merges the specified cells in an Excel document. |
|
|
|
|
|
|
|
| Merges the specified cells in an Excel document. |
|
|
|
|
|
|
|
| The following functions are used to manage AAFs (Automatic Application Features): |
|
|
|
|
|
|
|
| Writes a line to a text file (ANSI or Unicode). |
|
|
|
|
|
|
|
| List of constants used by the border functions. |
|
|
|
|
|
|
|
| The Border type is used to handle a border programmatically... |
|
|
|
|
|
|
|
| Table controls allow you to display and/or enter data... |
|
|
|
|
|
|
|
Returns the list of files:- current analysis.
- analyses in progress (projects with multiple analyses).
- a specific analysis recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| Indicates the type of data and the data to copy/move during Drag/Drop. |
|
|
|
|
|
|
|
| Retrieves a specific type of data during Drag/Drop. |
|
|
|
|
|
|
|
| Checks whether a specific type of data is available during Drag/Drop. |
|
|
|
|
|
|
|
| Pivot Table control functions |
|
|
|
|
|
|
|
| List of constants used by the functions for managing XLS files. |
|
|
|
|
|
|
|
| Runs an Automatic Application Feature (AAF) on a control or window. |
|
|
|
|
|
|
|
| Pivot Table control functions (prefix syntax) |
|
|
|
|
|
|
|
| The report viewer allows you to see the report layout without printing it... |
|
|
|
|
|
|
|
| Usage example of the zipFindFile 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. |
|
|
|
|
|
|
|
Configures the print preview:- display a message regarding the resources of current computer.
- display or hide the ribbon tabs and buttons.
- the export options available in the mini preview window.
|
|
|
|
|
|
|
|
| WDStatistics is a tool used to perform statistical calculations regarding the traffic of your dynamic WEBDEV websites... |
|
|
|
|
|
|
|
| The spreadsheet is one of the most often used business tools. The Spreadsheet control is used to include a spreadsheet in your WINDEV windows. |
|
|
|
|
|
|
|
| The MaskWD property of the xlsCell type defines the WINDEV or WEBDEV display mask to be used in a cell in Microsoft Excel cell (e.g., "MM/DDYYYY")... |
|
|
|
|
|
|
|
| Deletes a connection between the current program and a recipient. |
|
|
|
|
|
|
|
| At runtime, in the Spreadsheet control, the end user directly enters the calculation formulas... |
|
|
|
|
|
|
|
| Disables an Automatic Application Feature (AAF) on a control, window or on the current application. |
|
|
|
|
|
|
|
| A dynamic automation object is an automation object allocated upon request, during the program execution... |
|
|
|
|
|
|
|
| Disables an Automatic Application Feature (AAF) on a control, window or on the current application. |
|
|
|
|
|
|
|
| List of functions for handling external files |
|
|
|
|
|
|
|
| You can display a print preview in the report viewer... |
|
|
|
|
|
|
|
| The Pivot Table control offers several Automatic Application Features (AAF) allowing the user to take advantage of all its capabilities... |
|
|
|
|
|
|
|
| Prints a document (text or PDF file, images, Word or Excel document, ...) by using the Cloud Print service of Google. |
|
|
|
|
|
|
|
| The Automation keyword is used to declare an automation object... |
|
|
|
|
|
|
|
| Opens a connection to a specific Client/Server database to manage User Groupware files in Client/Server mode. |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| List of Looper control functions (prefix syntax) |
|
|
|
|
|
|
|
| Displays a file in the user's browser. |
|
|
|
|
|
|
|
| List of constants used by the functions for managing Table, TreeView Table, Looper and List Box controls. |
|
|
|
|
|
|
|
| Opens the AAF (Automatic Application Features) help website. |
|
|
|
|
|
|
|
| List of functions specific to Table controls |
|
|
|
|
|
|
|
| List of functions for managing Looper controls |
|
|
|
|
|
|
|
| Configures the report viewer.
|
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| List of constants used by the Automatic Application Features (AAF) functions. |
|
|
|
|
|
|
|
| List of functions for managing TreeView Table controls |
|
|
|
|
|
|
|
| Secures the export of confidential data in the AAFs (Automatic Application Features) that are used to export, print or save data. |
|
|
|
|
|
|
|
| GDPR: General Data Protection Regulation |
|
|
|
|
|
|
|
| WINDEV allows you to develop 64-bit applications... |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| A cell found in a Table control can contain a set of controls... |
|
|
|
|
|
|
|
| A cell found in a Table control can contain a set of controls... |
|
|
|
|
|
|
|
| WEBDEV 2026 new features in the 2026 New Features brochure. |
|
|
|
|
|
|
|
| The custom-notes allow you to write down any ideas you want to remember, notes you must not forget, ... |
|
|
|
|
|
|
|
| Pastes the content of Windows clipboard into an OLE control. |
|
|
|
|
|
|
|
| The examples provided with WINDEV are intended to help you learn the features of WINDEV.
|
|
|
|
|
|
|
|
| Returns the runtime status report of a DDE function. |
|
|
|
|
|
|
|
| Re-enables an Automatic Application Feature (AAF) previously disabled by AAFDisable. |
|
|
|
|
|
|
|
| WDConver is a tool used to convert data to an HFSQL Classic data file from a file ... |
|
|
|
|
|
|
|
| Initializes an OLE control with an OLE object. |
|
|
|
|
|
|
|
| Customizes the text of a menu option for context menus corresponding to an AAF (Automatic Application Feature). |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| Spreadsheet controls can be manipulated programmatically... |
|
|
|
|
|
|
|
| Spreadsheet controls can be manipulated programmatically... |
|
|
|
|
|
|
|
| The advanced types of WLanguage are as follows |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a data file while developing an application... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| To view the characteristics of the control, select "Description" in the context menu. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| WINDEV includes several Automatic Application Features (AAFs)... |
|
|
|
|
|
|
|
| Callback de la fonction PartageProximitéAttendConnexion1.Cb pour le paramètre CallbackResultat |
|
|
|
|
|
|
|
| Starting with Android 10, Google no longer allows an application running in the background to open a window |
|
|
|
|
|
|
|
| WINDEV Tutorial: Managing data in a WINDEV application
Lesson 3 - Multi-criteria search - 40 min |
|
|
|
|
|
|
|
| List of functions for managing Table controls (prefix syntax) |
|
|
|
|
|
|
|
| In a report based on a text file, the information to print is read from a text file or is directly assigned in the report controls... |
|
|
|
|
|
|
|
| New features in WINDEV 27 presented in the New Features brochure. |
|
|
|
|
|
|
|
| WINDEV Tutorial: Managing data in a WINDEV application
Lesson 1 - Creating windows to add and edit data - 50 min |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| What's new in WINDEV 2025 in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure. |
|
|
|
|
|
|
|
| WINDEV 2024 new features in the 2024 New Features brochure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|