cancel
Showing results for 
Search instead for 
Did you mean: 

Excel upload and populate contents in view Model in UI5

Former Member
0 Kudos

Hello,

I am having a requirement to upload an excel or csv file (whichever is possible) from my UI5 application and display the contents from the file in a table format. I have created the table (oTable) and created binding with oModel. Also, I am able to upload the file using sap.m.UploadCollection.

However, I am unable to figure out how to get the contents from UploadCollection and set it to oModel so that it can be populated in the table.

Any help will be appreciated!

Thanks,

Charles

Accepted Solutions (1)

Accepted Solutions (1)

EkanshCapgemini
Active Contributor
0 Kudos

Hi Charles,

Please check this reply: .

Regards,

Ekansh

Former Member
0 Kudos

Thanks a lot Ekansh!! The reply from Raman Sharapinski works perfectly!!

Answers (2)

Answers (2)

Former Member
0 Kudos

When I am trying to upload the file in my ABAP server, I get the below error:

Failed to load resource: the server responded with a status of 404 (Not found)  

http://<serverurl>:<portnumber>/sap/bc/upload

Thanks for the help!

Charles

Private_Member_15166
Active Contributor
0 Kudos

Are you trying it to test in localhost??

If this is the case then proxy might help.

Use your URL like this. proxy/http/<serverurl>:<portnumber>/sap/bc/upload

Regards

Dhananjay

Former Member
0 Kudos

Is this even possible? I was reading some forums and realized that an excel file has to be first uploaded to a server and the UI5 application will have to read from the server.

Any ideas?

Thanks,

Charles

Private_Member_15166
Active Contributor
0 Kudos

Check out this link.

Former Member
0 Kudos

Hello Dhanajay,

When I am trying to upload the file in my ABAP server, I get the below error:

Failed to load resource: the server responded with a status of 404 (Not found)   

http://<serverurl>:<portnumber>/sap/bc/upload

Thanks for the help!

Charles