建立 及 開啟 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); } } } |