cancel
Showing results for 
Search instead for 
Did you mean: 

Fiori Upload Excel Ignoring First line

glauco
Active Contributor
0 Kudos

Hi!

I've read this blog but it reads entire file and set it to a worklist on a view.

https://blogs.sap.com/2020/05/27/read-data-from-excel-file-.xlsx-in-sap-ui5-app-and-display-contents...

But in my case I need to read an Excel which has:
1- First line has a text that I want to ignore.

2- And I need to ignore some lines.
For example document 1000000085 I must ignore, because I already added once in database in backend.

And I could not get it working.

Accepted Solutions (0)

Answers (1)

Answers (1)

gregorw
Active Contributor
0 Kudos

If you want to handle it on the frontend I would suggest you check out UI5 custom control ui5-cc-excelupload. I'm sure 20eed143c19f4b82bc4cf049916102cb is open for contributions. Maybe your requirement is already supported.

Otherwise you can go for a solution in the backend and use abap2xlsx if you have an ABAP Backend.

glauco
Active Contributor
0 Kudos

We're doing it in SAP BTP.

I'm going to analyze this link.

Many thanks Gregor.