C# winform使用StreamWriter的方式将dataTable导出到Excel

代码笔记：

  public void Export2Excel()
        {
            if (this.GridView_logData.Rows.Count > 0)
            {
                SaveFileDialog saveFileDialog = new SaveFileDialog();
                saveFileDialog.DefaultExt = "xls";
                saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
                saveFileDialog.FileName = "log的查询结果" + DateTime.Now.ToString("yyyy-MM-dd-hh-mm-ss");
                saveFileDialog.RestoreDirectory = true;
                saveFileDialog.Title = "导出到EXCEL";
                saveFileDialog.ShowDialog();
                if (saveFileDialog.FileName == "")
                {
                    return;
                }
                Stream myStream;
                myStream = saveFileDialog.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
                StringBuilder sb = new StringBuilder();
                try
                {
                    //导出列标头
                    for (int i = 0; i < resultTable.Columns.Count; i++)
                    {

                        if (i > 0)
                        {
                            sb.Append("\t");
                        }
                        sb.Append(resultTable.Columns[i].ColumnName);

                    }
                    //输入Excle数据
                    foreach (DataRow row in resultTable.Rows)
                    {
                        sb.Append("\r\n");
                        for (int i = 0; i < resultTable.Columns.Count; i++)
                        {

                            if (i > 0)
                            {
                                sb.Append("\t");
                            }
                            sb.Append(row[i].ToString().Replace("\r\n", ""));

                        }
                    }
                    sw.Write(sb);
                    sw.Flush();
                    sw.Dispose();
                    MessageBox.Show("导出成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("导出失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }