EPPlus导出Excel文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OfficeOpenXml;
using System.IO;
namespace ConsoleApp1 {
    class Program {
        static void Main(string[] args) {
            FileInfo fi = new FileInfo("c:\\test.xlsx");
            ExcelPackage pck = new ExcelPackage(fi);
            ExcelWorksheet sheet = pck.Workbook.Worksheets.Add("sheet1");
            for(int i=1;i<=3;i++) {
                sheet.Cells[i, 1].Value = "a" + i.ToString();
                sheet.Cells[i, 2].Value = "b" + i.ToString();
                sheet.Cells[i, 3].Value = "c" + i.ToString();
            }
            sheet.Cells[1, 1, 1, 3].Style.Font.Bold = true;
            pck.Save();
            Console.ReadLine();
        }
    }
}

工具类下载 DataTable导出数据Excel文件，可web导出