Get Cell Address of non empty cell in column in Excel

[Pramod_Bharat_Mangale]

Hello Friends,

Is there any way where we can get Cell address of last cell in last column.

Thanks in Advance.

[supermanPunch (Arpan)]

@Pramod_Bharat_Mangale

Cell address

Hi @Pramod_Bharat_Mangale ,

Could you Specify what is the Cell Address that you are specifying ?

The Cell Name in Excel ? Like A1, B4 … ?

@Pramod_Bharat_Mangale ,

You Could Try Checking the Below Post :

Delete Excel data range without Excel Installed

@kasey.betts , Assuming that we have the Data already available in Datatable, which Represents the Data in the Excel, we can use it’s Column Count and Row Count information to Clear the Contents using Write Cell Activity. For Example : Let the Datatable be DT We get the Column Letter of the Excel by using the Column Count information as follows : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1) The above would help us get the Col…

It’s not the Exact case, but we can derive your Solution From the Steps and Expression mentioned.

[ashwin.ashok ((TheCodingTheory))]

Hi @Pramod_Bharat_Mangale ,

Could you give this a try?

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(Dt.ColumnCount)+"1"

But if you meant to say the cell in the botton right corner, then you could give this a try →

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(Dt.ColumnCount)+(dt.Rows.Count-1).ToString

Kind Regards,
Ashwin A.K

[Pramod_Bharat_Mangale]

If we go with dt.Rows.Count-1, then we are getting last cell as E6 which is not actual last cell, it is E8 in my sheet. So instead of -1 when I tried +1, so code will be :

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(Dt.ColumnCount)+(dt.Rows.Count+1).ToString

I am getting desired Output that is E8.

Thank you

[ashwin.ashok ((TheCodingTheory))]

Hi @Pramod_Bharat_Mangale ,

Ah yes, my mistake.
I forgot to factor in the fact that the header is not considered, so yes we have to add one.

Kind Regards,
Ashwin A.K