可以用Free Spire.XLS实现这个功能
nuget安装命令:
Install-Package FreeSpire.XLS
实现代码:
using Spire.Xls;
namespace CopyCellRange
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\source.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//设置需要复制的单元格区域
CellRange sourceRange = sheet.Range["A1:F30"];
//设置目标单元格区域
CellRange destRange = sheet.Range["A31:F60"];
//将原单元格区域的数据和格式复制到目标单元格区域
sheet.Copy(sourceRange, destRange);
//复制原单元格区域的列宽到目标单元格区域
for (int i = 0; i < sourceRange.Columns.Length; i++)
{
destRange.Columns[i].ColumnWidth = sourceRange.Columns[i].ColumnWidth;
}
//保存
workbook.SaveToFile("CopyRange.xlsx");
}
}
}
nuget安装命令:
Install-Package FreeSpire.XLS
实现代码:
using Spire.Xls;
namespace CopyCellRange
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\source.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//设置需要复制的单元格区域
CellRange sourceRange = sheet.Range["A1:F30"];
//设置目标单元格区域
CellRange destRange = sheet.Range["A31:F60"];
//将原单元格区域的数据和格式复制到目标单元格区域
sheet.Copy(sourceRange, destRange);
//复制原单元格区域的列宽到目标单元格区域
for (int i = 0; i < sourceRange.Columns.Length; i++)
{
destRange.Columns[i].ColumnWidth = sourceRange.Columns[i].ColumnWidth;
}
//保存
workbook.SaveToFile("CopyRange.xlsx");
}
}
}