C# DataGridView导出Excel
作者:网络转载 发布时间:[ 2013/12/27 15:28:45 ] 推荐标签:C# 开发
2种方法参考:
第一种:用流保存成xls文件. 这种方法比较好, 可以参考
1
2using System.IO;
3
4
5
6 /// <summary>
7
8 /// 另存新档按钮
9
10 /// </summary>
11
12 private void SaveAs() //另存新档按钮 导出成Excel
13
14 {
15
16 SaveFileDialog saveFileDialog = new SaveFileDialog();
17
18 saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
19
20 saveFileDialog.FilterIndex = 0;
21
22 saveFileDialog.RestoreDirectory = true;
23
24 saveFileDialog.CreatePrompt = true;
25
26 saveFileDialog.Title = "Export Excel File To";
27
28
29 saveFileDialog.ShowDialog();
30
31
32 Stream myStream;
33
34 myStream = saveFileDialog.OpenFile();
35
36 //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
37
38 StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
39
40 string str = "";
41
42 try
43
44 {
45
46 //写标题
47
48 for (int i = 0; i < dgvAgeWeekSex.ColumnCount; i++)
49
50 {
51
52 if (i > 0)
53
54 {
55
56 str += " ";
57
58 }
59
60 str += dgvAgeWeekSex.Columns[i].HeaderText;
61
62 }
63
64
65 sw.WriteLine(str);
66
67
68
69 //写内容
70
71 for (int j = 0; j < dgvAgeWeekSex.Rows.Count; j++)
72
73 {
74
75 string tempStr = "";
76
77 for (int k = 0; k < dgvAgeWeekSex.Columns.Count; k++)
78
79 {
80
81 if (k > 0)
82
83 {
84
85 tempStr += " ";
86
87 }
88
89 tempStr += dgvAgeWeekSex.Rows[j].Cells[k].Value.ToString();
90
91 }
92
93
94
95 sw.WriteLine(tempStr);
96
97 }
98
99 sw.Close();
100
101 myStream.Close();
102
103 }
104
105 catch (Exception e)
106
107 {
108
109 MessageBox.Show(e.ToString());
110
111 }
112
113 finally
114
115 {
116
117 sw.Close();
118
119 myStream.Close();
120
121 }
122
123 }
相关推荐
更新发布
功能测试和接口测试的区别
2023/3/23 14:23:39如何写好测试用例文档
2023/3/22 16:17:39常用的选择回归测试的方式有哪些?
2022/6/14 16:14:27测试流程中需要重点把关几个过程?
2021/10/18 15:37:44性能测试的七种方法
2021/9/17 15:19:29全链路压测优化思路
2021/9/14 15:42:25性能测试流程浅谈
2021/5/28 17:25:47常见的APP性能测试指标
2021/5/8 17:01:11