ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Spreadsheet control
  • Creating a Spreadsheet control in a report
  • Creating the control
  • Characteristics of Spreadsheet control in a report
  • Handling a Spreadsheet control in a report through programming
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Creating a Spreadsheet control in a report

Creating the control

To create a Spreadsheet control:
  1. On the "Creation" tab, in the "Data" group, click "Spreadsheet".
  2. Click at the desired location to create the control in the report.
To view the characteristics of the control, select "Description" in the context menu.
Remark: The data displayed by a Spreadsheet control in a report can:
  • be determined through programming (for example, direct display of an xls or xlsx file).
  • correspond to a memo item of a data file or query, ...
    • WINDEV correspond to a Spreadsheet control in a window.
    • correspond to an xlsDocument variable.
Characteristics of Spreadsheet control in a report
The main characteristics of a Spreadsheet control in a report are defined in the different tabs of the description window of the control:
  • "General" tab: The option Scaling corresponds to the property AdjustmentMode. The available options are:
    • No scaling: The worksheet is printed with its dimensions. The print can be performed on several pages in width and in height if necessary.
    • Adjust the calculation sheet to the control dimensions: The worksheet will be reduced in order to be entirely displayed in the Spreadsheet control.
    • Adjust all the columns to the control width: The columns found in the worksheet will be reduced or enlarged in order for all the columns to be displayed in the control width.
    • Adjust all the rows to the control height: The rows found in the worksheet will be reduced or enlarged in order for all the rows to be displayed in the control height.
  • "Binding" tab: Allows you to define the binding of the Spreadsheet control. The control can be:

Handling a Spreadsheet control in a report through programming

You can associate the Spreadsheet of a report with:
  • a variable of type xlsDocument. Simply use the code:
    <Spreadsheet control> = <xlsDocument variable>
  • an xls/xlsx file. Simply use the code:
    <Spreadsheet control> = <Path of xls/xlsx file>
Caution: Spreadsheet control management functions cannot be used on the Spreadsheet control of a report.
Related Examples:
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 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help