用C#在Excel中复制/粘贴单元格

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("路径/文件名.xlsx");

Excel.Worksheet worksheet = workbook.Sheets[1];
Excel.Range sourceRange = worksheet.Range["A1"];
string sourceValue = sourceRange.Value.ToString();

Excel.Range targetRange = worksheet.Range["B1"];
targetRange.Value = sourceValue;

workbook.Save();
workbook.Close();

using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelCopyPasteExample
{
    class Program
    {
        static void Main(string[] args)
        {
            Excel.Application excelApp = new Excel.Application();
            Excel.Workbook workbook = excelApp.Workbooks.Open("路径/文件名.xlsx");

            Excel.Worksheet worksheet = workbook.Sheets[1];
            Excel.Range sourceRange = worksheet.Range["A1"];
            string sourceValue = sourceRange.Value.ToString();

            Excel.Range targetRange = worksheet.Range["B1"];
            targetRange.Value = sourceValue;

            workbook.Save();
            workbook.Close();

            excelApp.Quit();
        }
    }
}