public ExcelWorkBookInfo ReadExcelFileInfo(string path) { try { Excel.Workbook xlWorkBook = OpenExcelFile(path); Excel.Sheets xlWorkSheets = xlWorkBook.Sheets; ExcelWorkBookInfo result = new ExcelWorkBookInfo(path); foreach (Excel.Worksheet sheet in xlWorkSheets) { ExcelSheet s = GetExcelSheetInfo(sheet); result.Sheets.Add(s); } xlWorkBook.Close(); Release(xlWorkSheets); Release(xlWorkBook); ExitExcelApplication(); return(result); } catch (Exception ex) { try { if (xlApp != null) { ExitExcelApplication(); } } finally { ReleaseUnmanaged(); throw ex; } } }
public ExcelWorkSpaceInfo(ExcelWorkBookInfo workBook, int selectedSheetIndex) { this.WorkBook = workBook; this.SelectedSheetIndex = selectedSheetIndex; }