|
|
|
|
|
- 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
Spreadsheet control in a report
Creating a Spreadsheet control in a report Creating the control To create a Spreadsheet control: - On the "Creation" tab, in the "Data" group, click "Spreadsheet".
- 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, ...
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>
Warning: Spreadsheet control functions cannot be used on the Spreadsheet control of a report..
Related Examples:
|
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, ...)
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|