Find Max Date in workbook

[Adrian Hedley]

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]

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