hi,
we r upgrading from 3.1i to 4.7.
using the function module EXCEL_OLE_STANDARD_DAT TO DONLOAD to excel.
this function module works fine in 3.1i. when executed in 4.7 its giving short dump if internal table is of packed or currency or quantity.
if internal table converted to character its working.i dont want to convert and download as it may be used in some other application.
pls give me the function module which downloads to excel which takes all data type.
Regards
Ajay
I usually use the class CL_GUI_FRONTEND_SERVICES and the method GUI_DOWNLOAD. Just choose filetype ASC and pass a X to the value write_field_separator. This will write out a tab-delimited text file that Excel should have no problem reading. This is very similar to using the old WS_DOWNLOAD or DOWNLOAD function module.
Hi Thomas,
I have had the same problem a couple of days ago. After analysing the class-methods i realized, that it won't work.
In fact there is a property for exporting header-lines, but it won't be used by the excel exchange; only for the text-export!
It is funny, becouse some methods are reading the complete DDIC Infos; except the header-textes:((
I am sorry to tell you that.
BR
Michael
Add a comment