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 cell
  2. Read Cell → This activity returns the value of the cell
  3. Read Cell Formula → The activity returns the formula written in the cell
  4. Write Cell → This activity writes the value in the 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 the 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