03-09-2009 1:23 PM
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
03-09-2009 1:29 PM
[Download internal table data into Excel|http://searchsap.techtarget.com/tip/0,289483,sid21_gci956793,00.html]
03-09-2009 1:31 PM
Hi Dude,
Go through this Link:[https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/downloading%252binternal%252btables%252bto%252bexcel]
03-09-2009 1:33 PM
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
03-09-2009 1:35 PM
03-09-2009 1:39 PM
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.
03-09-2009 1:41 PM
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