Problem with Creating Excel File

[Former Member]

Hi,

I used code mentioned link below (wiki),

When i execute the code error occured.

Wiki Link

http://wiki.sdn.sap.com/wiki/display/XI/CODE-CreateanExcelFileviatheJExcel+API

Error

java.lang.NoClassDefFoundError: jxl/biff/XFRecord

How can i solve this problem.

Note: I added jxl.jar into my project.

Thanks.

[Former Member]

No solution

[Former Member]

as it is given clearly in the wiki

This wiki is in extension to the blog Excel Files - How to handle them SAP XI/PI (The Alternatives)

The below class uses the JExcel API to create Excel files. The code is neither part of a java mapping nor an adapter module but is a sample that will help the reader as a reference when he/she is required to custom code in XI/PI.

so you have to create a custom adapter module use the logic given in this wiki to create an excel file(you have to do the changes according to your requirement)in the process method and after deploying you can use in the module tap of the communication channel

refer this http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f013e82c-e56e-2910-c3ae-c602a67b918e

for how to create Module

[Shabarish_Nair]

are you using the jar files of the jexcel api as from here - http://jexcelapi.sourceforge.net/

[Former Member]

Yes