建立 及 開啟 Excel 檔案 (沒有儲存檔案)

 
建立 及 開啟 Excel 檔案 (沒有儲存檔案)
 

   Form1.cs
 
   using Excel = Microsoft.Office.Interop.Excel;
 
   private void Create_Excel()
   {
 
      Excel.Application xlApp;
      Excel.Workbook xlWorkBook;
      Excel.Worksheet xlWorkSheet;
      Object misValue = System.Reflection.Missing.Value;
 
      xlApp = new Excel.ApplicationClass();
      xlWorkBook = xlApp.Workbooks.Add(misValue);
 
      xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
      Generate_SpreedSheet(xlWorkSheet);
 
      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();
      }
 
   }
 
   private void Generate_SpreedSheet(Excel.Worksheet A)
   {
 
      for (int o = 1; o > 0 && o < 11; o++)
      {
         A.Cells[o + 1, 1] = o;
      }
 
      for (int k = 1; k > 0 && k < 11; k++)
      {
         A.Cells[1, k + 1] = k;
      }
 
      for (int i = 1; i > 0 && i < 11; i++)
      {
         for (int j = 1; j > 0 && j < 11; j++)
         {
            A.Cells[i + 1, j + 1] = (i * j);
         }
      }
 
   }