GVExcelWorkbookConfiguration
Contents
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:
- Description
- GVExcelWorkbook
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 sub-elements 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:
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 |
Format
Defines the configuration of the cell in a Report.
The following table shows the Format element's attributes:
Attribute | Type | Description |
---|---|---|
minWidth | optional | Minimum width of the cell. Default 1. |
maxWidth | optional | Maximum width of the cell. Default 30. |
alignment | optional | Alignment of cell text. Default "LEFT".
The attribute's admitted values are:
|
hasBorder | optional | Border of the cell Default "0".
The attribute's admitted values are:
|
scaleFactor | optional | Cell zoom. Default "1". |
backgroundColour | optional | Background color of the cell. Default "white". |
pattern | optional | Format of the cell Number and Date. Default: Number: @ Date : dd/MM/yyyy hh:mm:ss |
Contains the subelements Font.
Font
Defines the configuration of a font in a report.
The following table shows the Font element's attributes:
Attribute | Type | Description |
---|---|---|
type | optional | Type Default "ARIAL".
The attribute's admitted values are:
|
size | optional | Dimension. Default "10". |
isBold | optional | Bold style. Default "false". |
isItalic | optional | Italic Style. Default "false". |
isUnderlined | optional | Underlined style. Default "false". |