当前位置：首页 > news >正文

在窗体中把DataGridView中的数据导出Excel

news 来源：原创 2024/4/29 5:16:09

 1  //DataGridView导出Excel
 2         private void bt_Excl_Click(object sender, EventArgs e)
 3         {
 4             SaveFileDialog saveFileDialog = new SaveFileDialog();
 5 
 6             saveFileDialog.Filter = "Microsoft Excel 工作表 (.xls)|*.xls";
 7             saveFileDialog.FilterIndex = 0;
 8             saveFileDialog.RestoreDirectory = true;
 9             saveFileDialog.CreatePrompt = true;
10             saveFileDialog.Title = "导出Excel文件到";
11             DateTime now = DateTime.Now;
12             saveFileDialog.FileName = now.Year.ToString().PadLeft(2) + now.Month.ToString().PadLeft(2, '0') + now.Day.ToString().PadLeft(2, '0') + "-" + now.Hour.ToString().PadLeft(2, '0') + now.Minute.ToString().PadLeft(2, '0') + now.Second.ToString().PadLeft(2, '0');
13             saveFileDialog.ShowDialog();
14             Stream myStream;
15             myStream = saveFileDialog.OpenFile();
16             StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
17             string str = "";
18             try
19             {
20                 //写标题
21                 for (int i = 0; i < dataTitl.ColumnCount; i++)
22                 {
23                     if (i > 0)
24                     {
25                         str += "\t";
26                     }
27                     str += dataTitl.Columns[i].HeaderText;
28                 }
29                 sw.WriteLine(str);
30                 //写内容
31                 for (int j = 0; j < dataTitl.Rows.Count; j++)
32                 {
33                     string tempStr = "";
34                     for (int k = 0; k < dataTitl.Columns.Count; k++)
35                     {
36                         if (k > 0)
37                         {
38                             tempStr += "\t";
39                         }
40                         tempStr += dataTitl.Rows[j].Cells[k].Value.ToString();
41                     }
42                     sw.WriteLine(tempStr);
43                 }
44                 sw.Close();
45                 myStream.Close();
46             }
47             catch (Exception)
48             {
49                 MessageBox.Show("题目导出完成。", "导出", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
50             }
51             finally
52             {
53                 sw.Close();
54                 myStream.Close();
55             }
56         }