C#导出Excl速度慢的解决方法.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 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); } //MessageBox.Show(导出成功！); } catch (Exception e) { sw.Close(); MessageBox.Show(e.ToString()); } finally { sw.Close();