Articles → UiPath → Get Cell Color, Read Cell, Read Cell Formula And Write Cell Activity In Uipath

Get Cell Color, Read Cell, Read Cell Formula And Write Cell Activity In Uipath






Purpose


  1. Get Cell Color - This activity returns the color of the particular cell.
  2. Read Cell - This activity returns the value of the particular cell.
  3. Read Cell Formula - The activity returns the formula written in the particular cell.
  4. Write Cell - This activity writes the value in the particular cell.

Example




Picture showing the sample excel file

Click to Enlarge



  1. Read the color of the "B2" cell.
  2. Read the value of the "A1" cell.
  3. Read cell formula from the "C2" cell.
  4. Write the value of the above three cells in "C6".
  5. Picture showing the Get cell color, Read cell, Read cell formula and Write cell activities in UiPath

    Click to Enlarge



Output


Picture showing the output of the Get cell color, Read cell, Read cell formula and Write cell activities in UiPath

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, January 14, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250