JSP 无模板导出功能实现

最新推荐文章于 2023-03-09 15:18:48 发布

xiangjinqi

最新推荐文章于 2023-03-09 15:18:48 发布

阅读量89

点赞数

分类专栏： java算法

本文链接：https://blog.csdn.net/xiangjinqi/article/details/84153953

版权

java算法专栏收录该内容

22 篇文章 0 订阅

订阅专栏

HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("application/octet-stream");
		exportName = "PIS-品牌重合度查询结果"+DateUtils.formatDate(DateUtils.getCurrentDate(), "yyyy-MM-dd");
		String encodeName=URLEncoder.encode(exportName,"UTF-8");
		response.setHeader("Content-Disposition",
				"attachment;filename="+encodeName+".xls");
		HSSFWorkbook book = new HSSFWorkbook();
		HSSFSheet sheet = book.createSheet("brandStatisticsResult");
		
		HSSFCellStyle cellStyle_text = book.createCellStyle();
		cellStyle_text.setBorderLeft(HSSFCellStyle.BORDER_THIN);
		cellStyle_text.setBorderRight(HSSFCellStyle.BORDER_THIN);
		cellStyle_text.setBorderTop(HSSFCellStyle.BORDER_THIN);
		cellStyle_text.setBorderBottom(HSSFCellStyle.BORDER_THIN);	
		
		int rowCount = 0;
		int colCount = 0;
		for (List<String> xList : colAll) {
			HSSFRow row = sheet.createRow(rowCount);
			colCount = 0;
			for(String ceString : xList){
				HSSFCell cell = row.createCell( colCount );
				cell.setCellValue(ceString);
				colCount++;
			}
			rowCount++;
		}
		
		book.write(response.getOutputStream());
		}catch (Exception e) {
				e.printStackTrace();
				System.out.println(e.getMessage());
			}
		return null;

其中 List<List<String>> list =new ArrayList<List<String>>();

标题可以先设置

List<String> title = new List<String>;

title.add("title1");

title.add("title2");

title.add("title3");

list.addAll(title)

在页面上document.openUrl("actionurl")

就可以得到下载的内容了