EPPlus将列的数据复制到空列中

using OfficeOpenXml;

// 打开现有的Excel文件
ExcelPackage package = new ExcelPackage(new FileInfo("path/to/excel/file.xlsx"));

// 或者创建一个新的Excel文件
ExcelPackage package = new ExcelPackage();

ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];

int sourceColumnStart = 1;  // 源列的起始列索引
int sourceColumnEnd = 1;    // 源列的结束列索引
int targetColumn = 2;       // 目标列的列索引
int rowCount = worksheet.Dimension.Rows;  // 行数

for (int row = 1; row <= rowCount; row++)
{
    // 获取源列的单元格
    ExcelRange sourceCell = worksheet.Cells[row, sourceColumnStart, row, sourceColumnEnd];

    // 获取目标列的单元格
    ExcelRange targetCell = worksheet.Cells[row, targetColumn];

    // 将源列的值复制到目标列
    targetCell.Value = sourceCell.Value;
}

package.Save();
package.Dispose();