Get Cell's Row number using EPPlus

c# vb.net epplus
John Bustos picture John Bustos · Dec 21, 2012 · Viewed 10.2k times · Source

How can I find the row numer of a specific cell using the EPPLus library?

I'm looking for a method along the lines of Cl.Row, but am not seeming to find it - Do I have to use the cl.Address and parse the row number out myself??

I'm sure this is a stupid Newbie question, but I can't seem to find the correct method.

Thanks!

Answer

Tim Schmelter picture Tim Schmelter · Dec 21, 2012

The cell is an ExcelRange, this has Start and End properties. If you want to know the row of the start of the range:

Dim row As Int32 = cell.Start.Row

Related questions

Auto column width in EPPlus

How to make columns to be auto width when texts in columns are long? I use this code Worksheet.Column(colIndex).AutoFitColumn() 'on all columns' Worksheet.cells.AutoFitColumns() Worksheet.Column(colIndex).BestFit = True 'on all columns' None of these methods …

Read More
How to get the column index of the current cell?

I have this code here... For Each cell In worksheet.Cells(8, 2, lastRow, lastCol) Select Case "What Goes Here" End Select Next I want to verify the column that the current cell is in. I can use... cell.Address but that …

Read More
What is a NullReferenceException, and how do I fix it?

I have some code and when it executes, it throws a NullReferenceException, saying: Object reference not set to an instance of an object. What does this mean, and what can I do to fix this error?

Read More