EPPlus操作excel

一 基本使用

string outputFile = "d:\output.xlsx";        //输出的excel文件
string templateFile = "d:\template.xlsx"; //excel模板文件
using (var package = new ExcelPackage(new FileInfo(outputFile), new FileInfo(templateFile)))
{
   var worksheet = package.Workbook.Worksheets["Sheet1"];
   worksheet.Cells[1,1].Value = "文本内容";
   //TODO:
   //...
   
   package.Save();   //保存
}

二 设置样式,格式

//设置行高,列宽
worksheet.Row(1).Height = 22.50;
worksheet.Row(2).Height = 22.50;
worksheet.Column(1).Width= 40.50;
worksheet.Column(2).Width= 40.50;


//设置单元格
using (var r = worksheet.Cells[fromRow, fromCol, toRow, toCol])
{
    //是否合并单元格
    r.Merge = true;
    
    //单元格边框线条
    r.Style.Border.Top.Style = ExcelBorderStyle.Thin;
    r.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
    r.Style.Border.Left.Style = ExcelBorderStyle.Thin;
    r.Style.Border.Right.Style = ExcelBorderStyle.Thin;
    
    //单元格边框颜色
    r.Style.Border.Top.Color.SetColor(System.Drawing.Color.Black);
    r.Style.Border.Bottom.Color.SetColor(System.Drawing.Color.Black);
    r.Style.Border.Left.Color.SetColor(System.Drawing.Color.Black);
    r.Style.Border.Right.Color.SetColor(System.Drawing.Color.Black);
}

三 拷贝单元格

var destWorksheet = package.Workbook.Worksheets["目标worksheet"];
var srcWorksheet = package.Workbook.Worksheets["源worksheet"];
var destCellRange = destWorksheet.Cells[fromRow1, fromColumn1, toRow1, toColumn1];
var srcCellRange = srcWorksheet.Cells[fromRow2, fromColumn2, toRow2, toColumn2];
srcCellRange.Copy(destCellRange);