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

C#导出Ex cel 速度慢的解决方法 方法一： 通过二维数组把数据准备好，一次性写入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 object[rowCount,colCount]; for (int i = 0; i < rowCount; i++) { for (int j=0;j< colCount;j++) { dataArray[i, j] = dt.Rows[i][j]; } } excelSheet.get_Range("A1", excelSheet.Cells[rowCount, colCount]).Value2 = dataArray; } 由于二维数组是在内存中实现，所以速度很快，由于是一次性写入到Excel 中，使我们几乎感觉不到延迟，在Excel 打开后数据马上就出来了，感觉很爽。 方法二： private void SaveAs() //另存新档按钮，导出成Excel { DataTable 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.Rows[i]["a"].ToString() + "\t"; tempStr += dt.Rows[i]["b"].ToString() + "\t"; tempStr += dt.Rows[i]["c"].ToString() + "\t"; sw.WriteLine(tempStr);...