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;
}
}
