Get Cell Color

Gets the cell color.

This activity retrieves the color properties of a user-specified cell in a given workbook using the Microsoft Graph Get range format API and returns the cell color as a hex value (ex:-#4d0000) from the retrieved color properties.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Sheet Name: String Argument Required Specifies the sheet name from which the cell color is to be retrieved.

• Cell Address: String Argument Required Specifies the address of the cell from which the color is to be retrieved. Input the address in A1-style notation. This property doesn't support range values. For example: "A1:A3".

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data is to be retrieved. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].

Output

• Color: String Variable Required Specifies the color of the user-specified cell in a HEX format.