How to read cell - AA1

Hitesh1 · August 19, 2020, 3:59pm

Hi All,
Can someone tell me how to read cell “AA1”
I am getting error message - can not convert from System.Double

Thanks

Pratik_Wavhal · August 19, 2020, 4:19pm

Have a look to the below Thread for the same :-

In the above thread it is mention that how to read the Cell after Z.

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

Hitesh1 · August 19, 2020, 4:39pm

i tried – “A”+Convert.ToChar(Convert.ToInt16(65))+“1”.ToString
but no luck

Can you please help in this

Thanks

Pratik_Wavhal · August 19, 2020, 4:59pm

Below is the workflow for the same :-
MainPratik.xaml (7.1 KB)

Output :-

Char cell_col = [

“A”+Convert.ToChar(Convert.ToInt16(cell_col)-26)+“1”

Have a look to the below img :-

After Capital Z Again A starts right ??

So in the same way after Capital Z If we increment the Ascii Value then it is [

So after Subtracting 26 from the Ascii Value of [ We get Capital A

"A"+Convert.ToChar(Convert.ToInt16(Convert.ToChar("["))-26)+"1"

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

Hitesh1 · August 19, 2020, 7:07pm

Thanks, It worked

system · August 22, 2020, 7:07pm

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