是的,设置EnableCalculation =true后, 循环遍历单元格,通过取Value的方式触发计算,如下,并行取value是指, 每个单元格开一个Task取执行取Value
for (var r = 0; r < originRange.RowCount; r++)
{
for (var c = 0; c < originRange.ColumnCount; c++)
{
copyWorkbook.Worksheets[i].Cells[r, c].Value = originRange.Cells[r, c].Value;
}
} |