I have created a excel template and applied filtering for some columns,
that filtering is applied to excel based on the seletion on UI by the user.Problem is that when user selects any filtering condition it applied to the excel and items gets filtered but:
1. Filtered condition actually deletes the rows from excel, instead of just showing the filtered view.
2. When I select 'All' from the filter dropdown all data becomes blank, reason could be that filtered data rows has been deleted and now 'All' cannot show all the data back again.
Pls give me some urgent solution.