java poi 创建Excel表格 并 插入数据

java poi 创建Excel表格 并 插入数据

首先引入poi jar包
poi.xml

  <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.14</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-excelant -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-excelant</artifactId>
            <version>3.14</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-examples -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-examples</artifactId>
            <version>3.14</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.xmlbeans/xmlbeans -->
        <dependency>
            <groupId>org.apache.xmlbeans</groupId>
            <artifactId>xmlbeans</artifactId>
            <version>2.6.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>ooxml-schemas</artifactId>
            <version>1.3</version>
        </dependency>

 XSSFWorkbook workBook = new XSSFWorkbook();   //new一个表
 XSSFSheet sheet = workBook.createSheet("sheet"); //添加一个sheet
 //创建行
XSSFRow row = sheet.createRow(0);
 //创建单元格，第一行标题
 XSSFCell cell0 = row.createCell(0);
 XSSFCell cell1 = row.createCell(1);
 XSSFCell cell2 = row.createCell(2);
 XSSFCell cell3 = row.createCell(3);
 XSSFCell cell4 = row.createCell(4);
 XSSFCell cell5 = row.createCell(5);
 XSSFCell cell6 = row.createCell(6);
 XSSFCell cell7 = row.createCell(7);
 XSSFCell cell8 = row.createCell(8);
 XSSFCell cell9 = row.createCell(9);
 cell0.setCellValue("标题1");
 cell1.setCellValue("标题2");
 cell2.setCellValue("标题3");
 cell3.setCellValue("标题4");
 cell4.setCellValue("标题5");
 cell5.setCellValue("标题6");
 cell6.setCellValue("标题7");
 cell7.setCellValue("标题8");
 cell8.setCellValue("标题9");
 cell9.setCellValue("标题10");
 cell6.setCellType(HSSFCellStyle.ALIGN_LEFT);  //单元格内容居左
//添加更多行同上原理一样

 FileOutputStream outputStream = new FileOutputStream(new File("url"+ "文件名"));//url和文件名换成自己的
 workBook.write(outputStream); //输出文件
 workBook.close();//关闭工作簿

自己项目实例，绝对有效