Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

GUI_DOWNLOAD

Former Member
0 Kudos

Hi,

I am downloading data from internal table to excel 2007. I am using GUI_DOWNLOAD function module. If internal table data contains special characters next data is merging into the same cell.

How can we download correct data from internal table to excel 2007 file.

thanks

Sreekala

6 REPLIES 6

former_member156446
Active Contributor
0 Kudos

[Download internal table data into Excel|http://searchsap.techtarget.com/tip/0,289483,sid21_gci956793,00.html]

former_member632729
Contributor
0 Kudos

Hi Dude,

Go through this Link:[https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/downloading%252binternal%252btables%252bto%252bexcel]

Former Member
0 Kudos

HI,

Special char quote and double quotes merge the cell. If these are not important then remove these from the data. Then GUI_DOWNLOAD will work properly.

Or you can use XXL_FULL_API FM

Former Member
0 Kudos

Hi,

make use of this function module...

SAP_CONVERT_TO_XLS_FORMAT

0 Kudos

Hi,

If i use function module SAP_CONVERT_TO_XLS_FORMAT it is not working for Excel 2007.

If u have any inputs please let me know.

thanks,

Sreekala.

0 Kudos

HI,

In the GUI_DOWNLOAD, give the filename with the proper extension and in the field separator give 'X'.

This way you can get the data in different cells.

And also you can use WS_EXCEL, but it is obsolete *.

Thanks

Sharath