C#（winform） 从datatable中快速导出execl，速度非常快

        /// <summary>
        /// 导出方法
        /// </summary>
        /// <param name="table">需要导出的datatable</param>
        /// <param name="strFilePath">导出后存放地址</param>
        private void upExecl(System.Data.DataTable table, string strFilePath)
        {
            try
            {
                System.IO.StreamWriter sw = new System.IO.StreamWriter(strFilePath, true, System.Text.Encoding.Default); //写入流
                object[] values = new object[table.Columns.Count];
                for (int i = 0; i < table.Columns.Count; ++i)
                {
                    if (table.Columns[i].Caption.ToString() == "列名")
                    {
                        table.Columns[i].Caption = "自己给列起的名字";
                    }
                    sw.Write(table.Columns[i].Caption.ToString());
                    sw.Write('\t');
                }
                sw.Write("\r\n");
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    for (int j = 0; j < values.Length; ++j)
                    {
                        sw.Write(table.Rows[i][j].ToString());
                        sw.Write('\t');
                    }
                    sw.Write("\r\n");
                }
                sw.Flush();
                sw.Close();
                MessageBox.Show("成功导出[" + dataSet1.Tables[0].Rows.Count.ToString() + "]行到Execl！");
                
            }
            catch
            {
                MessageBox.Show("导出Execl失败！");
            }
        }

从数据库中导出Execl源代码下载