/// <summary> /// Read the contents of the Settings worksheet in the specified Excel file into a DataTable. /// Excel files up to Excel 2000 and SpreadsheetML XML 2000 files are both supported. /// </summary> /// <param name="inputFile">Path to the XLS or XML file</param> /// <returns></returns> internal static DataTable ReadSettingsFromExcelFile(string inputFiles) { DataTable datatable = null; string[] inputlist = inputFiles.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); foreach (string inputFile in inputlist) { if (!File.Exists(inputFile)) { throw new FileNotFoundException("The specified input file " + inputFile + " does not exist.", inputFile); } DataTable dt = null; string fileExtension = Path.GetExtension(inputFile); if (string.Compare(fileExtension, ".xls", true) == 0 || string.Compare(fileExtension, ".xlsx", true) == 0) { dt = ExcelBinarySettingsFileReader.ReadSettingsFromXls(inputFile); } else { dt = SpreadsheetMlSettingsFileReader.ReadSettingsFromSpreadsheetMl(inputFile); } if (datatable == null) { datatable = dt; } else { if (dt != null) { //remove fist 5 rows for (int i = 0; i < dt.Rows.Count; i++) { if (i > HeaderRowsCount) { datatable.ImportRow(dt.Rows[i]); } } } } } return(datatable); }
/// <summary> /// Read the contents of the Settings worksheet in the specified Excel file into a DataTable. /// Excel files up to Excel 2000 and SpreadsheetML XML 2000 files are both supported. /// </summary> /// <param name="inputFile">Path to the XLS or XML file</param> /// <returns></returns> internal static DataTable ReadSettingsFromExcelFile(string inputFile) { if (!File.Exists(inputFile)) { throw new FileNotFoundException("The specified input file " + inputFile + " does not exist.", inputFile); } DataTable dt = null; string fileExtension = Path.GetExtension(inputFile); if (string.Compare(fileExtension, ".xls", true) == 0 || string.Compare(fileExtension, ".xlsx", true) == 0) { dt = ExcelBinarySettingsFileReader.ReadSettingsFromXls(inputFile); } else { dt = SpreadsheetMlSettingsFileReader.ReadSettingsFromSpreadsheetMl(inputFile); } return(dt); }