复制列或行

workSheet.Cells[1,5,100,5].Copy(workSheet.Cells[1,2,100,2]);

将第 5 列复制到第 2 列基本上是 Source.Copy（目标）

这只会复制前 100 行。

Cells[RowStart, ColumnStart, RowEnd, ColumnEnd ]
is the format so to copy a row into another row you would just switch the indexes accordingly