WSO2 / Axis2 Excel Message Builder

Description

The purpose of this project is to build a custom message builder in order to treat xls and xlsx documents. In a first version it will only convert the content of the document in csv and put it as a text in the payload. If the document contains several sheets they will be all parsed in a separate text tag with a name attribute.

Dependency

In order to read and transform xls files we are using Apache POI

Build

Build is performed via maven so simply run the following command to build the jar

mvn clean instal

Deployment

To use this new builder you have to copy the library (poi-ooxml) and the generated jar to WSO2 component directory {WSO2_HOME}/repository/components/lib Then you need to setup axis to use this message builder for a give content type

<messageBuilder class="org.wso2.custom.ExcelMessageBuilder" contentType="application/binary"/> 

Use in Wso2 EI (or ESB)

<property expression="//sheet[1]/@name" name="name" scope="default" type="STRING"/>
<payloadFactory description="Select First Sheet" media-type="xml">
  <format>
    <Text>$1</Text>
  </format>
  <args>
    <arg evaluator="xml" expression="//sheet[1]"/>
  </args>
</payloadFactory>
<!-- Parse CSV Usign Script Mediator -->
<script language="js"><![CDATA[var csv = mc.getPayloadXML();   
  var lines = (csv + "").split("\n");
 	for (var l = 1; l <= lines.length; l++) {
 	  cells = (lines[l] + "").split(";");
  }
]]></script>