Regarding reading the XL File

[Former Member]

Hi All,

Iam just reffering this Blog to read the XL file and convert into xml

Here Authour said like he used Java Excel API - open source Java API and he showd the code also

My doubt is using that code do we need to generate the Jar file ???

If yes means with that generated Jar file wat we have to do? Do we need to import it any where in XI??

Basically before calling the XL Module in Module TAB of CC what we have to do with that Java Code mentioned there

Regards

[Former Member · Accepted solution]

My doubt is using that code do we need to generate the Jar file ???

NO.You need not create jar file for the module processor.You have to deploy your module to the Application server.Then you can use the module name in the file adapter.

[prateek]

My doubt is using that code do we need to generate the Jar file ???

No. You have to create an SDA file and deploy it on adapter engine of XI. You are creating an adpater module in this case. Check for adapter module help on sdn and you will get the complete procedure there.

Regards,

Prateek

[Shabarish_Nair]

the blog shows how to create a adapter module and attach it to a file adapter that will help you read excel files.

how to create adapter modules -

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f013e82c-e56e-2910-c3ae-c602a67b...

refer the above link to help you develop an adapter module then use the blog to complete your requirement

[Former Member]

Hi,

With what code i have to create SDA file??

Regards

[prateek]

In the adapter module doc provided by Shabarish, you will find that a method called as process() should be implemented. This code is given in the weblog you posted earlier.

Regards,

Prateek