今天在学习阶段遇到一个技术难题,如何使用Satruts2实现页面列表数据导出到Excel表格,而且只能导出所需要的数据,其余的什么都不用,是不是还需要一个什么“poi”jar包啊?求前辈们指导!谢谢!
------解决方案--------------------------------------------------------
struts2..你拼错了~~
可以用poi包 我用的是poi-2.5.1-finall.jar
贴一部分。
- Java code
private InputStream excelFile;public void setExcelFile(InputStream excelFile) { this.excelFile = excelFile; }public InputStream getExcelFile() { return excelFile;}public String createExcelFile() { try { String[] headName = { "昵称","电子邮箱"}; HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("sheet1"); // 创建表头 HSSFRow row = sheet.createRow(0); HSSFCell cell = row.createCell((short) 0); for (int i = 0; i < headName.length; i++) { cell = row.createCell((short) i); cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16); cell.setCellValue(headName[i]); } for (int i = 0; i < cwcsList.size(); i++) { row = sheet.createRow(i + 1); //昵称 cell = row.createCell((short) 0); cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16); cell.setCellValue(cwcsList.get(i).getCusName()); // 电子邮箱 cell = row.createCell((short) 1); cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16); cell.setCellValue(cwcsList.get(i).getEmail()); } ByteArrayOutputStream baos = new ByteArrayOutputStream(); workbook.write(baos); byte[] ba = baos.toByteArray(); ByteArrayInputStream bais = new ByteArrayInputStream(ba); this.setExcelFile(bais); } catch (IOException e) { e.printStackTrace(); } return "exportExcel" }