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.
Unfortunately, activation email could not send to your email. Please try again.

Find Max Date in workbook

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi,
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.

Thanks

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

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.

Thanks,
Manikandan M.





MaxDate_6e905507.zip

CONFIRMATION

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.

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.

;