on 08-01-2008 8:58 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.