User testing

[Oratile_Mogajane (Oratile Mapuleng Mogajane)]

Hello everyone ,

How do I input text into an Excel column , which activity do I use?
I want to input True/ False values into my Excel data table after clicking on a property on my Web application.

Thank you.

[Shiva_Nikhil]

@Oratile_Mogajane

use write cell activity for writing single value

use write range activity for writing entire tabular data to excel

[Palaniyappan (Palaniyappan P)]

@Oratile_Mogajane

How do I input text into an Excel column , which activity do I use?

To do this there are two ways

Either if u know the row column position then you can mention value using WRITE CELL activity

Or

First read the excel file with USE EXCEL activity and inside that use READ RANGE activity and get the output as datatable
Then u can add value to it

I would recommend to have a view on excel and datatable training in UiPath academy

For further details

Check this video for a quick demo

Write Cell & Write Range activity to set data into a Google Sheet using UiPath|RPA|Gsuite Automation

Working with DataTables and DataRows in UiPath | Full Tutorial

Cheers @Oratile_Mogajane