c# 想要将一个excel中数据转移到另外一个excel中，应该怎么做

Question

c# 想要将一个excel中数据转移到另外一个excel中，应该怎么做？最好有完整一点代码

Answer 1

源Excel：

目标Excel：

示例程序结构：

安装 EPPlus NuGet程序包：

示例程序源码：

using OfficeOpenXml;
using System;
using System.IO;

namespace ConsoleApp2
{
    internal class Program
    {
        static void Main(string[] args)
        {
            var baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
            var sourceExcel = Path.Combine(baseDirectory, "files", "source.xlsx");
            var disExcel = Path.Combine(baseDirectory, "files", "dist.xlsx");
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            using var packageSource = new ExcelPackage(new FileInfo(sourceExcel));
            using var packageDist = new ExcelPackage(new FileInfo(disExcel));
            var sheetSource = packageSource.Workbook.Worksheets[0];
            var sheetDist = packageDist.Workbook.Worksheets[0];
            for (var row = 2; row <= sheetDist.Dimension.End.Row; row++)
            {
                if (sheetDist.Cells[row, 1].Value.ToString() == sheetSource.Cells[row, 1].Value.ToString())
                {
                    sheetDist.Cells[row, 3].Value = sheetSource.Cells[row, 2].Value;
                }
            }
            packageDist.Save();
            Console.WriteLine("数据处理完成.");
            Console.ReadKey();
        }
    }
}

运行结果：