Skip to Content
0
Former Member
Aug 26, 2013 at 06:09 AM

Export Abap Report to Excel .CSV Format

1328 Views

Dear All,

I have a requirement to download the SAP report to Excel .CSV Format . I am using FM 'SAP_CONVERT_TO_CSV_FORMAT' and FM '

GUI_DOWNLOAD' to download the file to .csv format. The problem i am facing is the file is downloaded to excel .csv format but all the values are present in single column . Eg. Field1 , Filed 2 ..... all are present in the A1 Cell i.e present in the single Column . I want the data to be displayed in separate columns . Eg. Field1 in a1 Cell , Field2 in B1 Cell ......etc.

Could anyone please show me a way around this.

Regards

Amba