Method to upload Excel file

[Former Member]

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.

[Former Member]

This message was moderated.

[former_member491621]

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

[Former Member]

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