How To Clear Filters in Excel

[randy.stokes]

Hi,

I am attempting to clear filters on multiple Excel sheet. I want to clear the filters so all data is shown for each sheet in the workbook. The print screen shows the code I have defined for Invoke VBA Code with ActiveSheet defined as Inbound Argument. I am unsuccessful on how to pass the name of the active worksheet to the “ActiveSheet” argument. Any suggestions would greatly appreciated.

[Gokul_Jayakumar (Gokul Jai)]

@randy.stokes
Kindly pass the sheet name in the value

[Gokul001 (Gokul Balaji)]

Hi @randy.stokes

Check out this thread

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Regards
Gokul

[Sudharsan_Ka]

HI @randy.stokes

Try these steps

• Excel application scope

  • Get workbook sheets store in sheets

• For each item in Sheets

  • Invoke vBA parameter as Item.ToSTring

Method 2: Enable modern in the activities panel

Steps will be like

• Excel application scope

  • Get workbook sheets store in sheets

• For each item in Sheets

  • Excell Process Scope
    • Use Excel File
      • Filter actvity and enable clear existing filter and pass the sheet as
        “Excel.Sheet(Item.ToString)”

Hope this Helps

Regards
Sudharsan

[randy.stokes]

Your suggestion worked. Thanks.

[Sudharsan_Ka]

Hi @randy.stokes

Kindly mark the appropriate post as solution , so that it will be helpfull for others too

Happy Automation!

Regards
Sudharsan