Pruthvi.G
(Code_Hyyy)
1
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
Pruthvi.G
(Code_Hyyy)
4
Hi @ashwin.ashok ,
Thank you for your help. I got it but did not have to add 65 to index variable.
system
(system)
Closed
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.