ExtJS实现Excel导出.doc

ExtJS实现Excel导出
ExtJS是一种基于客户端开发的AJAX应用，是一个与后台技术无关的前台ajax框架。由于项目需求，我们需要实现Excel的导出功能，前台界面是用ExtJS实现。如何实现呢？

使用POI组件实现excel导出功能
//获取问题列表
List<Suggestion>targetStockList=suggestionService.getSuggestionList(map);

//创建一个新的Excel
HSSFWorkbookworkBook=newHSSFWorkbook();
//创建sheet页
HSSFSheetsheet=workBook.createSheet();
//sheet页名称
workBook.setSheetName(0,"targetStockList");
//创建header页
HSSFHeaderheader=sheet.getHeader();
//设置标题居中
header.setCenter("标题");

//设置第一行为Header
HSSFRowrow=sheet.createRow(0);
HSSFCellcell0=row.createCell(Short.valueOf("0"));
HSSFCellcell1=row.createCell(Short.valueOf("1"));
HSSFCellcell2=row.createCell(Short.valueOf("2"));

//设置字符集
cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
cell2.setEncoding(HSSFCell.ENCODING_UTF_16);

cell0.setCellValue("问题标题");
cell1.setCellValue("问题描述");
cell2.setCellValue("反馈时间");

if(targetStockList!=null&&!targetStockList.isEmpty()){
for(inti=0;i<targetStockList.size();i++){
SuggestiontargetStock=targetStockList.get(i);
row=sheet.createRow(i+1);
cell0=row.createCell(Short.valueOf("0"));
cell1=row.createCell(Short.valueOf("1"));
cell2=row.createCell(Short.valueOf("2"));

//设置字符集
cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
cell2.setEncoding(HSSFCell.ENCODING_UTF_16);

cell0.setCellValue(targetStock.getType());
cell1.setCellValue(targetStock.getContent());
cell2.setCellValue(targetStock.getPublishTime());

sheet.setColumnWidth((short)0,(short)4000);
sheet.setColumnWidth((short)1,(short)4000);
sheet.setColumnWidth((short)2,(short)4000);
}
}

//通过Response把数据以Excel格式保存
response.reset();
response.setContentType("application/msexcel;charset=UTF-8");
try{
response.addHeader("Content-Disposition","attachment;filename=\""
+newString(("用户意见信息表"+".xls").getBytes("GBK"),
"ISO8859_1")+"