Apply a filter on excel sheet

[frederic-f.bonnet]

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

Thanks

[avejr748 (Ave Salvante Jr)]

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.