c# 代码创建Excel文件

3. #region 创建Excel
4.     /// <summary>
5.     /// 创建Excel
6.     /// </summary>
7.     /// <param name="fileName">文件名称</param>
8.     /// <param name="sheetName">sheet名称</param>
9.     private void CreateExcel(string fileName,string sheetName)
10.     {
11.         Microsoft.Office.Interop.Excel.ApplicationClass my = new Microsoft.Office.Interop.Excel.ApplicationClass();
13.         my.Visible = true;
14.         object objMissing = System.Reflection.Missing.Value;
18.         //打开工作簿   
19.         Microsoft.Office.Interop.Excel.Workbook mybook = (Microsoft.Office.Interop.Excel.Workbook)my.Workbooks.Add(1);   //   1表示只建一个表   
22.         //mybook.Worksheets.Add(objMissing,objMissing,1,objMissing);//添加sheet   
23.         if (sheetName == "")
24.         {
25.             sheetName = "steet1";
26.         }
27.         else
28.         {
29.             ((Microsoft.Office.Interop.Excel.Worksheet)mybook.Worksheets[1]).Name = sheetName;//将sheet1的名称改为zhu   
30.         } 
31.         Microsoft.Office.Interop.Excel.Worksheet mysheet = (Microsoft.Office.Interop.Excel.Worksheet)mybook.Worksheets[1];
32.         ((Microsoft.Office.Interop.Excel.Range)mysheet.Cells[2, 3]).EntireRow.Insert(0,0);     //添加行   
35.         //保存   
36.         mybook.SaveAs("d://" + fileName + ".xls", objMissing, objMissing, objMissing,   //Excel.XlSaveAsAccessMode.xlShared   
37.         objMissing, objMissing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared,
38.         objMissing, objMissing, objMissing,
39.         objMissing, objMissing);
40.         mybook = null;
41.         my.Quit();
42.         my = null;
43.     }
44.     #endregion