static void Main(string[] args)
{
//获取当前用户电脑桌面地址
string str = System.Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
//指定EPPlus使用非商业证书
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
//生成文件名称
var fileName = "Example" + DateTime.Now.ToString("yyyy-MM-dd hh-mm-ss") + ".xlsx";
//生成文件
var file = new FileInfo(fileName);
using (var excel = new ExcelPackage(str+@"\"+file))
{
//first sheet name
var sheet = excel.Workbook.Worksheets.Add("List" + DateTime.Now.ToShortDateString());
//数据填充
for (int i = 0; i < 10; i++)
{
if (i == 1)
{
sheet.Cells[i, 1].Value = "标题";
}
else
{
sheet.Cells[i, 1].Value = "测试写入Excel";
}
}
excel.Save();
}
}