topic Re: Method to upload Excel file in Application Development and Automation Discussions

Method to upload Excel file

Former Member — Sun, 13 Jan 2013 08:50:09 GMT

Hi,

I'm using the method cl_gui_frontend_services=>gui_upload to upload Excel file.

I tried all the ways changing the parameters filetype to 'ASC', 'BIN', 'DAT' & even has_field_separator to space, '#', '|' but I'm getting junk values into my internal table.

I know how to upload Excel file using Function Modules.

I DONOT want to use Function Modules for uploading Excel file, I want to achieve this only thru Class=>Method.

Can we use cl_gui_frontend_services=>gui_upload for uploading Excel file? If you have achieved this using this method, please post the code snippet.

Also kindly let me know if we have any class methods other than this to upload Excel file?

Thanks & Regards,

Adithya M.

Re: Method to upload Excel file

Former Member — Sun, 13 Jan 2013 09:50:43 GMT

This message was moderated.

Re: Method to upload Excel file

former_member491621 — Sun, 13 Jan 2013 14:19:26 GMT

you can check the below link for your requirement

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+-+Upload+data+from+Excel+to+Sap+using+OO

hope this helps

Re: Method to upload Excel file

Former Member — Wed, 16 Jan 2013 11:03:26 GMT

hey......

try this......

this obeject oriented programming helps you even if you want to upload more than one worksheet in the excel

http://www.erpgenie.com/sap-technical/abap/upload-an-excel-file-to-internal-table