how to merge cell and get border in excel file

[Former Member]

HI ,

i have data in internal table i want to download it in excel format but i want borders also

can anyone please suggest me how to achieve this

Thanks

Ashish

[amy_king · Accepted solution]

Hi Ashish,

I haven't tried doing this myself but there is a document on SCN by Kiruthika Periyasamy which demonstrates how to export Excel from WDA into a formatted Excel worksheet. From reading a few SCN posts, it sounds like what you want to do is possible though not an easy task and requires use of either the iXML library or XSLT transformations. I haven't found any step-by-step tutorials on using these however.

Cheers,

Amy

[former_member186491]

Hi Ashish,

Please refer following links for different scenarios of handling / formatting data in Excel -

http://wiki.sdn.sap.com/wiki/display/ABAP/Handling+Data+in+Excel+In-place+Display+Using+BDS

http://wiki.sdn.sap.com/wiki/display/ABAP/Exporting+data+to+Excel+-+XML+to+the+rescue

http://wiki.sdn.sap.com/wiki/display/ABAP/Excel+data+formatting+and+analysis+using+ABAP

http://www.erpgreat.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

All these are not exactly of your immediate use, however, its very elaborative to go through to have full understanding of the possibilities.

Hope this can help you achieve your goal.

Thanks.

Kumar Saurav.

[Former Member]

Hi Kumar

i need code in webdynpro -abap as i am trying to implement excel borders in webdynpro abap