POI生成excel文件

pom.xml

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.16</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.16</version>
</dependency>

测试类

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.jupiter.api.Test;

import java.io.FileOutputStream;

public class POITest {

    @Test
    public void test() throws Exception {
        //创建工作簿，对应整个xlsx文件
        XSSFWorkbook workbook = new XSSFWorkbook();
        //创建sheet，对应excel的单个sheet
        XSSFSheet sheet = workbook.createSheet("sheet1");
        //创建行，对应excel中的一行
        XSSFRow row = sheet.createRow(0);
        //创建单元格，对应row中的一格
        XSSFCell cell = row.createCell(0);
        //单元格设置值
        cell.setCellValue("1");

        //输出
        FileOutputStream fileOut = new FileOutputStream("D:\\dir\\c.xlsx");
        workbook.write(fileOut);
        
        //关闭流
        fileOut.close();
        workbook.close();
    }
}