NPOI 支持 .xlsx 格式吗

NPOI是一款强大的.NET库，用于处理Excel文件。它是开源的，并且提供了许多功能，使我们可以在C#中读取、写入和操作Excel文件。那么，NPOI是否支持.xlsx格式的文件呢？下面我们将详细介绍。

csharp
using (FileStream fs = new FileStream("sample.xlsx", FileMode.Open, FileAccess.Read))
{
    XSSFWorkbook workbook = new XSSFWorkbook(fs);
    XSSFSheet sheet = workbook.GetSheetAt(0);
    for (int row = 0; row <= sheet.LastRowNum; row++)
    {
        XSSFRow currentRow = sheet.GetRow(row);
        for (int col = 0; col < currentRow.LastCellNum; col++)
        {
            string cellValue = currentRow.GetCell(col)?.ToString();
            Console.WriteLine(cellValue);
        }
    }
}

csharp
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = (XSSFSheet)workbook.CreateSheet("Sheet1");
for (int row = 0; row < 5; row++)
{
    XSSFRow currentRow = (XSSFRow)sheet.CreateRow(row);
    for (int col = 0; col < 5; col++)
    {
        XSSFCell cell = (XSSFCell)currentRow.CreateCell(col);
        cell.SetCellValue($"Row {row}, Column {col}");
    }
}
using (FileStream fs = new FileStream("output.xlsx", FileMode.Create, FileAccess.Write))
{
    workbook.Write(fs);
}