将数据写到Excel 中

/******导出数据****************************************************/
   String[] title = { "用户名", "信息费", "充值费", "升级费用 ", "广告招商费 ", "合计 " };
   try {  
        // 获得开始时间  
        long start = System.currentTimeMillis();  
        // 输出的excel的路径  
        String filePath = "/c:/1.xls";  
        // 创建Excel工作薄  
        WritableWorkbook wwb;  
        // 新建立一个jxl文件,即在C盘下生成test.xls  
        OutputStream os = new FileOutputStream(filePath);  
        wwb = Workbook.createWorkbook(os);  
        // 添加第一个工作表并设置第一个Sheet的名字  
        WritableSheet sheet = wwb.createSheet("费用统计", 0);  
        Label label;  
        for (int i = 0; i < title.length; i++) {  
          // Label(x,y,z)其中x代表单元格的第x+1列，第y+1行, 单元格的内容是y  
          // 在Label对象的子对象中指明单元格的位置和内容  
          label = new Label(i, 0, title[i]);  
          // 将定义好的单元格添加到工作表中  
          sheet.addCell(label);  
        }  
        Double imesSum=0.0;
        Double iabSum=0.0;
        Double iupSum=0.0;
        Double iadSum=0.0;
        Double itotSum=0.0;
        Double tSum=0.0;
       
        for (int i = 1; i <= list.size(); i++) {
         int j=0;
         Expensestat e=(Expensestat)list.get(i-1);
         label = new Label(j++, i, e.getUserName());//(x+1列，y+1行,值)
         sheet.addCell(label);
         if(e.getMsgPredMoneyOfSum()!=null){
          imesSum=e.getMsgPredMoneyOfSum();
         }
         jxl.write.Number mesSum = new jxl.write.Number(j++, i, imesSum);  
         sheet.addCell(mesSum);
         if(e.getAbredMoneyOfSum()!=null){
          iabSum=e.getAbredMoneyOfSum();
         }
         jxl.write.Number abSum = new jxl.write.Number(j++, i, iabSum);  
         sheet.addCell(abSum);
         if(e.getUpredMoneyOfSum()!=null){
          iupSum=e.getUpredMoneyOfSum();
         }
         jxl.write.Number upSum = new jxl.write.Number(j++, i, iupSum);  
         sheet.addCell(upSum);
         if(e.getAdredMoneyOfSum()!=null){
          iadSum=e.getAdredMoneyOfSum();
         }
         jxl.write.Number adSum = new jxl.write.Number(j++, i,iadSum);  
         sheet.addCell(adSum); 
         itotSum=imesSum+iabSum+iupSum+iadSum;
         tSum=tSum+itotSum;
         jxl.write.Number totSum = new jxl.write.Number(j++, i, itotSum);  
         sheet.addCell(totSum);
         if (i==list.size()) {
          label = new Label(j-1, i+1, "总计："+tSum);//(x+1列，y+1行,值)
          sheet.addCell(label);
    }
        }
        // 写入数据  
        wwb.write();  
        // 关闭文件  
        wwb.close();  
        long end = System.currentTimeMillis(); 
   } catch (Exception e) {  
        e.printStackTrace(); 
      }