WinActor

2021.08.02
Libraries
ExcelOperation_SetColorFilter

Set a color filter for a cell in an Excel file.

* A cell can be specified in A1 style or R1C1 style.
* After setting a color filter, you can specify a condition for the cells to be displayed by narrowing down the condition.

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 color filter.
For example, B3 in A1 style is equivalent to R3C2 in R1C1 style.
* Specify a cell that contains data.

"Column_number":
Specify a column to apply the filtering condition by number. Example) C1: 3, E2: 5
* The range will be automatically set at the specified cell position, and the first column in the automatically set range will be 1.

"Red":
Specify the red intensity of RGB value between 0 and 255.

"Green":
Specify the green intensity of RGB value between 0 and 255.

"Blue":
Specify the blue intensity of RGB value between 0 and 255.
Output
Excel file with color filter applied
Details
[History]
2021/08/02: Initial release
Operating environment
WinActor Ver.6.1.0, Windows10(checked on July, 2021)
Keywords
-