C# Excel Interop 一次设置多个单元格值

Question

如何一次将值添加到同一行的 5 个单元格？

这是现在添加它们的方式:

ws.Cells[1, 1] = "1";
ws.Cells[1, 2] = "2";
ws.Cells[1, 3] = "3";
ws.Cells[1, 4] = "4";
ws.Cells[1, 5] = "5";

预期结果:

Answer 1

使用范围和数组:

var rng = (Excel.Range)ws.Range[ws.Cells[1, 1], ws.Cells[1, 5]];
rng.Value = new int[] { 1, 2, 3, 4, 5 }; // one dimensional array