struts2 poi excel 导出

1、struts2配置文件

<!-- 下载专题库资源分类的excel模板 -->

<action name="getResClassifyDemo" class="ResClassifyAction"

method="getResClassifyDemo">

<result type="stream">

<param name="contentType">application/vnd.ms-excel</param>

<param name="inputName">excelStream</param>

<param name="contentDisposition">attachment;filename="demo.xls"</param>

<param name="bufferSize">4096</param>

</result>

</action>

2、Action 方法

/***

* 下载资源分类的excel模板 zhang.kt

*/

private InputStream excelStream;

 

public InputStream getExcelStream() {

return excelStream;

}

 

public void setExcelStream(InputStream excelStream) {

this.excelStream = excelStream;

}

 

public String getResClassifyDemo() {

/*

* 查询应用分类导航书，按照node_id从小到大排序

*/

List<ResClassifyEntity> ls = this.resClassifyService.showResClassifyByOrder();

try {

HSSFWorkbook wb = this.writeXLS(ls);

this.exportExcel(wb);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return SUCCESS;

 

}

3、action 方法中调用的公共方法

//excel导出

private void exportExcel(HSSFWorkbook workbook) throws IOException {

ByteArrayOutputStream baos = new ByteArrayOutputStream();

workbook.write(baos);

baos.flush();

byte[] aa = baos.toByteArray();

excelStream = new ByteArrayInputStream(aa, 0, aa.length);

baos.close();

}

//excel数据写入的操作

public HSSFWorkbook writeXLS(List<ResClassifyEntity> list) {

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("new sheet");

/** 创建样式 */

// 创建字体样式

HSSFFont font = wb.createFont();

font.setFontName("Verdana");

font.setBoldweight((short) 100);

font.setFontHeight((short) 300);

font.setColor(HSSFColor.BLUE.index);

// 创建单元格样式

HSSFCellStyle style = wb.createCellStyle();

style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

style.setFillForegroundColor(HSSFColor.LIGHT_TURQUOISE.index);

style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

// 设置边框

style.setBottomBorderColor(HSSFColor.RED.index);

style.setBorderBottom(HSSFCellStyle.BORDER_THIN);

style.setBorderLeft(HSSFCellStyle.BORDER_THIN);

style.setBorderRight(HSSFCellStyle.BORDER_THIN);

style.setBorderTop(HSSFCellStyle.BORDER_THIN);

style.setFont(font);// 设置字体

 

String[] titles = { "节点ID", "父节点ID", "节点名称", "节点层数" };

int count = titles.length;

int size = list.size();

for (int i = 0; i < titles.length; i++) {

sheet.setColumnWidth(i, 4000); 

}

/** 创建sheet行和列 */

for (int i = 0; i <= size; i++) {

sheet.createRow(i);

HSSFRow rowtitletemp = sheet.getRow(i);

for (int j = 0; j < count; j++) {

rowtitletemp.createCell(j);

}

}

/** 向sheet页中添加数据 */

for (int i = 0; i <= size; i++) {

if (i == 0) {

                       //添加表头标题

HSSFRow hsRow = sheet.getRow(0);

for (int j = 0; j < titles.length; j++) {

hsRow.getCell(j).setCellStyle(style);

hsRow.getCell(j).setCellValue(titles[j].toString());

}

} else {

                              //填充数据

ResClassifyEntity resEntity = (ResClassifyEntity) list.get(i-1);

HSSFRow hssfRow = sheet.getRow(i);

for (int j = 0; j < titles.length; j++) {

hssfRow.getCell(j).setCellStyle(style);

if (j == 0) {

hssfRow.getCell(j).setCellValue(resEntity.getNodeId());

} else if (j == 1) {

hssfRow.getCell(j).setCellValue(resEntity.getParentId());

} else if (j == 2) {

hssfRow.getCell(j).setCellValue(resEntity.getNodeName());

} else {

hssfRow.getCell(j).setCellValue(resEntity.getOther());

}

}

 

}

}

return wb;

}

 

前台jsp页面：

<SCRIPT type="text/javascript">

js代码

function downLoadDemo() {

window.location.href = "/system/classify/getResClassifyDemo.action";

}

</SCRIPT>

页面类容

 <input type="button" id="" value="模板下载" class="input_btn_2"

onclick="downLoadDemo()">