Hello Everyone,
Greeting for the day.
I am using GSUITE and trying to write in a cell using write cell activity beyond A to Z, let’s say Cell AF2. How do we write into that cell without entering the cell address as “AF2” in the reference cell. I want to get it by giving the column index.
Please help me out asap.
If you want to get the last column you can do it in 2 ways
First the balareva activity second is with this part of code, yourDT.columns.count the pass this index in your write cell
Regards
@fernando_zuluaga Thanks for your response, No, it’s not the last column and am using Google sheets not excel.
Does this work for Gsuite - Google sheets?
Hi @Pruthvi.G ,
Is this what you were looking for?
As long as you can compute the index, you can using this snippet of code to perform the conversion →
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(32)
Would that help?
Kind Regards,
Ashwin A.K
@ashwin.ashok Thanks for the response but I am looking for help in GOOGLE SHEETS and not excel. Is there a way to do it in GOOGLE SHEETS?
Hi @Pruthvi.G ,
I understand that, but you wanted the range, correct?
This snippet of code with allow you to compute the range, which you can them pass into the range like so →
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(32) + int_index.ToString
Kind Regards,
Ashwin A.K
Got it @ashwin.ashok
Thank you so much. That helped!
Always happy to help!
I’d appreciate it if you marked the answer as Solution so that others facing similar issues may benefit from it aswell, and also so as to close this thread.
Kind Regards,
Ashwin A.K
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.