Excel 檔案上 Add 或 Delete SpreadSheet
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; Object misValue = System.Reflection.Missing.Value; xlWorkBook.Worksheets.Add(misValue, misValue, misValue, misValue); MessageBox.Show("Sheet Add"); ((Excel.Worksheet)(xlApp.ActiveWorkbook.Sheets[1])).Delete(); MessageBox.Show("Sheet Delete"); 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(); } } |