C#datagridview导出数据到excel

 

1. 添加dll引用
2. 右击选择你所在的项目的“引用”，选择“添加引用”。
3. 弹出“添加引用”对话框。
4. 选择“COM”选项卡。
5. 选择“Microsoft Excel 11.0 Object Library”
6. 单击“确定”按钮。
7. 代码
8. public static bool ExportForDataGridview(DataGridView gridView, string fileName, bool isShowExcle)
9.         {
10.             //建立Ｅｘｃｅｌ对象
11.             Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
12.             try
13.             {
14.                 if (app == null)
15.                 {
16.                     return false;
17.                 }
18.                 
19.                 app.Visible = isShowExcle;
20.                 Workbooks workbooks = app.Workbooks;
21.                 _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
22.                 Sheets sheets = workbook.Worksheets;
23.                 _Worksheet worksheet = (_Worksheet)sheets.get_Item(1);
24.                 if (worksheet == null)
25.                 {
26.                     return false;
27.                 }
28.                 string sLen = "";
29.                 //取得最后一列列名
30.                 char H = (char)(64 + gridView.ColumnCount / 26);
31.                 char L = (char)(64 + gridView.ColumnCount % 26);
32.                 if (gridView.ColumnCount < 26)
33.                 {
34.                     sLen = L.ToString();
35.                 }
36.                 else
37.                 {
38.                     sLen = H.ToString() + L.ToString();
39.                 }
41.                 //标题
42.                 string sTmp = sLen + "1";
43.                 Range ranCaption = worksheet.get_Range(sTmp, "A1");
44.                 string[] asCaption = new string[gridView.ColumnCount];
45.                 for (int i = 0; i < gridView.ColumnCount; i++)
46.                 {
47.                     asCaption[i] = gridView.Columns[i].HeaderText;
48.                 }
49.                 ranCaption.Value2 = asCaption;
50.                 //数据
51.                 object[] obj = new object[gridView.Columns.Count];
52.                 for (int r = 0; r < gridView.RowCount - 1; r++)
53.                 {
54.                     for (int l = 0; l < gridView.Columns.Count; l++)
55.                     {
56.                         if (gridView[l, r].ValueType == typeof(DateTime))
57.                         {
58.                             obj[l] = gridView[l, r].Value.ToString();
59.                         }
60.                         else
61.                         {
62.                             obj[l] = gridView[l, r].Value;
63.                         }
64.                     }
65.                     string cell1 = sLen + ((int)(r + 2)).ToString();
66.                     string cell2 = "A" + ((int)(r + 2)).ToString();
67.                     Range ran = worksheet.get_Range(cell1, cell2);
68.                     ran.Value2 = obj;
69.                 }
70.                 //保存
71.                 workbook.SaveCopyAs(fileName);
72.                 workbook.Saved = true;
73.             }
74.             finally
75.             {
76.                 //关闭
77.                 app.UserControl = false;
78.                 app.Quit();
79.             }
80.             return true;
81.         }
83. 方法2
84. 用流保存成xls文件. 这种方法比较好,不用引用Excel组件.   下面是具体例子,可以参考
85. using System.IO;
86.         
87.         /// <summary>
88.         /// 另存新档按钮
89.         /// </summary>
90.         private void SaveAs() //另存新档按钮   导出成Excel
91.         {
92.             SaveFileDialog saveFileDialog = new SaveFileDialog();
93.             saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
94.             saveFileDialog.FilterIndex = 0;
95.             saveFileDialog.RestoreDirectory = true;
96.             saveFileDialog.CreatePrompt = true;
97.             saveFileDialog.Title = "Export Excel File To"; 
98.             saveFileDialog.ShowDialog();
99.             Stream myStream;
100.             myStream = saveFileDialog.OpenFile();
101.             //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
102.             StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
103.             string str = "";
104.             try
105.             {
106.                 //写标题
107.                 for (int i = 0; i < dgvAgeWeekSex.ColumnCount; i++)
108.                 {
109.                     if (i > 0)
110.                     {
111.                         str += "/t";
112.                     }
113.                     str += dgvAgeWeekSex.Columns[i].HeaderText;
114.                 }
115.                 sw.WriteLine(str);
116.                 //写内容
117.                 for (int j = 0; j < dgvAgeWeekSex.Rows.Count; j++)
118.                 {
119.                     string tempStr = "";
120.                     for (int k = 0; k < dgvAgeWeekSex.Columns.Count; k++)
121.                     {
122.                         if (k > 0)
123.                         {
124.                             tempStr += "/t";
125.                         }
126.                         tempStr += dgvAgeWeekSex.Rows[j].Cells[k].Value.ToString();
127.                     }
128.                     
129.                     sw.WriteLine(tempStr);                    
130.                 }
131.                 sw.Close();
132.                 myStream.Close();
133.             }
134.             catch (Exception e)
135.             {
136.                 MessageBox.Show(e.ToString());
137.             }
138.             finally
139.             {
140.                 sw.Close();
141.                 myStream.Close();
142.             }           
143.       }
146. 第一总方法
147. 补充一下
148. 需要添加dll引用
150. 右击选择你所在的项目的“引用”，选择“添加引用”。
152. 弹出“添加引用”对话框。
154. 选择“COM”选项卡。
156. 选择“Microsoft Excel 11.0 Object Library”
158. 单击“确定”按钮。
160. 还有一个Microsoft Office Object的组件，要一并引入才可以，这个是基类
162. 需用根据你引用Excel，可以用下句引用Office2003/2007均可 
163. 还需要using一下
164. using Excel = Microsoft.Office.Interop.Excel;
166. 因为Excel版本不同，所以打出来的dll的namespace也不同
167. 运行通过