jxl实际例子
try{
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();// 清空输出流
response.setHeader("Content-disposition", "attachment; filename=vipAmountReport.xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
WritableWorkbook wbook = Workbook.createWorkbook(os); // 建立excel文件
String tmptitle = "vipAmount"; // 标题
WritableSheet wsheet = wbook.createSheet(tmptitle, 0); // sheet名称
Locale locale = (Locale) request.getSession().getAttribute(Globals.LOCALE_KEY);
MessageResources message = getResources(request);
// 开始生成主体内容
wsheet.addCell(new Label(0, 0, message.getMessage(locale,"manager.report.memberGroup.vipcode")));
wsheet.addCell(new Label(1, 0, message.getMessage(locale,"manager.report.memberGroup.vipcardcode")));
wsheet.addCell(new Label(2, 0, message.getMessage(locale,"manager.report.vipAmount.amount")));
for(int i=0;i<vipAmountList.size();i++)
{
// Label(列号,行号,内容,风格)
Map mp =(Map) vipAmountList.get(i);
for(int j=1;j<4;j++){
int rownum = i+1;
wsheet.addCell(new Label(j-1, rownum, mp.get(j)==null?null:mp.get(j).toString()));
}
}
// 主体内容生成结束
wbook.write(); // 写入文件
wbook.close();
os.close(); // 关闭流
}catch(Exception ex){
ex.printStackTrace();
}
页:
[1]