Excel-call

Description

The GreenVulcano^® ESB plugin excell-call allows you to define the information needed to generate Excel reports from a select on the DB.

VulCon / GV Console Configuration

The excel-call Element is used by Channel and routed-call. It has the following attributes:

• type: call.
• class: it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation.
• name: Operation name. Used in the Flow section to associate workflow nodes to VCL operations.
• group: Reports group name.
• report: Report name.

and the subelements:

• Description
• GVExcelReport

GVExcelReport

Defines the configuration elements of an Excel report. It is used by excel-call and excelreader-call and has the following attributes:

• name: Report name
• group: Report group. Default Generic.
• jdbc-connection: JNDI name of a DataSource.
• format: Name of the style of the report. Default default.

Its subelements are:

• Description
• Sheet(s)

Sheet

This element defines the configuration of each sheet of the Report.

CompositeLabel: @id-@name

The Sheet Element is used by GVExcelReport. Its attributes are:

• id: Sheet id.
• name: Sheet name.
• title: Sheet title.
• jdbc-connection: JNDI name of a DataSource. Default to Report connection.

and its subelements:

• Description
• prep-statement
• statement