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
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
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
Hope this will help you
Thanks
Hi Srini,
Above codes are giving some error as below.
Hi @varun_shinde1 ,
In the Write Cell
, You would require to use Cell()
instead of Range()
Excel.Sheet("YourSheetName").Cell("A1")
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
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.