PM> Install-Package Spire.XLS

using Spire.Xls;

namespace CopyCellRange
{
    class Program
    {
        static void Main(string[] args)
        {
            //創(chuàng)建 Workbook 對(duì)象
            Workbook sourceBook = new Workbook();

            //加載源工作簿
            sourceBook.LoadFromFile(@"C:\Users\Administrator\Desktop\source.xlsx");

            //獲取源工作表
            Worksheet sourceSheet = sourceBook.Worksheets[0];

            //獲取源單元格區(qū)域
            CellRange sourceRange = sourceSheet.Range["A1:E4"];

            //創(chuàng)建另一個(gè) Workbook 對(duì)象
            Workbook destBook = new Workbook();

            //加載目標(biāo)工作簿
            destBook.LoadFromFile(@"C:\Users\Administrator\Desktop\destination.xlsx");

            //獲取目標(biāo)工作表
            Worksheet destSheet = destBook.Worksheets[0];

            //獲取目標(biāo)單元格區(qū)域
            CellRange destRange = destSheet.Range["B2:F5"];

            //將源區(qū)域的數(shù)據(jù)復(fù)制到目標(biāo)區(qū)域
            sourceSheet.Copy(sourceRange, destRange);

            //遍歷源區(qū)域中的每一列
            for (int i = 0; i < sourceRange.Columns.Length; i++)
            {
                //同時(shí)將源區(qū)域的列寬復(fù)制到目標(biāo)區(qū)域
                destRange.Columns[i].ColumnWidth = sourceRange.Columns[i].ColumnWidth;
            }
            
            //將目標(biāo)工作簿保存為 Excel 文件
            destBook.SaveToFile("CopyRange.xlsx");
        }
    }
}

using Spire.Xls;
namespace CopyRanges_XLS
{
    class Program
    {
        static void Main(string[] args)
        {
            //加載Excel工作簿
            Workbook book = new Workbook();
            book.LoadFromFile("sample.xlsx", ExcelVersion.Version2013);
            //獲取第一個(gè)工作表
            Worksheet sheet = book.Worksheets[0];
            //將源數(shù)據(jù)數(shù)據(jù)復(fù)制到目標(biāo)單元格區(qū)域
            sheet.Copy(sheet.Range["A1:F1"], sheet.Range["A6:F6"], true);
            //保存文檔
            book.SaveToFile("result.xlsx", ExcelVersion.Version2013);
            System.Diagnostics.Process.Start("result.xlsx");
        }
    }
}

using Spire.Xls;
namespace CopyRanges2
{
    class Program
    {
        static void Main(string[] args)
        {
            //加載Excel工作簿1
            Workbook book1 = new Workbook();
            book1.LoadFromFile("sample.xlsx", ExcelVersion.Version2013);
            //加載Excel工作簿2
            Workbook book2 = new Workbook();
            book2.LoadFromFile("test.xlsx");
            //獲取工作表
            Worksheet sheet1 = book1.Worksheets[0];
            Worksheet sheet2 = book2.Worksheets[1];
            //將源數(shù)據(jù)數(shù)據(jù)復(fù)制到目標(biāo)單元格區(qū)域
            sheet1.Copy(sheet1.Range["A1:F1"], sheet2.Range["B4:G4"], true);
            //保存工作簿2
            book2.SaveToFile("result2.xlsx", ExcelVersion.Version2013);
            System.Diagnostics.Process.Start("result2.xlsx");
        }
    }
}