Set Range Color
This action is used to set the foreground and background color for a specified range.
Properties
Input
Excel Document: File name for the target Excel document.
WorkSheet: The target worksheet name.
Cell Range: The target range.
Foreground: The foreground color.
Background: The background color.
Both foreground and background colors need to be a System.Drawing.Color object.
Misc
Display Name: action display name in your implementation project
Wait Before: number milliseconds robot to wait before executing the action.
Wait After: number milliseconds robot to wait until moving to the next action.
Abort on Error: True/False
Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.
Use Case
Potential Use Cases
Color the headers of an excel file for a better identification.
Color the columns or rows of an excel file for a better differentiation.
Color specific cells of an excel file in order to highlight important data.
Examples of Using Set Range Color
Example
Watch the robot in action:
You can check and download the example from here:
Last updated
