jsp 生产Excel文件

最新推荐文章于 2024-10-08 16:12:58 发布

kakarotto_li

最新推荐文章于 2024-10-08 16:12:58 发布

阅读量207

点赞数

文章标签： excel jsp file exception stream user

本文链接：https://blog.csdn.net/lw2562201/article/details/6175968

版权

    public InputStream getInputStream()
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet("sheet1");

        HSSFRow row = sheet.createRow(0);

        HSSFCell cell = row.createCell((short) 0);
        cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellValue("序号");

        cell = row.createCell((short) 1);
        cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellValue("姓");

        cell = row.createCell((short) 2);
        cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellValue("名");

        cell = row.createCell((short) 3);
        cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellValue("年龄");

        List<User> list = this.findAll();

        for (int i = 0; i < list.size(); ++i)
        {
            User user = list.get(i);

            row = sheet.createRow(i + 1);

            cell = row.createCell((short) 0);
            cell.setEncoding(HSSFCell.ENCODING_UTF_16);
            cell.setCellValue(i + 1);

            cell = row.createCell((short) 1);
            cell.setEncoding(HSSFCell.ENCODING_UTF_16);
            cell.setCellValue(user.getFirstname());

            cell = row.createCell((short) 2);
            cell.setEncoding(HSSFCell.ENCODING_UTF_16);
            cell.setCellValue(user.getLastname());

            cell = row.createCell((short) 3);
            cell.setEncoding(HSSFCell.ENCODING_UTF_16);
            cell.setCellValue(user.getAge());
        }

        File file = new File("test.xls");

        try
        {
            OutputStream os = new FileOutputStream(file);
            wb.write(os);
            os.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }

        InputStream is = null;
        try
        {
            is = new FileInputStream(file);
        }
        catch (FileNotFoundException e)
        {
            e.printStackTrace();
        }

        return is;

    }

}

        <action name="generateExcel" class="generateExcelAction">
            <result name="success" type="stream">
                <param name="contentType">application/vnd.ms-excel</param>
                <param name="contentDisposition">filename="AllUsers.xls"</param>
                <param name="inputName">downloadFile</param>
            </result>
        </action>