.net core 3.0使用DotNetCore.NPOI创建Excel

1. 新建一个.net core 3.0控制台应用程序，添加引用DotNetCore.NPOI， Version: 1.2.2

 

 

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 void Main(string[] args)
        {
            var workbo