将dataGridView内容导出到Excel文件

这里提供了两种将DataGridView内容导出到Excel文件的方法。

方法1：

1. /// <summary>
2. /// 在没有安装Excel的情况下，将DataGridView数据导出到Excel
3. /// </summary>
4. private void ExportToExcel()
5. {
6. SaveFileDialog saveFileDialog = new SaveFileDialog();
7. saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
8. saveFileDialog.FilterIndex = 0;
9. saveFileDialog.RestoreDirectory = true;
10. saveFileDialog.CreatePrompt = true;
11. saveFileDialog.Title = "导出到Excel";
12. saveFileDialog.ShowDialog();
13. if (saveFileDialog.FileName == "")
14. {
15. return;
16. }
17. Stream myStream = saveFileDialog.OpenFile();
18. StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
19. string str = "";
20. try
21. {
22. for (int i = 0; i < dataGridView1.ColumnCount; i++)
23. {
24. if (dataGridView1.Columns[i].Visible == false || dataGridView1.Columns[i].DataPropertyName == "")
25. {
26. continue;
27. }
28. str += dataGridView1.Columns[i].HeaderText;
29. str += "\t";
30. }
31. sw.WriteLine(str);
32. for (int j = 0; j < dataGridView1.Rows.Count - 1; j++)
33. {
34. string strTemp = "";
35. for (int k = 0; k < dataGridView1.Columns.Count; k++)
36. {
37. if (dataGridView1.Columns[k].Visible == false || dataGridView1.Columns[k].DataPropertyName == "")
38. {
39. continue;
40. }
41. object obj = dataGridView1.Rows[j].Cells[k].Value;
42. if (obj != null)
43. {
44. strTemp += dataGridView1.Rows[j].Cells[k].Value.ToString();
45. }
46. else
47. {
48. strTemp = "";
49. }
50. strTemp += "\t";
51. }
52. sw.WriteLine(strTemp);
53. }
54. sw.Close();
55. myStream.Close();
56. MessageBox.Show("成功导出到Excel文件：\n" + saveFileDialog.FileName);
57. }
58. catch (Exception ex)
59. {
60. MessageBox.Show(ex.ToString());
61. }
62. finally
63. {
64. sw.Close();
65. myStream.Close();
66. }
67. }

方法2：

1. /// <summary>
2. /// 将DataGrirdView数据导出到Excel
3. /// 需要引用Microsoft.Office.Interop.Excel.dll模块
4. /// </summary>
5. /// <param name="dgv"></param>
6. /// <param name="bShowExcel"></param>
7. /// <returns></returns>
8. private bool DataGridviewShowToExcel(DataGridView dgv, bool bShowExcel)
9. {
10. if (dgv.Rows.Count == 0)
11. {
12. return false;
13. }
14. //建立Excel对象
15. Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
16. excel.Application.Workbooks.Add(true);
17. excel.Visible = bShowExcel;
18. //生成字段名称
19. int k = 0;
20. for (int i = 0; i < dgv.ColumnCount; i++)
21. {
22. if (dgv.Columns[i].Visible == false || dataGridView1.Columns[i].DataPropertyName == "")
23. {
24. k++;
25. continue;
26. }
27. excel.Cells[1, i + 1 - k] = dgv.Columns[i].HeaderText;
28. }
29. //填充数据
30. for (int i = 0; i < dgv.RowCount; i++)
31. {
32. k = 0;
33. for (int j = 0; j < dgv.ColumnCount; j++)
34. {
35. if (dgv.Columns[j].Visible == false || dataGridView1.Columns[j].DataPropertyName == "")
36. {
37. k++;
38. continue;
39. }
40. excel.Cells[i + 2, j + 1 - k] = dgv[j, i].Value.ToString();
41. }
42. }
43. return true;
44. }