Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get Cell's Row number using EPPlus

Tags:

c#

vb.net

epplus

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!

like image 389
John Bustos Avatar asked Dec 21 '12 16:12

John Bustos


1 Answers

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
like image 144
Tim Schmelter Avatar answered Oct 06 '22 02:10

Tim Schmelter