jxl实际例子

zhangjidong2005

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();
}