public string ExtractDateString(int rowIndex, int columnIndex) { var xf = 0; var v = _xls.GetCellValue(rowIndex, columnIndex, ref xf); var exception = new FlexCelExtractionException(_xls.ActiveSheet, rowIndex, columnIndex) { FileSpec = _xls.ActiveFileName }; if (v == null) { throw exception; } var vType = v.GetType(); var vTypeCode = Type.GetTypeCode(vType); exception.Type = vType; if (vTypeCode != TypeCode.Double) { throw exception; } DateTime date; if (FlxDateTime.TryFromOADate((double) v, false, out date)) { return date.ToString("M/d/yyyy"); } exception.Type = date.GetType(); throw exception; }
public double ExtractDouble(int sheetIndex, int rowIndex, int columnIndex) { var xf = 0; var val = CheckDouble(_xls.GetCellValue(sheetIndex, rowIndex, columnIndex, ref xf)); if (val != null) return val.Value; var exception = new FlexCelExtractionException(sheetIndex, rowIndex, columnIndex) { FileSpec = _sourcePath, Type = typeof (double) }; throw exception; }