upload excel into internal table using classes having junk values

[Former Member]

hi

i am trying to upload excel to internal table using the class method-cl_gui_frontend_services=>gui_upload, but, i am getting junk values in debug mode.

need some input on how to resolve this.i am not using 'ALSM_EXCEL_TO_INTERNAL_TABLE' as it is unreleased and customer doesnt want that.

do let me know if there is any class method to validate if excel file is tab limited or not?

i searched sdn before posting but unable to get solution.

thanks!

[Former Member]

I am able to get the values in to internal table and i am using the FM'TEXT_CONVERT_XLS_TO_SAP' to get exact values in to internal table.since this FM is unreleased is there any class to get the same functionality?i am searching for the class method, incase, anyone has idea...let me know