Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Spreadsheet control
  • Overview of Spreadsheet control
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Overview of Spreadsheet control
Spreadsheets are one of the most used office tools.
The "Spreadsheet" control is a native control: it doesn't require a spreadsheet software to be installed on the computer (and therefore no license to manage).
With this control, no more navigation between applications, no external software to control!
Some benefits of this control:
  • The content of Spreadsheet control can be saved (or loaded) in Excel format directly (XLSX format).
  • The Spreadsheet control is compatible with Excel, OpenOfficeCalc, FreeOffice, ...
  • 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.
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:
The Spreadsheet control 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,
- ...
WD Reports Training (WINDEV): WD Reports
[ + ] This example presents the different methods for creating a report:

- prints based on different data sources (queries, variables, ...)
- prints based on controls (Table, Spreadsheet, PVT, ...)
- printing composite reports
- specific prints (portrait/landscape, report with watermark, report with bar code, ...)
Minimum version required
  • Version 20
This page is also available for…
video excel
22 Jul. 2018

Last update: 06/22/2023

Send a report | Local help