Download a file, Modify and again Uploading

[Former Member]

Hi all,

I am downloading a table from SAP into a excel using gui_download using the FM in following way

call method cl_gui_frontend_services=>gui_download

exporting

filename = 'C:/test.xls'

write_field_separator = 'X'

changing

data_tab = iexcel.

Where iexcel contains all the SAP table contents

This is working absolutely fine . Later on I am modifying the the downloaded file and trying to upload using the FM

SAP_CONVERT_TO_XLS_FORMAT

Now the problem is

The EXCEPTIONS

CONVERSION_FAILED = 1 "

So I am getting conversion failed error.

What is the problem in this approach .. and is gui_download giving me .xls only ???

[Harsh_Bansal]

Hi,

Try using GUI_UPLOAD for uploading the file back..

Regards,

Harsh Bansal

[Former Member]

Hi venk,

What is the problem in this approach .. and is gui_download giving me .xls only ???

Answer for your above mentioned question,

GUI_DOWNLOAD will download in all format , which ever format your are mentioning in

filename = 'C:/test.xls' , If you want you can download it in .txt as well and use GUI_UPLOAD for upload the XLS ,

And answer for your issue:

Check this [Thread|; too.

Regards,

Saravana.S

Edited by: saravanasap on Feb 8, 2012 6:10 AM

[Former Member]

Hi,

When using gui_download, specify the filetype option as 'ASC' and try using gui_upload with same parameters. Because with the FM SAP_XLS_CONVERT I aslo faced issues.

Regards,

Ramya