public static List <ExcelSheetModel> LoadExcelExt(Excel.Workbook xbook) { try { int defaultColumn = 21; var list = new List <ExcelSheetModel>(); //Excel.Application xlap = new Excel.Application(); //Excel.Workbook xbook = xlap.Workbooks.Open(pathFile); for (int i = 0; i < xbook.Worksheets.Count; i++) { Excel.Worksheet xsheet = xbook.Sheets[i + 1]; string columnName = xsheet.Cells[2, defaultColumn].Value; var dto = new ExcelSheetModel() { SheetName = xsheet.Name, ColumnIndex = defaultColumn, ColumnName = columnName, }; list.Add(dto); } return(list); } catch (Exception ex) { throw ex; } }
public static List <ExcelSheetModel> LoadExcel(string pathFile) { try { int defaultColumn = 21; var list = new List <ExcelSheetModel>(); Excel.Application xlap = new Excel.Application(); Excel.Workbook xbook = xlap.Workbooks.Open(pathFile); for (int i = 0; i < xbook.Worksheets.Count; i++) { Excel.Worksheet xsheet = xbook.Sheets[i + 1]; //int columnCount = xsheet.UsedRange.Columns.Count; string columnName = xsheet.Cells[2, defaultColumn].Value; var dto = new ExcelSheetModel() { SheetName = xsheet.Name, ColumnIndex = defaultColumn, ColumnName = columnName, }; list.Add(dto); } xbook.Close(true, null, null); xlap.Quit(); Marshal.ReleaseComObject(xbook); Marshal.ReleaseComObject(xlap); return(list); } catch (Exception ex) { throw ex; } }