导出CSV EXCEL

最新推荐文章于 2024-07-25 09:56:02 发布

c_andy

最新推荐文章于 2024-07-25 09:56:02 发布

阅读量378

点赞数

分类专栏： java 文章标签： csv excel action os

本文链接：https://blog.csdn.net/c_andy/article/details/4294070

版权

java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

CSV描述：

用于数据导出

Action核心代码：

StringBuffer csvString=new StringBuffer();

csvString.append("args1"+",");

csvString.append("args2"+"/n");

ServletOutputStream outStream = response.getOutputStream(); response.setContentType("csv; charset=UTF-8"); response.setHeader("Content-disposition","attachment; filename=Name.csv"); outStream.write(csvString.getBytes()); response.setStatus(HttpServletResponse.SC_OK); outStream.close();

Excel描述：

使用org.apache.poi包；

Action核心代码：

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Plan Sectoin");

HSSFRow row0 = sheet.createRow((short)curRow);

row0.createCell((short)0).setCellValue(new HSSFRichTextString("Plan Section Detail"));

            response.setContentType("application/x-download"); //application/x-download
            String filenamedisplay = "plan" + ".xls";
            response.addHeader("Content-Disposition", "attachment;filename=" + filenamedisplay);
            OutputStream 或者可以是【ServletOutputStream】 os = response.getOutputStream();
            wb.write(os);
            os.flush();
            os.close();