C中数据导出到Excel表格(8)

DataGridView 数据导出到Excel

21. // Confirms that an HtmlForm control is rendered for

22. }

五、DataTable导出到Excel 1. using System;

2. using Microsoft.Office.Interop.Excel;

3. using System.Windows.Forms;

4. namespace DongVI

5. {

6. /// <summary>

7. /// DataTable导出到Excel

8. /// 整理:dongVi

9. /// </summary>

10. public class DataTableToExcel

11. {

12. private DataTableToExcel()

13. {

14.

15. }

16. /// <summary>

17. /// 导出Excel

18. /// </summary>

19. /// <param name="dt">要导出的DataTable</param>

20. public static void ExportToExcel(System.Data.DataTable dt )

21. {

22. if (dt == null) return;

23.

24. Microsoft.Office.Interop.Excel.Application xlApp = new

Microsoft.Office.Interop.Excel.Application();

25. if (xlApp == null)

26. {

27. // lblMsg.Text = "无法创建Excel对象，可能您的电脑未安装Excel";

28. MessageBox.Show( "无法创建Excel对象，可能您的电脑未安装Excel" );

29. return;

30. }