java使用poi在excel中写入数据入门篇

第一步：映入POI包

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

第二步：编写程序

1、创建POI Excel对象

Workbook workbook=new  XSSFWorkbook();

2、创建表单名称

Sheet sheet = workbook.createSheet("test");

3、创建文件流

FileOutputStream pis = null;
try {
    //3、创建文件流，写入文件路径
    pis = new FileOutputStream("E:\\azb\\test.xlsx");

} catch (FileNotFoundException e) {
    e.printStackTrace();
}

4.写入文件

workbook.write(pis);
5、关闭文件流
pis.close();