用C#将数据写入到Excel指定的单元格中

1. 在使用用本文的方法前，需要先安装Office 的Excel程序，然后，引用 Excel 的对象包装：

1. using Microsoft.Office.Interop.Excel;

 

不同的Office版本可能引用的名称不同。

使用下面的代码，完成数据写入操作：

1.  private void writeData(string excelFileName,DataSet dsResult,)
2.         {
3.             _Application xlApp = null;
4.             _Workbook xlWorkbook = null;
5.             _Worksheet xlWorksheet = null;
6.             
7.             
8.             System.Reflection.Missing missing = System.Reflection.Missing.Value;
9.             string saveAsPath = "";
11.             try
12.             {
13.                 xlApp = new ApplicationClass();
14.                 xlApp.Visible =true ;
15.                 xlWorkbook=xlApp.Workbooks.Open(excelFileName, missing, missing, missing, missing, missing, missing, missing, 
16.                     missing, missing, missing, missing, missing, missing, missing);
18.                 xlWorksheet = xlWorkbook.Worksheets[1] as _Worksheet;
19.                 //xlWorksheet.Name = "NewWorksheet";
20.                 //xlWorksheet.Cells[1, "A"] = "Topic: ";
21.                 //xlWorksheet.Cells[1, "B"] = ".Net Interop Excel Demo";
23.                 for (int x = 4; x < 92; x++)
24.                 {
25.                     object rang = xlWorksheet.Cells[x, "D"];
26.                     if (rang != null)
27.                     {
28.                         object objText = ((Range)rang).Value2;
29.                         string strCellText = objText==null?"":objText.ToString();
30.                         if (strCellText == "")
31.                         {
32.                             rang = xlWorksheet.Cells[x, "C"];
33.                             strCellText = "";
34.                             if (rang != null)
35.                             {
36.                                 objText = ((Range)rang).Value2;
37.                                 strCellText = objText == null ? "" : objText.ToString();
38.                             }
39.                             
40.                         }
41.                         //xlWorksheet.Cells[x, "E"] = strCellText;
42.                         DataRow[] rows = dsResult.Tables[0].Select("Name='" + strCellText + "'");
43.                        if (rows.Length > 0)
44.                        {
45.                            //防止有空值
46.                            if(rows[0]["Count"]!=DBNull.Value )
47.                             xlWorksheet.Cells[x, "H"] = rows[0]["Count"].ToString();
49.                                                  }
50.                     }
51.                     
53.                 }
54.                 
55.                 
56.                 
57.                 
58.                 xlWorkbook.Save();
60.                 //saveAsPath = System.Windows.Forms.Application.StartupPath + "//" + xlWorkbook.Name;
61.                 //xlWorkbook.SaveAs(saveAsPath, missing, missing, missing, missing,
62.                 //    missing, XlSaveAsAccessMode.xlShared, missing, missing, missing,
63.                 //    missing, missing);
64.                 //xlApp.Quit();
65.             }
66.             catch (Exception ex)
67.             {
68.                 MessageBox.Show(ex.Message);
69.             }
70.             finally
71.             {
72.                 //System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
73.                 //xlApp = null;
74.                 //GC.Collect();
75.             }
76.         }

本例没有直接关闭文件，如果你要另存为一个文件，把注释取消即可。

注意获取单元格的方法：

 

 

1.  rang = xlWorksheet.Cells[x, "C"];
2.                             strCellText = "";
3.                             if (rang != null)
4.                             {
5.                                 objText = ((Range)rang).Value2;
6.                                 strCellText = objText == null ? "" : objText.ToString();
7.                             }