You will need to use VBscript, PowerShell or similar scripting to do that. There are no native actions in PAD that can do this.
The following script can do it for you if you put it in a Run VBscript action:
Set Excel = CreateObject("Excel.Application")
Set Workbook = Excel.Workbooks.Open("%ExcelFile%")
Worksheets("%SheetName%").Range("%Range%").AutoFilter _
Field:=2, _
Criteria1:="F1"
Workbook.Save
Workbook.Close
Excel.Quit
Note: You will either need to provide literal values into the script for the variable placeholders, or set the variables appropriately before the Run VBscript action. The following variables are needed for this to work:
- %ExcelFile% - the full path to your Excel file;
- %SheetName% - the name of the sheet with the table. You could also do an index, like Worksheets(1) instead of using the name.
- %Range% - the range of your table. From your screenshot, I can see it should be E1:H7, but I set it to be a variable, in case your table can be larger and then you need to get the first free row first and use that.
The script will open Excel, apply the filter, save it and close it. So, you do not need to use Launch Excel or Close Excel in PAD itself. If you need to open Excel before or after the script, you can also do that, but make sure you close it appropriately.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
