POI导出excel

1.代码demo

//创建对象
HSSFWorkbook wb = new HSSFWorkbook();
//sheet名称
HSSFSheet userTable = wb.createSheet("sheet1");
//设置单元列名
HSSFRow row1 = userTable.createRow(0);
//列名.........
row1.createCell(0).setCellValue("用户id");
row1.createCell(1).setCellValue("姓名");
row1.createCell(2).setCellValue("性别");

//写数据
if (!CollectionUtils.isEmpty(userList)) {
    //循环对象数组的大小
   int size = userList.size();
   for(int i=0;i<size;i++){
        User user = userList.get(i);
        HSSFRow row = userTable.createRow(i + 1);
        row.createCell(0).setCellValue(user .getUserId());
        row.createCell(1).setCellValue(user.getUsername());
        row.createCell(2).setCellValue(user.getSex());
   }
}
//把excel文件写到对应位置
wb.write(new FileOutputStream(realPath));

需要的jar包

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.1</version>
        </dependency>

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