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

DataGridView 数据导出到Excel

17. return "DataTable不能为空";

18. }

19.

20. int rows = dt.Rows.Count;

21.

22. int cols = dt.Columns.Count;

23. StringBuilder sb;

24. string connString;

25.

26. if(rows == 0)

27. {

28. return "没有数据";

29. }

30.

31. sb = new StringBuilder();

32. connString="Provider=Microsoft.Jet.OLEDB.4.0;Data

Source="+ExcelFileName+";Extended Properties=Excel 8.0;";

33.

34. //生成创建表的脚本

35. //----sb.Append("DROP TABLE "+dt.TableName);

36.

37. /*

38. sb.Append("CREATE TABLE ");

39. sb.Append(dt.TableName + " ( ");

40. for(int i=0;i<cols;i++)

41. {

42. if(i < cols - 1)

43. sb.Append(string.Format("{0} varchar,",dt.Columns[i].ColumnName));

44. else

45. sb.Append(string.Format("{0} varchar)",dt.Columns[i].ColumnName));

46. }

47. */

48.

49. //return sb.ToString();

50.