C# Excel工作表区域Range装入数组

int recordCount = endRowIndex - 1;
try
{
Thread.Sleep(1000);
object[,] records = worksheet.Range["A1:E"+ endRowIndex].Value2;
for (int i =2; i <= endRowIndex; i++)
{
try
{
//OnProgressChanged(this.progressChangeEventHandler, i - 1, recordCount);
//ProcessResultType resultType = excutor($"{worksheet.Cells[i, 1].Text}\{worksheet.Cells[i, 2].Text}", $"{worksheet.Cells[i, 4].Text}");
//worksheet.Cells[i, 5].Value = resultType.ToString();
OnProgressChanged(this.progressChangeEventHandler, i - 1, recordCount);
ProcessResultType resultType = excutor($"{records[i, 1]}\{records[i, 2]}", $"{records[i, 4]}");
records[i, 5] = resultType.ToString();
}
catch (Exception)
{
OnProgressChanged(this.progressChangeEventHandler, $"操作记录{i - 1}时出错。");
//worksheet.Cells[i, 5].Value = ProcessResultType.UnknownErr.ToString();
records[i, 5] = ProcessResultType.UnknownErr.ToString();
}
}
worksheet.Range["A1"].Resize[endRowIndex, 5].Value = records;
}

原文地址:https://www.cnblogs.com/yzhyingcool/p/14016476.html