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); }