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

prep-statement

Preparation statement for Excel report generation. Are executed after the report statement. Can contains placeholders.

Its attributes are:

• type: Must be "Excel Sheet : insert|update|callsp". The attribute's admitted values are:
  • select
  • insert
  • update
  • callsp
• id: prep-statement Id.