C#用流实现DataGridView中数据Excel格式的导出,会将前面数据的0去掉,或自动变成科学计数形式

Question

自己搞定
public static void WriteExcel()
        {
            if (gridView.Rows.Count == 0)
            {
                MessageBox.Show("没有数据可供导出！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            else
            {
                saveFileDialog2.Filter = "Execl files (*.xls)|*.xls";
                saveFileDialog2.FilterIndex = 0;
                saveFileDialog2.RestoreDirectory = true;
                //saveFileDialog2.CreatePrompt = true;
                saveFileDialog2.Title = "导出文件保存路径";
                saveFileDialog2.FileName = null;
                saveFileDialog2.ShowDialog();
                string FileName = saveFileDialog2.FileName;                if (FileName.Length != 0)
                {
                    toolStripProgressBar1.Visible = true;                                        
                    toolStripProgressBar1.Value = 0;
                    try
                    {
                        StreamWriter sw = new StreamWriter(FileName, false, Encoding.GetEncoding("gb2312"));
                        StringBuilder sb = new StringBuilder();                        System.Data.DataTable dt = objSet.Tables[0];                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            sb.Append(@"=""" + dt.Columns[k].ColumnName.ToString() + @"""" + "\t");
                        }
                        sb.Append(Environment.NewLine);                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                sb.Append(@"=""" + dt.Rows[i][j].ToString() + @"""" + "\t");
                            }
                            sb.Append(Environment.NewLine);//每写一行数据后换行
                            toolStripProgressBar1.Value += 100 / dt.Rows.Count;
                        }
                        sw.Write(sb.ToString());
                        sw.Flush();
                        sw.Close();//释放资源
                        MessageBox.Show("数据已经成功导出到：" + saveFileDialog2.FileName.ToString(), "导出完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        toolStripProgressBar1.Value = 0;
                        toolStripProgressBar1.Visible = false;
                    }                  
                }
            }            
        }

Answer 1

问题是解决了，但是导出来的数据上都有="data"，我对Excel不熟，不知道对后续Excel其他操作有没有影响！