public static WorkScheduleConfig LoadWorkScheduleConfig(string fullPathToExcelFile) { DataTable dtOfWorkScheduleForUnit = new DataTable(); try { OleDbExcelDataProvider oleXlsProvider = new OleDbExcelDataProvider(fullPathToExcelFile, null); dtOfWorkScheduleForUnit = oleXlsProvider.ReadSheet(Properties.Settings.Default.SHEET_NAME_WORK_SCHEDULE_MAIN); } catch (InvalidOperationException exception) { try { ApplicationExcelDataProvider appXlsProvider = new ApplicationExcelDataProvider(fullPathToExcelFile, null); dtOfWorkScheduleForUnit = appXlsProvider.ReadSheet(Properties.Settings.Default.SHEET_NAME_WORK_SCHEDULE_MAIN); } catch (Exception exceptionFromExcel) { throw exceptionFromExcel; } } catch { throw; } return(null); }
private static DataTable GetSheetFromXls(string fullPathToExcelFile, string sheetName) { DataTable dtOfWorkScheduleForUnit = new DataTable(); try { OleDbExcelDataProvider oleXlsProvider = new OleDbExcelDataProvider(fullPathToExcelFile, null); dtOfWorkScheduleForUnit = oleXlsProvider.ReadSheet(sheetName); } catch (InvalidOperationException exception) { try { ApplicationExcelDataProvider appXlsProvider = new ApplicationExcelDataProvider(fullPathToExcelFile, null); dtOfWorkScheduleForUnit = appXlsProvider.ReadSheet(sheetName); } catch (Exception exceptionFromExcel) { throw exceptionFromExcel; } } catch { throw; } return(dtOfWorkScheduleForUnit); }