How to write cell in a column exceeding the range A to Z

How to write cell in a column exceeding the range A to Z. I want to write in the cell AU without directly mentioning AU in the cell address.

I have used an assign activity and assigned Column Index to it.

I used Convert.ToChar(65+ColumnIndexVariable) in the cell address but bot is not writing in AU cell, instead it is writing in some other cell.

Please help me in this regard.

Thank you.

Hi @Pruthvi.G ,

Could you give this a try and let us know?

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(65+ColumnIndexVariable)

Kind Regards,
Ashwin A.K

1 Like

grafik

2 Likes

Hi @ashwin.ashok ,

Thank you for your help. I got it but did not have to add 65 to index variable.

Hi @ppr

Thank you so much!!

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