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