Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kannan Chandrasekar (Kannan-PEGA)
Infinite Computer solution
Senior technical lead
Infinite Computer solution
IN
Kannan-PEGA Member since 2017 7 posts
Infinite Computer solution
Posted: May 29, 2019
Last activity: Jul 2, 2019
Posted: 29 May 2019 5:57 EDT
Last activity: 2 Jul 2019 1:02 EDT
Closed

How to get background cell color using pega RPA

Hi All,

i have faced some issues to take cell background color using pegaRPA.

My process flow is : i have one excel with value. Once done my excel cell validation its showing red color if any value mismatch. so how to get cell background color because we can send mail notification to client if shown in red color in excel sheet.

i have attached the excel sheet for your ref

Note : Data value range is E7 TO AD14

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 2 Jul 2019 1:02 EDT
Vaspi Prasad Gummadelly (Vaspi)
PEGA
Manager of Technical Support Engineering
Pegasystems Inc.
IN

Hello, 

 In the excel connectors you have  methods to fetch the background color 

 GetCellBackgroundColor(String address)

 GetCellBackgroundColor(Int32 row, Int32 column)

Regards,

Vaspi

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice