GVExcelWorkbookConfiguration

From GreenVulcano Wiki
Revision as of 14:53, 14 February 2012 by Anonymous (talk) (Created page with "==Description== It is on this {{GVESB}} element where Report Excel formats will be configured. =={{VULCON}} / {{GVCONSOLE}} Configuration== The GVExcelWorkbookConfiguration El...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

It is on this GreenVulcano® ESB element where Report Excel formats will be configured.

VulCon / GV Console Configuration

The GVExcelWorkbookConfiguration Element is used by: GVAdapters and visible from the Adapter view of VulCon®.

The following table shows the GVExcelWorkbookConfiguration element's attributes:

Attribute Type Description
version fixed This attribute must assume the value 1.0.
type fixed This attribute must assume the value module.
name fixed This attribute must assume the value EXCEL_WORK.

Its subelements are:

GVExcelWorkbook

Defines the configuration elements of a Report.

The following table shows the GVExcelWorkbook element's attributes:

Attribute Type Description
configName required Format name.

There must be one with the value 'default'.

maxNumberOfSheets optional Max number of sheets in the report. Default 30.
sheetDefaultName optional Default name for sheets. Default Sheet.

Its subelements are:

SheetConfig

Defines the configuration of a sheet in a report.

The following table shows the SheetConfig element's attributes:

Attribute Type Description
offset optional Offset in rows to data start. Default 0.

The following table shows its subelements and their utilities:

Subelement Utility
Description
Title Defines the configuration of the title of a sheet. Has the attributes:
  • rowsFromTop: optional. Offset in rows. Default 0.
  • columnsFromLeft: optional. Offset in columns. Default 0.

Contains the element Format

TableHeader Defines the configuration header on a sheet. Contains the element Format
TextColumn Defines the configuration of the columns of type text in a sheet. Contains the element Format
DateColumn Defines the configuration of the columns of type date in a sheet. Contains the element Format
NumberColumn Defines the configuration of the columns of type number in a sheet. Contains the element Format