AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / Editores / Editor de reportes / Tipos de reportes
  • Overview
  • Creating a Spreadsheet report
  • Creating the report
  • Characteristics of a Spreadsheet report and a Spreadsheet control
  • Handling a Spreadsheet control in a report programmatically
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Overview
The report editor allows you to create "Spreadsheet" reports.
In this case, the report contains a Spreadsheet control only.
Note: This type of control is created when a Spreadsheet report is created, and can also be created independently of this report..
Example:
Creating a Spreadsheet report

Creating the report

To create a "Spreadsheet" report:
  1. Click in the quick access buttons.
    • The window for creating a new element is displayed: click "Report" then "Report".
    • The report creation wizard starts.
  2. Select a "Spreadsheet" report.
  3. In the rest of the wizard, specify:
    • the data source of the Spreadsheet control created in the report. This source can be:
      • a data file item,
      • a Spreadsheet control in a window.
      • none, if Spreadsheet control is assigned programmatically.
    • scaling options for the Spreadsheet control in the report:
      • No scaling: The spreadsheet sheet is printed at its own size.. The print can be performed on several pages in width and in height if necessary.
      • Fit the spreadsheet to the field dimensions: The spreadsheet will be reduced to fit entirely within the Spreadsheet control area..
      • Fit all columns to field width: Columns in the spreadsheet will be reduced or enlarged so that all columns in the spreadsheet are displayed within the width of the field..
      • Adjust all rows to field height: Rows in the spreadsheet will be reduced or enlarged so that all rows in the spreadsheet are displayed at the height of the field..
    • the template used if necessary.
Characteristics of a Spreadsheet report and a Spreadsheet control
You can modify the following characteristics of a Spreadsheet report:
  • By default, the Spreadsheet report is not linked to a data source. The Spreadsheet report data source can be modified in the "Data" tab of the report description window ("Report description" in the report context menu).
  • The "General" tab of the Spreadsheet control description window allows you to specify the scaling characteristics of the Spreadsheet control.
  • The "Content" tab of the Spreadsheet control description window allows you to link the Spreadsheet control to a data source:
    • Memo item of a data file or query, etc.
    • WINDEV Spreadsheet control in a window.
    • xlsDocument variable.
  • The "Style" tab of the Spreadsheet control description window allows you to specify the style of the grid and header text displayed in the Spreadsheet control.
For more details, see Spreadsheet control in a report.
Handling a Spreadsheet control in a report programmatically
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..
Versión mínima requerida
  • Versión 24
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 30/09/2024

Señalar un error o enviar una sugerencia | Ayuda local