예제 #1
0
        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);
        }
예제 #2
0
 public static double GetDouble(this ExcelWorksheet worksheet, int row, CoinkeeperColumn column)
 {
     double.TryParse(worksheet.GetString(row, column), out var result);
     return(result);
 }
예제 #3
0
 public static string GetString(this ExcelWorksheet worksheet, int row, CoinkeeperColumn column)
 {
     return(worksheet.Cells[row, (int)column].Value?.ToString() ?? string.Empty);
 }