Excel file output from SAP System

[Former Member]

Hi All,

I have a requirement to extract data from SAP System and provide excel output (.xls file).

Should I use XI for this scenario. I understand that there are Function Modules in ABAP that can render excel files very easily.

I tried a sample scenario where I used tab as delimiter in Content conversion and gave "a.xls" as filename.The file is rendered and it opens as excel file, but it gives out a warning. I am thinking of not using Modules/Java Map for excel file processing.

Please guide me through the correct design approach.

Regards,

Sudharshan N A

[Former Member · Accepted solution]

Dear Sudharshan,

For this purpose we can use

MessageSwapBean, MessageTransformBean.

Please search for the same to send get the output as excel file.

Best Regards

Praveen

[Former Member]

Sudarshan,

Just taking a wild guess here. Try saving the output file with , as delimiter and the file name with extension .csv By default csv files are rendered using MS excel. But have never attempted this.

Regards,

Jaishankar

[Former Member]

Hi,

Thanks Mario and Jai.

Mario: I am in full agreeement of your approach.

Jai: Yes you are right. If we output comma separated .csv file, it will be by default openend with Excel. But What I am concerned that if the customer wants only .xls (Excel File), then what should be the approach.

Regards,

Sudharshan N A

[Former Member]

>>What I am concerned that if the customer wants only .xls (Excel File), then what should be the approach.

Then you can not escape the clutches of Java. Either an adapter module or the mapping is the only solution I could imagine.

Regards,

Jaishankar

[Former Member]

Hi Sudharshan,

if you do not need any mappings, try to find a appropriate RFC that is able to send the rendered xls data in a file.

In XI so you just have to route the file to the receiver.

Regards Mario