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

Find Max Date in workbook

Thread ID:





107960 Mar 26,2013 10:00 AM UTC Apr 4,2013 07:41 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Adrian Hedley
Asked On March 26, 2013 10:00 AM UTC

I have a workbook with various dates (dd/mm/yyyy) in Column A. I would like to get the Max date.
something like :
IRange maxdate = worksheet.FindFirst(date ==> maxdate)

I do not have a column name for Dates.


Manikandan M [Syncfusion]
Replied On April 4, 2013 07:41 AM UTC

Hi Adrian,

Thanks for using Syncfusion products.

Currently we don't provide the support for finding the max date value in XlsIO. Whereas we could get the max date using Excel function 'MAX'. We have attached the simplified sample to get the max date in the below. Please make use of this and let us know if this helps you.

We have provided the code snippet for the same below.

Code snippet:
            IRange maxDate = sheet["B1"];
            maxDate.NumberFormat = "MM/dd/yyyy";
            maxDate.Formula = "MAX(" + sheet.Columns[0].AddressLocal + ")";

If you need any assistance, please create the new incident with your query.

Manikandan M.



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