WinActor

2021.08.10
Libraries
ExcelOperation_SetFilter_SelectAll

Set a filter for a cell in an Excel file. After setting a filter, display all in the selected state.

* A cell can be specified in A1 style or R1C1 style.

Please see this precautions upon downloading this library.
Input
"Filename":
Specify an Excel file in absolute or relative path.

"Sheet_name":
Specify a name of a sheet. When omitted, the active sheet will be used.

"Cell_position":
Specify a header cell position to apply a filter. For example, B3 in A1 style is equivalent to R3C2 in R1C1 style.
* Specify a cell that contains data.
Output
Excel file with filtered cells by SelectAll method
Details
[History]
2021/08/10: Initial release
Operating environment
WinActor Ver.6.1.0, Windows10(checked on August, 2021)
Keywords
-