Skip to Content
avatar image
Former Member

get Only filtered column data from excel file

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?

Thanks.

Rohit.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 20 at 11:32 AM

    Hi,

    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.

    Add comment
    10|10000 characters needed characters exceeded