c#导出excel速度慢的解决方法

《c#导出excel速度慢的解决方法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、C#导出Excel速度慢的解决方法方法一：通过二维数组把数据准备好，一次性写入Excel：privateExcel.ApplicationexcelApp=newExcel.ApplicationClass();privateExcel.WorkbookexcelBook=excelApp.Workbooks.Add(Type.Missing);privateExcel.WorksheetexcelSheet=(Excel.Worksheet)excelBook.ActiveSheet;excelApp.Vis

2、ible=true;publicvoidDataTableToExcel(DataTabledt){introwCount=dt.Rows.Count;intcolCount=dt.Columns.Count;object[,]dataArray=newobject[rowCount,colCount];for(inti=0;i

3、("A1",excelSheet.Cells[rowCount,colCount]).Value2=dataArray;}由于二维数组是在内存中实现，所以速度很快，由于是一次性写入到Excel中，使我们几乎感觉不到延迟，在Excel打开后数据马上就出来了，感觉很爽。方法二：privatevoidSaveAs()//另存新档按钮，导出成Excel{DataTabledt=dc.getTable("select*fromtable");if(dt.Rows.Count==0){MessageBox.Show("没有

4、要输出为excel的数据！");return;}SaveFileDialogsaveFileDialog=newSaveFileDialog();saveFileDialog.Filter="Execlfiles(*.xls)

5、*.xls";saveFileDialog.FilterIndex=0;saveFileDialog.RestoreDirectory=true;saveFileDialog.CreatePrompt=true;saveFileDialog.Title="生成Excel";saveFil

6、eDialog.ShowDialog();he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchempha

7、sisonthedifficultyofthework.Forexample,noncoalmineStreammyStream;try{myStream=saveFileDialog.OpenFile();//StreamWritersw=newStreamWriter(myStream,System.Text.Encoding.GetEncoding("gb2312"));StreamWritersw=newStreamWriter(myStream,System.Text.Encoding.GetEnco

8、ding(-0));try{stringstr="字段t字段t字段t";//表头sw.WriteLine(str);for(inti=0;i

9、mpStr);}//MessageBox.Show("导出成功！");}catch(Exceptione){sw.Close();MessageBox.Show(e.ToString());}finally{sw.Close();myStream.Close();}sw.Close();myStream.Close();}catch(Exceptione){MessageBox.Sho