|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Usage example of the xlsClose function |
|
|
|
|
|
|
|
| Usage example of the xlsVersion function |
|
|
|
|
|
|
|
| Usage example of the xlsNbColumn function |
|
|
|
|
|
|
|
| Usage example of the xlsNbRow function |
|
|
|
|
|
|
|
| Usage example of the xlsData function |
|
|
|
|
|
|
|
| Usage example of the xlsColumnTitle function |
|
|
|
|
|
|
|
| Usage example of the xlsOpen function |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose two methods for handling Excel files... |
|
|
|
|
|
|
|
| xlsNbColumns is kept for backward compatibility only. |
|
|
|
|
|
|
|
| Prints the current worksheet of a document in "xlsx" or "xls" format. |
|
|
|
|
|
|
|
| Returns the caption of the last error caused by an XLS function. |
|
|
|
|
|
|
|
| Unmerges a range of cells. |
|
|
|
|
|
|
|
| Usage example of the xlsDocument type |
|
|
|
|
|
|
|
| xlsNbRows is kept for backward compatibility only. |
|
|
|
|
|
|
|
| Returns the number of columns found in a worksheet of an XLS file. |
|
|
|
|
|
|
|
| Returns the number of worksheets found in an XLS file. |
|
|
|
|
|
|
|
| Returns the Excel version that was used to save the file. |
|
|
|
|
|
|
|
| Determines if a cell is merged with other cells and gets the merged cell range. |
|
|
|
|
|
|
|
| Adds or inserts a new worksheet into an Excel document. |
|
|
|
|
|
|
|
| Adds an XLS or XLSX document into a sequence of report print jobs. |
|
|
|
|
|
|
|
| Determines if a cell is merged with other cells and gets the merged cell range. |
|
|
|
|
|
|
|
| Returns the number of rows found in an XLS file. |
|
|
|
|
|
|
|
| Usage example of the xlsMsgError function |
|
|
|
|
|
|
|
| Retrieves the title of a column found in an XLS file. |
|
|
|
|
|
|
|
| Adds or inserts a new worksheet into an Excel document. |
|
|
|
|
|
|
|
| List of constants used by the functions for managing XLS files. |
|
|
|
|
|
|
|
| Deletes a worksheet from the Excel document. |
|
|
|
|
|
|
|
| Deletes a worksheet from the Excel document. |
|
|
|
|
|
|
|
| Used to find out and modify the current worksheet in an XLS file. |
|
|
|
|
|
|
|
| Merges the specified cells in an Excel document. |
|
|
|
|
|
|
|
| Usage example of the xlsColumnType function |
|
|
|
|
|
|
|
| Merges the specified cells in an Excel document. |
|
|
|
|
|
|
|
| Retrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates. |
|
|
|
|
|
|
|
| Returns the type of data entered in a column of an XLS file. |
|
|
|
|
|
|
|
| Opens an Excel file (xls or xlsx files). |
|
|
|
|
|
|
|
| In some cases, you may want to print several reports one after another, and view them in the same print preview. |
|
|
|
|
|
|
|
| Recalculates all formulas in an Excel (XLSX) document. |
|
|
|
|
|
|
|
| Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory). |
|
|
|
|
|
|
|
| Retrieves the content of a cell found in an XLS file. |
|
|
|
|
|
|
|
| Recalculates all formulas in an Excel (XLSX) document. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose two methods for handling Excel files... |
|
|
|
|
|
|
|
| Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory). |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| The spreadsheet is one of the most often used business tools. You have the ability to create reports that print the data found in a spreadsheet. |
|
|
|
|
|
|
|
| Creates an Excel file with data from a Pivot Table control. |
|
|
|
|
|
|
|
| Creates an Excel file with data from a Pivot Table control. |
|
|
|
|
|
|
|
| The Project Management Hub allows you to import requirements... |
|
|
|
|
|
|
|
| An xlsDocument variable is used to describe and modify an Excel document... |
|
|
|
|
|
|
|
| Returns the coordinates of a cell, XLS file or spreadsheet control according to its name. |
|
|
|
|
|
|
|
| The report editor allows you to create "Spreadsheet" reports... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Indicates the MIME type of the response returned by the web service (case of a call to a REST web service). |
|
|
|
|
|
|
|
| WLanguage procedure ("callback") called by fCopyDir for each copied file. This procedure is used to handle the current file. |
|
|
|
|
|
|
|
| WLanguage procedure ("callback") called by fCopyFile for each copied file. |
|
|
|
|
|
|
|
| The Border type is used to handle a border programmatically... |
|
|
|
|
|
|
|
| The advanced types (XLS variables, ggl variables, ... |
|
|
|
|
|
|
|
| The method for developing a site for Linux is identical to the method for developing a site for Windows. |
|
|
|
|
|
|
|
| Defines the options for the XLS file generated during the print. |
|
|
|
|
|
|
|
| The following events are associated to reports (order of appearance in the code editor)... |
|
|
|
|
|
|
|
| The iOutputInfo type is used to get the details of a report print or export job, or the details of a print job performed programmatically from the report viewer. |
|
|
|
|
|
|
|
| The following functions are used to handle the Spreadsheet control: |
|
|
|
|
|
|
|
| Returns a specific string (or a buffer) to the client browser in response to a request. |
|
|
|
|
|
|
|
| WDMAP allows you to export records to ... |
|
|
|
|
|
|
|
| Opens a document in a new modeless window using the appropriate WINDEV editor.
The result can be retrieved via a WLanguage procedure ("callback") when the document editing window is closed. Starting with WINDEV Suite 2025 - Update 2 (subscription version), diagrams are opened using the diagram editor. |
|
|
|
|
|
|
|
| Associates an OLE control with an OLE object while specifying a base file. |
|
|
|
|
|
|
|
| The ImageFond property lets you view and modify the background image of an element: window, page, field or state. |
|
|
|
|
|
|
|
| The xlsComment type is used to defined all the advanced characteristics of a comment in a cell of an XLS file or Spreadsheet control. |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm... |
|
|
|
|
|
|
|
| Configures the print destination. |
|
|
|
|
|
|
|
Returns: - the full name of the last file generated during the print (PDF, RTF, text, ...).
- the list of created duplicate files.
|
|
|
|
|
|
|
|
| Reduces the time needed to load the content of HFSQL items of type "Memo" on the user's computer. |
|
|
|
|
|
|
|
| Starts downloading a file in the browser. |
|
|
|
|
|
|
|
| List of constants used by the Google functions. |
|
|
|
|
|
|
|
| Returns the type of file according to the MIME standard (Multipurpose Internet Mail Extensions). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Used to specify the behavior of some Automatic Application Features (AAF). |
|
|
|
|
|
|
|
| Opens a file in the browser. |
|
|
|
|
|
|
|
| Displays a file in the user's browser. |
|
|
|
|
|
|
|
| Displays the contents of a file from a "Memo" item in a web browser. |
|
|
|
|
|
|
|
| Returns the type of file according to the MIME standard (Multipurpose Internet Mail Extensions). |
|
|
|
|
|
|
|
| Opens a document in a new modeless window using the appropriate WINDEV editor. Starting with WINDEV Suite 2025 - Update 2 (subscription version), diagrams are opened using the diagram editor. |
|
|
|
|
|
|
|
| Configures the print destination. |
|
|
|
|
|
|
|
| An xlsCell variable is used to describe and modify a cell in an Excel document... |
|
|
|
|
|
|
|
| Adds an attachment in a PDF file generated by a PDF print export. |
|
|
|
|
|
|
|
| WINDEV Tutorial: Managing data in a WINDEV application
Lesson 5 - Creating a drop-down menu - 30 min |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
| The "Export" pane in the report viewer allows you to perform the following operations... |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
| List of constants used by the print functions. |
|
|
|
|
|
|
|
| The Pivot Table control offers several Automatic Application Features (AAF) allowing the user to take advantage of all its capabilities... |
|
|
|
|
|
|
|
| The HeaderVisible property allows you to get and set the visibility status of the row and column headers in the layout of an XLS document. |
|
|
|
|
|
|
|
| The emailAttach type is used to handle an attachment.
|
|
|
|
|
|
|
|
| WINDEV applications automatically include a context menu for Table controls, TreeView Table controls and their columns... |
|
|
|
|
|
|
|
| Configures the report viewer.
|
|
|
|
|
|
|
|
| List of constants used by the functions for managing Table, TreeView Table, Looper and List Box controls. |
|
|
|
|
|
|
|
| The DefaultCell property sets the style of cells in XLS documents. |
|
|
|
|
|
|
|
| The WorksheetName property gets and sets the name of a worksheet in an XLS document. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to create reports with the report editor... |
|
|
|
|
|
|
|
| The following steps must be performed to implement the requirements... |
|
|
|
|
|
|
|
| Callback de la fonction PartageProximitéAttendConnexion1.Cb pour le paramètre CallbackResultat |
|
|
|
|
|
|
|
| WEBDEV Tutorial - WLanguage basics
Lesson 2 - Variables - 20 min |
|
|
|
|
|
|
|
| Sharing a project in practice |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| WINDEV Tutorial: WLanguage basics
Lesson 2 - Variables - 20 min |
|
|
|
|
|
|
|
| WINDEV Mobile Tutorial - WLanguage basics
Lesson 2 - Variables - 20 min |
|
|
|
|
|
|
|
| What's new in WINDEV Mobile 2025 is presented in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| What's new in WINDEV 2025 in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| The advanced types of WLanguage are as follows |
|
|
|
|
|
|
|
| The examples provided with WINDEV are intended to help you learn the features of WINDEV.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|