How to remove filters for a specific excel sheet

Help Studio
, , , ,
1

HI Team,

I have a scenario where I need to remove the Filters of a specific sheet in Excel if any filters are applied. Should not use hotkeys.

In simple words.

I need a code where, Input : It accepts Excel file name and sheet name as parameters.
code functionality : remove filters for that sheet if any are there in that sheet.

Output : Excel sheet after removing filters to that sheet.

Note : We used and tried “use filters” option in excel ->read range .

Regards,
Srikanth

2

You might want to record a Macro in Excel and save the Excel as a Macro-enabled workbook (.xlsm file). Use the “Run Excel macro” activity to invoke the macro and pass input parameters to it to apply the filters.