Excelreader-call

Definition

Many IT applications in their business process needs read an excel file. GreenVulcano Gvvcl-excel-reader Plug-in helps IT organizations integrate applications that utilize excel format to execute their business. Gvvcl-excel-reader Plug-in is compatible with all Excel format up to 2003, and is very simple to configure. It receive in input a stream of excel file and give in output an XML structure. At the output of Gvvcl-excel-reader Plug-in is possible apply a changeGvBuffer operation (with ognl script or a xsl stylesheet) to retrieve all interest data.

GreenVulcano ESB provides two tools, GVConsole and Vulcon, to configure all GreenVulcano supported Plug-ins in GV services.

Vulcon Configuration

File:CreateOperationExcelReader.png

Vulcon system excel-reader configuration

excelreader-call is the operation that must be configured into Vulcon system section, to convert a Excel file, in GVBuffer.object field, in a XML document. To add an operation excelreader-call user must perform the following operation:

• User open Vulcon system section and his channel
• User clicks the right mouse button and select "insert before" label --> excelreader-call
• In layout user fill in fields name "The name of operation that will be used in Vulcon Service section".
• Other fields "Class, OnlyData and type" will be ignored.

At this point, user have been configured an operation of type excelreader-call.

Next step in a GreenVulcano service will be configured a node that use this operation.

File:Service-GVvcl-excel.png

Vulcon service excel-reader configuration

In section service it's possible configure a GvOperationNode, with operation-name equal at system configuration.

Example use

1. Gvvcl-excel with a simple excel blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla

   ---

   Input File:InputSimpleExcel.jpg Output File:OutputSimpleExcel.xml

2. Gvvcl-excel with a complex excel blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla

   ---

   Input File:InputComplexExcel.jpg Output File:OutputComplexExcel.jpg