Object GetCellValue(String text, CellFormat format)
{
if (format == null)
{
return(text);
}
var formatId = format.NumberFormatId;
var strFormat = ExcelFormats.GetDateTimeFormat(formatId);
if (!String.IsNullOrEmpty(strFormat))
{
if (Double.TryParse(text, NumberStyles.Any, CultureInfo.InvariantCulture, out Double dblDate))
{
return(DateTime.FromOADate(dblDate));
}
}
else if (ExcelFormats.IsNumberFormat(formatId))
{
// hack
if (Double.TryParse(text, NumberStyles.Any, CultureInfo.InvariantCulture, out Double dblVal))
{
return(dblVal);
}
}
return(text);
}
Object GetCellValue(String text, CellFormat format)
{
if (format == null)
{
return(text);
}
var formatId = format.NumberFormatId;
var strFormat = ExcelFormats.GetDateTimeFormat(formatId);
if (!String.IsNullOrEmpty(strFormat))
{
if (Double.TryParse(text, out Double dblDate))
{
return(DateTime.FromOADate(dblDate));
}
}
return(text);
}