Finding Last Data Row of a particular column

Question

Hi,

I've found plenty of example on how to use xlsIO to find the used range of a worksheet. However, my worksheet contains uneven columns and I want to be able to find the last data row when I provide a column name / index. Example: I want to find the last row containing data for column C.

How do I go about doing that?

Thanks,

Sourjya

Abirami Varadharajan · Answer

Hi Sourjya, 
 
Thank you for contacting Syncfusion support. 
 
We have prepared a sample to get the last row of a column which can be downloaded from following location. 
 
Sample Link:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1918800089.zip  
 
Kindly check and let us know if this sample fulfills your requirement. 
 
Regards, 
Abirami.