Gets the color of the cell or a range of cells. The output would be a color variable.
Color - The color variable output of the activity.
Column - The column where the color would be collected.
Row - The row where the color would be collected.
Worksheet - The name of the sheet where the range would be appended.
ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.
DisplayName - Renames the activity.
For this example, this is what the sample Spreadsheet contains and looks like.
- Add an Excel Sequence activity inside the initial Sequence.
- Create a System.Drawing.Color variable and name it color. Select Excel Sequence as its scope.
- In the File Path field, search for and select your Spreadsheet document using the browse button.
- Inside the Excel Sequence, add a Get Cell Color activity, and in the Worksheet field, type the name of sheet you would use. For this sample, it is "Info".
- In the Column field, write "A", and in the Row field, write "1". This means this activity would get the cell color of the cell in Column A and Row 1.
- Next to Get Cell Color, add a Write Line activity, and in the Text field, write color.ToString.
The output should look like this in the Output panel: