Hi All. I want to find last cloumn Address in excel sheet. It is like, A5, B6

[Rambabu_N]

Hi All. I want to find last cloumn Address in excel sheet. It is like, A5, B6. Please help me on this

[rlgandu (Rajyalakshmi Gandu)]

@Rambabu_N

Use Find First/Last Data row

[lrtetala (Lakshman Reddy)]

Hi @Rambabu_N

Use Find First/Last Data Row activity

[Rambabu_N]

Thank you. can you please do one example. I am very new to this Ui path

[rlgandu (Rajyalakshmi Gandu)]

@Rambabu_N

[Rambabu_N]

@rlgandu , from this we are getting only Numeric. But i need character “A”

[Anil_G (Anil Gorthi)]

@Rambabu_N

As you know the column already …after getting the number you can just append it with A infront

"A" + retrievedValue

Cheers

[postwick (Paul Ostwick)]

I suggest doing the free training on the UiPath Academy web site. This will give you a foundation of knowledge that makes it easier to understand these things.

[rlgandu (Rajyalakshmi Gandu)]

@Rambabu_N

You know the column already after getting the number assign

Result=“A”+Last_row.ToString

[rlgandu (Rajyalakshmi Gandu)]

@Rambabu_N

Use Find First or Last Data Row and store the result in a variable Last_row
Use Assign:
lastColumnAddress=new string(Convert.ToChar(65 + YourColumnIndexInNumber), 1) +Last_row.ToString

[rlgandu (Rajyalakshmi Gandu)]

@Rambabu_N

If you get the answer mark as solution to close the loop