使用 Microsoft.office.Interop.Excel
从 Excel 文件中读取数据时,如果使用 Range dataRange = (Range)cSheet.Cells[row, col];
进行操作,性能会非常慢。但是如果去掉 Range dataRange = (Range)cSheet.Cells[row, col];
,则速度将更快。我错过了什么?需要做出哪些改变?
int rows = cSheet.UsedRange.Rows.Count;
int cols = cSheet.UsedRange.Columns.Count;
for (int row = 2; row <= rows; row++)
{
for (int col = 1; col <= cols; col++)
{
Range dataRange = (Range)cSheet.Cells[row, col];
}
}
dataRange.Value2 = objectArray;
- Jeremy Thompson