複製列或行

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