public static DateTime GetDate(this ExcelWorksheet worksheet, int row, CoinkeeperColumn column) { var str = worksheet.GetString(row, column).Trim().Split(" ")[0]; if (str.StartsWith("0")) { str = str.Substring(1); } DateTime.TryParse(str, Provider, DateTimeStyle, out var result); return(result); }
public static double GetDouble(this ExcelWorksheet worksheet, int row, CoinkeeperColumn column) { double.TryParse(worksheet.GetString(row, column), out var result); return(result); }
public static string GetString(this ExcelWorksheet worksheet, int row, CoinkeeperColumn column) { return(worksheet.Cells[row, (int)column].Value?.ToString() ?? string.Empty); }