using NPOI.XSSF.UserModel;

 using System;

 using System.Collections.Generic;

 using System.IO;

 using System.Linq;

 using System.Text;

 using System.Threading.Tasks;

 namespace 学习NOPI

 {

     class Program

     {

         static void Main(string[] args)

         {

             //创建workbook工作簿

             XSSFWorkbook workbook = new XSSFWorkbook();

             //在workbook工作簿下创建两个工作表

             workbook.CreateSheet("SheetFirst");

             workbook.CreateSheet("SheetSecond");

             //获取工作表SheetFirst

             XSSFSheet worksheet = (XSSFSheet)workbook.GetSheet("SheetFirst");

             //在工作表下面创建10行

             for (int i = ; i < ; i++)

             {

                 worksheet.CreateRow(i);

             }

             //获取10行中的首行

             XSSFRow sheetrow = (XSSFRow)worksheet.GetRow();

             //申明一个长度10的单元格数组

             XSSFCell[] sheetcell = new XSSFCell[];

             for (int i = ; i < sheetcell.Length; i++)

             {   //创建10个单元格

                 sheetcell[i] = (XSSFCell)sheetrow.CreateCell(i);

                 //分别赋值

                 sheetcell[i].SetCellValue(i);

             }

             //写入流

             using (FileStream fs = new FileStream("TestNOPI.xlsx", FileMode.Create))

             {

                 workbook.Write(fs);

             }

             Console.WriteLine("OK");

             Console.ReadKey();

         }

     }

 }