.Net常用技巧_調用Excel模板格式匯出Excel

標籤：style   blog   http   color   使用   os   

object missing = System.Reflection.Missing.Value;  //表示缺i省object

            SaveFileDialog savedialog = new SaveFileDialog();            savedialog.Filter = "(*.xlsx)|*.xlsx|(*.xls)|*.xls";            savedialog.Title = "導成Excel";            if (savedialog.ShowDialog() == DialogResult.OK)            {                Microsoft.Office.Interop.Excel.ApplicationClass App = new Microsoft.Office.Interop.Excel.ApplicationClass();                //Microsoft.Office.Interop.Excel.Workbook workbook = App.Workbooks._Open("C:/Documents and Settings/Administrator/案頭/WindowsForms/WindowsForms/20130122.xlsx", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);                //“/”是用在系統上，而“\“一般是用在網路上,所以需要使用@符號轉義了                Microsoft.Office.Interop.Excel.Workbook workbook = App.Workbooks._Open(System.Environment.CurrentDirectory+                @"\WindowsForms\WindowsForms\20130122.xlsx", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);                Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];                Microsoft.Office.Interop.Excel.Range range = worksheet.get_Range("A3", "C3");                Object[] objectdata ={ "123", "123", "123" };                range.Value2 = objectdata;                App.DisplayAlerts = false;//禁用該“儲存”對話方塊                workbook.SaveCopyAs(savedialog.FileName);                workbook.Close(missing, missing, missing);                App.DisplayAlerts = true;                App.Quit();                GC.Collect();                MessageBox.Show("匯出成功！", "Excel", MessageBoxButtons.OK);            }