C#导出Excel速度慢的解决方法.doc

C#导出Excel速度慢的解决方法方法一：通过二维数组把数据准备好，一次性写入Excel：private Excel.Application excelApp= new Excel.ApplicationClass();private Excel.Workbook excelBook = excelApp.Workbooks.Add(Type.Missing);private Excel.Worksheet excelSheet = (Excel.Worksheet)excelBook.ActiveSheet; excelApp.Visible = true;public void DataTableToExcel(DataTable dt) int rowCount = dt.Rows.Count;int colCount = dt.Columns.Count;object, dataArray = new objectrowCount,colCount;for (int i = 0; i rowCount; i+)for (int j=0;j colCount;j+)dataArrayi, j = dt.Rowsij;excelSheet.get_Range(A1, excelSheet.CellsrowCount, colCount).Value2 = dataArray;由于二维数组是在内存中实现，所以速度很快，由于是一次性写入到Excel中，使我们几乎感觉不到延迟，在Excel打开后数据马上就出来了，感觉很爽。方法二：private void SaveAs() /另存新档按钮，导出成ExcelDataTable dt = dc.getTable(select * from table);if (dt.Rows.Count = 0) MessageBox.Show(没有要输出为excel的数据！); return;SaveFileDialog saveFileDialog = new SaveFileDialog();saveFileDialog.Filter = Execl files (*.xls)|*.xls;saveFileDialog.FilterIndex = 0;saveFileDialog.RestoreDirectory = true;saveFileDialog.CreatePrompt = true;saveFileDialog.Title = 生成Excel;saveFileDialog.ShowDialog(); Stream myStream;try myStream = saveFileDialog.OpenFile(); /StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(gb2312); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0); try string str = 字段t字段t字段t;/表头 sw.WriteLine(str); for (int i = 0; i dt.Rows.Count; i+) string tempStr = string.Empty;tempStr += dt.Rowsia.ToString() + t;tempStr += dt.Rowsib.ToString() + t;tempStr += dt.Rowsic.ToString() + t;sw.WriteLine(tempStr); /MessageBox.Show(导出成功！); catch (Exception e) sw.Close(); MessageBox.Show(e.ToString(); finally sw.Close(); myStream.Close(); sw.Close(); myStream.Close();catch (Exception e) MessageBox.Show(e.Message); return;方法三：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Drawing;using System.IO;using System.Text;/ / Author:匆匆 Blog:/huangjianhuakarl/ 将Gridview中的数据导出Excel表格/ public partial class GridviewExcel : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) bind(); / / 数据绑定 / public void bind() string sqlStr = select * from Employee; DataSet myds = Common.dataSet(sqlStr); GridView1.DataSource = myds; GridView1.DataKeyNames = new string ID ; GridView1.DataBind(); / / 在GridView 控件中的某个行被绑定到一个数据记录时发生。此事件通常用于在某个行被绑定到数据时修改该行的内容。 / / / protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) foreach (TableCell tc in e.Row.Cells) tc.Attributesstyle = border-color:Black; if (e.Row.RowIndex != -1) int id = GridView1.PageIndex * GridView1.PageSize + e.Row.RowIndex + 1; e.Row.Cells0.Text = id.ToString(); / / 导出Excel / / / protected void Button1_Click(object sender, EventArgs e) Export(application/ms-excel, Employee information.xls); / / 定义导出Excel的函数 / / / private void Export(string FileType, string FileName) Response.Charset = GB2312; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader(Content-Disposition, attachment;filename= + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString(); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); GridView1.RenderControl(hw); Response.Write(tw.ToString(); Response.End(); / / 此方法必重写，否则会出错 / / public override void VerifyRenderingInServerF