CX导出Excel速度慢的解决方法.docVIP

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, excelSh