Skip to Content

get Only filtered column data from excel file

Jul 17, 2017 at 11:08 AM


avatar image

Hi Guys,

i have a requirement :

Customer is going to upload the excel through fiori app. at frontend i'm converting that files data into ibject and send it to SAP backend. now when user filterd data and post it to fiori i'm struggling here to find out only filtered data, here i'm getting all excel file data not only filtered column data.

i'm using xlsx to work with excel.

can somebody help me on this?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Iftah Peretz
Jan 20 at 11:32 AM


Can you send your code, or better yet create a working example in JS Bin/JSfiddle etc?

The reason is that I can try and explore the API you are using and the object you are passing to the backend, with the hope of detecting a filter array or suggest a different API to use - not sure this is feasible, but worth a check.

As a workaround, I would instruct the user to only upload the Excel as is. If he/she wants a filtered one, he/she would need to create it as a sperate file. Or have him/her pass the regular file and have him/her input the filter values as he/she uploads it and you then have the filter values.

10 |10000 characters needed characters left characters exceeded