1. 新建一个.net core 3.0控制台应用程序,添加引用DotNetCore.NPOI, Version: 1.2.2
![2789632-f7cf864054fdacc5.png](https://i-blog.csdnimg.cn/blog_migrate/57fbfb684d8e84353bf467d6d2081b88.png)
2. 创建一个.xlsx文件
class Program
{
static void Main(string[] args)
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet("TestSheet");
sheet.CreateRow(0).CreateCell(0).SetCellValue("Hello World");
var path = @"D:\Test\Test.xlsx";
using (var stream = new FileStream(path, FileMode.Create, FileAccess.Write))
{
workbook.Write(stream);
}
}
}
3. 创建一个.xls文件
class Program
{
static v