public static void ReadDates() { using (var workbook = new XLWorkbook(@"C:\Users\RAMAND\Desktop\c#_trainingTracker\trainingX.xlsx")) { var worksheet = WorksheetChecker.GetOrCreateWorksheet(workbook, "New"); var lastRowUsed = worksheet.LastRowUsed() != null?worksheet.LastRowUsed().RowNumber() : 1; for (int i = 1; i <= lastRowUsed; i++) { if (worksheet.Cell(i, 1).Value.GetType() == typeof(DateTime)) { Console.WriteLine(worksheet.Cell(i, 1).Value); } } } }
public static void ReadToConsole() { var workbookHandler = new _WorkbookHandler(@"C:\Users\RAMAND\Desktop\c#_trainingTracker", "NewClient"); using (var workbook = workbookHandler.getWorkbook()) { var worksheet = WorksheetChecker.GetOrCreateWorksheet(workbook, "New"); var lastRowUsed = worksheet.LastRowUsed() != null?worksheet.LastRowUsed().RowNumber() : 1; for (int i = 1; i <= lastRowUsed; i++) { Console.WriteLine(); ReadRowToConsole(worksheet, i); } } }