Description

Gets the color of the cell or a range of cells. The output would be a color variable.



Attributes

Output

  • Color - The color variable output of the activity.

Input

  • 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.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains and looks like. 

  1. Add an Excel Sequence activity inside the initial Sequence.
  2. Create a System.Drawing.Color variable and name it color. Select Excel Sequence as its scope.
  3. In the File Path field, search for and select your Spreadsheet document using the browse button.
  4. 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".
  5. 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.
  6. 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: