How to write a value to excel based on its cell address in coordinates only

Help Studio
, ,
1

I used to write in excel using below expression

Excel.Sheet(“Sheet2”).Cell(1,2)

Now - I dont see that option. It is accepting only in normal cell adress
Excel.Sheet(“Sheet2”).Cell(“A2”)

Kindly help me to write in number format only.

2

@sharazkm32,

You can use excel utility to get it working. You can get the address by the below logic and pass it to the range.

columnNumber=1

rowNumber=2


strAddress = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(columnNumber)+rowNumber.ToString()

Excel.Sheet("Sheet2").Cell(strAddress)
3

Thank You @ashokkarale for the suggestion

I have also ended up with the above solution only. But I do remember the option of using cell coordinates. Is that no longer valid in UiPath Modern Activities?

4

@sharazkm32,

Glad to hear.

No it’s not longer valid.

Cheers!

5

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