打開 Excel Document

 
打開 Excel Document
 

   Form1.cs
 
   using Excel = Microsoft.Office.Interop.Excel;
 
   private void Load_Excel()
   {
 
      Excel.Application xlApp;
      Excel.Workbook xlWorkBook;
      Excel.Worksheet xlWorkSheet;
 
      String thisFileName = "C:\\1.xls";
 
      xlApp = new Excel.ApplicationClass();
 
      xlWorkBook = xlApp.Workbooks.Open(thisFileName,
      0, false, 5, "", "", false,
      Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, 2,
      false, Type.Missing, 0, false, 1, 0);
 
      xlWorkSheet = (Excel.Worksheet)(xlWorkBook.Worksheets.get_Item(1));
      xlWorkSheet.Activate();
 
      xlApp.Visible = true;
 
      releaseObject(xlWorkSheet);
      releaseObject(xlWorkBook);
      releaseObject(xlApp);
 
   }
 
   private void releaseObject(object obj)
   {
      try
      {
         System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
         obj = null;
      }
      catch (Exception ex)
      {
         obj = null;
         MessageBox.Show("Unable to release the Object " + ex.ToString());
      }
      finally
      {
         GC.Collect();
      }
   }