POI 导出excel

最新推荐文章于 2024-12-03 14:20:06 发布

原创最新推荐文章于 2024-12-03 14:20:06 发布 · 203 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#poi

本文介绍如何使用Java的Apache POI库实现从数据库获取用户数据，并将其导出为Excel文件的过程。通过示例代码展示了如何创建Excel工作簿、设置表格标题及填充数据等关键步骤。

maven依赖

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

@RequestMapping(value="/export")
    public void export(HttpServletResponse res) throws IOException{
        List<User> allUser = dao.getAllUser();
        HSSFWorkbook book=getBook(allUser);
        res.setContentType("application/ms-excel;charset=UTF-8");
        res.setHeader("Content-Disposition","attachment;filename=" + URLEncoder.encode("用户.xls", "UTF-8"));
        OutputStream os=res.getOutputStream();
        book.write(os);
        os.flush();
        os.close();
    }


    private HSSFWorkbook getBook(List<User> allUser){
        HSSFWorkbook book=new HSSFWorkbook();
        HSSFSheet sheet=book.createSheet("用户表");
        //设置title
        HSSFRow row = sheet.createRow(0);
        int index=0;
        setValue(row,index++,"ID");
        setValue(row,index++,"用户名");
        setValue(row,index++,"密码");

        int dataIndex=1;

        for(User u:allUser){
            setData(sheet, dataIndex++,u);
        }


        return book;

    }

    private void setValue(HSSFRow row,int index,String value){
        HSSFCell cell=row.createCell(index);
        cell.setCellValue(value);
    }

    private void setData(HSSFSheet sheet,int rowindex,User u){
        HSSFRow row = sheet.createRow(rowindex);
        int index=0;
        setValue(row,index++,String.valueOf(u.getId()));
        setValue(row,index++,u.getUserName());
        setValue(row,index++,u.getPassword());


    }