How to Define Range for Write Cell Activity in Ui Path

Hi All Friends,

Please tell me how i can use Write Cell Activity to enter text to Particular Column in Exel. I am not able to set Range Property for this. Please find Attached screenshot for this error.

Thanks and Regards,
Varun Shinde

@varun_shinde1

If you want to write to the Cell then use Write Cell actvity and write as below

If you want to write as Range then use Fill Range and write as below

image

Hope this will help you

Thanks

1 Like

Hi Srini,

Above codes are giving some error as below.
image

Hi @varun_shinde1 ,

In the Write Cell, You would require to use Cell() instead of Range()

Excel.Sheet("YourSheetName").Cell("A1")
2 Likes

Hi

If you want to type in a specific single cell then use WRITE CELL activity

And your scenario looks like you want to type in a specific cell

So use a write cell activity and mention like this

In What to write - Updated Successfully

In Where to write -
Excel.Sheet(“YourSheetName”).Cell(“A1”)

If its not A1 then mention the cell position where you want to type but it should be a single cell

If you want to type for a range of cell then use WRITE RANGE activity

Cheers @varun_shinde1

1 Like

@varun_shinde1

When you are using Write Cell, then you have to give it as a cell, not range

so write as Excel.Sheet(“YourSheetName”).Cell(“A1”)

If you want to write in a range then use Fill Range activity and give range as below

Excel.Sheet(“YourSheetName”).Range(“A1:A2”)

Hope this will help you

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.