Apply a filter on excel sheet

Hi ,

I need to set a filter to unselect a client category ( clients collectivités) on the export bellow:

here the configuration of filter


in this situation the filter not run at all , pls could help me :slight_smile:


Hi, I’m not sure of your use case but in my opinion it would be easier to just read range the whole excel sheet into datatable and then do the filtering in the datatable. Afterwards, use write range to have a new filtered excel output.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.