Create Excel file in PI

[shweta_walaskar2]

Hello,

Can someone please help me in creating Excel files in PI?

I am referring to this code, can I achieve this using Java mapping?

Thanks.

Best Regards,

Shweta

[Former Member]

Hi Shweta,

If file is in receiver side you can try with following solution.

1. give file name extension as .xls

2. Give field Separator as "tab"(hexadecimal value of tab).

This solution doesnu2019t work for sender adapter. but it works for receiver adapter

regards,

Navneet

[shweta_walaskar2]

Hi Navneet,

Thanks.

I have already tried this. It creates a file which gives a warning while trying to open as it is a CSV file.

If you confirm this warning, then only you can open this file which will not be acceptable.

Do you have an idea about above mentioned line of code to be adapted for java mapping?

Thanks.

Regards,

Shweta

[Former Member]

Hi Sweta,

Where r u creating your file..

Local to PI or using FTP server.

For me I created it in PI server only and while opening used file format as spreadsheet.

it worked.

Regards,

Navneet

[shweta_walaskar2]

Thanks to all who have helped.I could achieve this using an adapter module.

Best Regards,

Shweta

[Former Member]

Hi,

>>>>>>I am referring to this code, can I achieve this using Java mapping? Which Code

Look at the following threads for excel file creation from PI

regards

Ramesh

[shweta_walaskar2]

Hi Ramesh,

sorry to have missed the link.

https://wiki.sdn.sap.com/wiki/display/XI/CODE%20-%20Create%20an%20Excel%20File%20via%20the%20JExcel%...

yes, this post also mentions the same link,but do we have a working example?

Regards,

Shweta

[Former Member]

Hi Shweta,

The link itself contain working model right?

Just you have created the necessary design and configuration objects. I think you can easily re do the same scenario which is explained in the link.

Even Michal has [explained |http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2803] [original link is broken] [original link is broken] [original link is broken];the conversion to excel using XSLT mapping, but that is not suggested as well.

Try configuring the scenario and let me know where you find the difficulty in constructing the scenario.

Regards

Ramesh

[shweta_walaskar2]

Hi Ramesh,

The doubt is regarding following statement:

WritableWorkbook workbook =

Workbook.createWorkbook(new File("output.xls"));

How would I adapt this code to enable java mapping to create this file on FTP server.

I have configured design and configuration objects with a file receiver to create a file in a folder on FTP server with name a.xls

Thanks.

Regards,

Shweta