///
/// Excel一次性大量数据快速写入
///
/// 工作薄路径
/// 要写入的工作表名字
private void WriteExcel(string path,string sheetName)
{
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false; //不显示EXCEL
app.DisplayAlerts = false; //不提示信息
app.ScreenUpdating = false; //停止更新屏幕，加快速度
Workbooks wbs = app.Workbooks; //获取工作薄
_Workbook wb = wbs.Open(path); //打开文件
Sheets shs = wb.Worksheets; //文件中的Sheets
System.Data.DataTable table = getDataTable();//调用getDataTable()方法获取DataTable内存表
CopyDataToSheet(table, shs[sheetName]); //调用方法，将DataTable里的数据写入到Sheet中
wb.Save(); //保存
wb.Close(); //关闭工作薄
app.Quit(); //关闭EXCEL
MessageBox.Show("OK");
}
//快速写入（先写入数组，然后一次性将数组写入到EXCEL中）
private void CopyDataToSheet(System.Data.DataTable Table, _Worksheet Sheet)
{
int colCount, rowCount;
colCount = Table.Columns.Count;
rowCount = Table.Rows.Count;
Range range;
//写入标题行
range = Sheet.get_Range("A1", Missing.Value);
range = range.get_Resize(1, colCount);
object[,] headerData = new object[1, colCount];
for (int iCol = 0; iCol < colCount; iCol++)
{
headerData[0, iCol] = Table.Columns[iCol].ColumnName;
}
range.set_Value(Missing.Value, headerData);
//写入数据行
range = Sheet.get_Range("A2", Missing.Value);
range = range.get_Resize(rowCount, colCount);
object[,] cellData = new object[rowCount, colCount];
for (int iRow = 0; iRow < rowCount; iRow++)
{
for (int iCol = 0; iCol < colCount; iCol++)
{
cellData[iRow, iCol] = Table.Rows[iRow][iCol].ToString();
}
}
range.set_Value(Missing.Value, cellData);
}原文：https://www.cnblogs.com/zhujie-com/p/12657139.html