Check if excel has particular value, excel has no columnName in it

[shilpashree.mohanty]

still it returns false

[shilpashree.mohanty]

@ashokkarale

DateTime.Now.AddDays(-1).Date

My question

I have a sheet, it may or may not have data
if it has data → [MM-dd-yyyy] format

now i need to compare if this [MM-dd-yyyy] is already present in that sheet

[ashokkarale]

Let’s try this once as this should handle empty or null cells as well.

dt_Schedule.AsEnumerable().Any(Function(r) Not IsDBNull(r(0)) AndAlso Not String.IsNullOrWhiteSpace(r(0).ToString()) AndAlso DateTime.ParseExact(r(0).ToString(), "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture).Date = DateTime.Now.AddDays(-1).Date)

[shilpashree.mohanty]

@ashokkarale

dt_Schedule.AsEnumerable().Any(Function(r) Not IsDBNull(r(0)) AndAlso Not String.IsNullOrWhiteSpace(r(0).ToString()) AndAlso DateTime.ParseExact(r(0).ToString(), “MM-dd-yyyy”, System.Globalization.CultureInfo.InvariantCulture).Date = DateTime.Now.AddDays(-1).Date)

still throwing false