Write an excel file using File adapter

[Former Member]

Hi,

I have a scenario in which i have to write an excel file in the target system.

I tried creating a tab delimited file conversion and just named the file as .xls.

When i saw the output file it did look like a excel but a report that i have written to read a excel file cant read it.

The report says 0 records found. It works for other excel sheets that are created manually.

So will this method noit work for creating excel files?

Is using the jexcel api the only option for this?

[Former Member · Accepted solution]

Have u had a chance to see this excellent blog by shabarish...

chekc this

/people/shabarish.vijayakumar/blog/2009/04/05/excel-files--how-to-handle-them-in-sap-xipi-the-alternatives

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

[Former Member · Accepted solution]

Thanx to all of you for your responses

[Former Member]

Hi Sivasakthi,

Have you resolved this issue??, Even i was also facing same problem could you please provide me ways to resolve.

Regards,

Anusha Penneru

[avishek_gorai2]

Hi,

If you want to create an .xlsx file you can do this by creating a Message/Service Interface from the schema of an excel (2007) file and populate the data in this message according to the schema, later save the file as .xlsx from the File channel. However for .xls I think you will have to use adapter modules.

Regards,

Avishek.

[Former Member]

Hello Avishek,

this solution sounds interesting to me and i am curious on how you did this!!!

Can you provide some HowTo or Link where i can see how to do this?!

br Jens

[Former Member]

Hi,

Yes you need to use the API for creating the EXCEL ...by default the content is not supported...by the adapters..you need to write own module for the same...

in case you are looking trying to do the same...for a quick start there is a link in wiki go through the same....

HTH

Rajesh