We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Finding Last Data Row of a particular column

Thread ID:





127466 Nov 17,2016 07:21 AM UTC Nov 18,2016 12:39 PM UTC ASP.NET MVC 1
Tags: XlsIO
Sourjya Sankar Sen
Asked On November 17, 2016 07:21 AM UTC

   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?


Abirami Varadharajan [Syncfusion]
Replied On November 18, 2016 12:39 PM UTC

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. 
Kindly check and let us know if this sample fulfills your requirement. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon