Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Upload Excel through Program into SAP BI/BW System

Former Member
0 Kudos

Dear ABAP Gurus ,

I have a requirement to upload an Excel File into SAP BI/BW System .

I tried FM  - GUI_UPLOAD  but it only Supports Text files.

I tried many Function Modules such as 'ALSM_EXCEL_TO_INTERNAL_TABLE' which was not at all available in BI/BW System 

Please Suggest me a Solution , i do not want to convert the XL-File into Text tab Delimiter .

Thanks & Regards

Gaja Abhinenyu Amsaraju

GJ

3 REPLIES 3

egenoves
Participant
0 Kudos

Hi,

once i have a similar requirement but instead of a BW system was a PI system.

Finally i found much simpler to copy the function ALSM_EXCEL_INTERNAL_TABLE to a Z function in the PI system. It uses OLE to upload the Excel data, and is quick to copy. Not so much includes to create and so on ...

Hope this help you,

Regards

matt
Active Contributor
0 Kudos

If it uses OLE it cannot be used in background.

0 Kudos

That's true, but maybe it's going to be a Dialog Process to load some data to BW...,

This was the problem on my PI server. It was very easy to replicate the ALSM function, and make very comfortable for the final user load directly the Excel sheets. No background process were involved,

Greetings