|
|
|
|
|
|
|
|
|
|
- Spreadsheet control overview
Spreadsheet control overview Spreadsheets are one of the most used office tools. The "Spreadsheet control" field is a native field: it requires no spreadsheet installed on the workstation (and therefore no license to manage). With this control, no more navigation between applications, no external software to control! Advantages of this control: - The content of the Spreadsheet control can be directly saved (or loaded) as an XLSX file.
- The Spreadsheet control is compatible with Excel, OpenOfficeCalc, FreeOffice, etc.
- The Spreadsheet control supports Excel worksheets (XLSX).
- The Spreadsheet control supports XLTX and XLTM files (Excel templates). If a template file is opened in the Spreadsheet control, a new workbook is automatically created with that template.
 New in version 2025The Spreadsheet control lets you read and save files in CSV format.
This compatibility allows you to reuse existing spreadsheets or calculations performed in the Spreadsheet control. The Spreadsheet control also supports protected worksheets and locked cells. The worksheet password is requested when making changes. The Spreadsheet control can be used:
Related Examples:
|
Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control. This example explains how to: - load an xlsx file in a spreadsheet control, - save the spreadsheet in a file, - fill the control with data coming from the database, - insert rows, columns, - access the cells and handle them (modify their value, their style, ...), - enter formulas, - ...
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|