public object GetCellValue(Worksheet sheet, SheetDataColumn column, string cellName)
{
var cell = sheet.Cells[cellName];
if (cell.Value == null)
{
return DBNull.Value;
}
else
{
switch (column.DataType)
{
case DataType.DateTime:
DateTime dateTimeValue;
if (DateTime.TryParse(cell.Value.ToString(), out dateTimeValue))
return dateTimeValue;
else
return DBNull.Value;
case DataType.Integer:
Int32 intValue;
if (Int32.TryParse(cell.Value.ToString(), out intValue))
return intValue;
else
return DBNull.Value;
case DataType.Double:
Double doubleValue;
if (Double.TryParse(cell.Value.ToString(), out doubleValue))
return doubleValue;
else
return DBNull.Value;
case DataType.String:
default:
return (string)cell.Value;
}
}
}
public object GetCellValue(string sheetName, SheetDataColumn column, string cellName)
{
Worksheet sheet = workbook.Worksheets[sheetName];
return GetCellValue(sheetName, column, cellName);
}
