PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview of Spreadsheet control
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview of Spreadsheet control
The spreadsheet is one of the most often used business 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 reads the worksheets coming from Excel (XLSX).
This compatibility allows you to re-use existing spreadsheets or to re-use calculations performed in the Spreadsheet control.
Caution: The protected worksheets and the locked cells are not supported by the Spreadsheet control.
The Spreadsheet control can be used:
Versions 21 and later
WINDEVWEBDEV - Server code The Spreadsheets controls are now available in the reports.
New in version 21
WINDEVWEBDEV - Server code The Spreadsheets controls are now available in the reports.
WINDEVWEBDEV - Server code The Spreadsheets controls are now available in the reports.
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 required version
  • Version 20
This page is also available for…
Comments
video excel
https://youtu.be/TUY5H1L8ZsI
amarildo
Jul. 22 2018