Write cell beyond a to z range in Gsuite - Google Sheets?

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

grafik

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?

image

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

3 Likes

@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

2 Likes

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

1 Like

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