Skip to Content
Dec 23, 2008 at 09:39 AM

Uploading the data from EXCEL to internal table


hello all,

I am working on a BDC where i am getting data from a EXCEL sheet , which i need to get in into internal table, i am using method 'cl_gui_frontend_services=>gui_upload' and kept

filetype = 'BIN'. I know that this method is only useful for csv or tab delimited , so iam getting the data in Binary format, Now i want to convert this to ASCII to pass the data to the BDC.My problem is , i am unable to convert the binary data to ASCII data.

is there any other method.

i am currently working in SCM where the func. module 'ALSM_EXCEL_TO_INTERNAL_TABLE' and 'KCD_EXCEL_OLE_TO_INT_CONVERT' are not there.

help me in solving this.

with regards,

sandeep akella.