Skip to Content
0
Former Member
Mar 11, 2010 at 06:49 AM

Excel to internal table in BW 3.1 version

79 Views

Hello,

I am trying to develop ABAP program in BW system. I have to upload the excel file to internal tables but normal function modules like ALSM_EXCEL_TO_INTERNAL_TABLE and KCD_EXCEL_OLE_TO_INT_CONVERT does not exist in this BW/BI system. Function modules GUI_UPLOAD, WS_UPLOAD are available and they work great for CSV files. If I try to load xls file directly I am getting all #### and some junk charecters in internal table. Any way to make this work?

Also we have check the FM 'MS_EXCEL_OLE_STANDARD_DAT' , but with this FM we are getting exception file_not_exist.

So how we can solve this issue or is there any other FM thorugh which we can upload the file.