09-19-2008 4:23 PM
Hi All,
I am using the function module 'XXL_SIMPLE_API' to download data into the excel sheet.
By using the function Module the data is getting displayed in the excel but when we close the excel sheet , it is not getting saved .
Thanks in advance
09-19-2008 4:26 PM
Why dont you use GUI_DOWNLOAD instead? Search the forum, you will find lots of examples.
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = l_floc "File Path and name
filetype = 'DAT'
write_field_separator = ' '
TABLES
data_tab = i_outputtab " Output internal table
fieldnames = i_header "Column Header
EXCEPTIONS
file_write_error = 1
no_batch = 2
gui_refuse_filetransfer = 3
invalid_type = 4
no_authority = 5
unknown_error = 6
header_not_allowed = 7
separator_not_allowed = 8
filesize_not_allowed = 9
header_too_long = 10
dp_error_create = 11
dp_error_send = 12
dp_error_write = 13
unknown_dp_error = 14
access_denied = 15
dp_out_of_memory = 16
disk_full = 17
dp_timeout = 18
file_not_found = 19
dataprovider_exception = 20
control_flush_error = 21
OTHERS = 22.
09-19-2008 4:35 PM
Additional Info...
Earlier we were using the Function Module 'MS_EXCEL_OLE_STANDARD_DAT' nad we want to replace this as it has become obselete..
09-19-2008 4:45 PM
'GUI_DOWNLOAD' is newer than 'XXL_SIMPLE_API'. You dont have to worry about GUI_DOWNLOAD being obsolete.
'XXL_SIMPLE_API' was released in 1995
'GUI_DOWNLOAD' was released in 2001