網(wǎng)上搜集參考
public HSSFWorkbook getUserCardLogByCondition(List list,Integer total){
  HSSFWorkbook wb = new HSSFWorkbook();
  try{
      HSSFSheet sheet = wb.createSheet("吉林卡號(hào)數(shù)據(jù)統(tǒng)計(jì)");
      sheet.setColumnWidth((short)0, (short)4000);
      sheet.setColumnWidth((short)1, (short)4000);
            sheet.setColumnWidth((short)2, (short)4000);
            sheet.setColumnWidth((short)3, (short)4000);
            sheet.setColumnWidth((short)4, (short)4000);
            sheet.setColumnWidth((short)5, (short)4000);
            sheet.setColumnWidth((short)6, (short)5000);
            sheet.setColumnWidth((short)7, (short)5000);
            sheet.setColumnWidth((short)8, (short)5000);
          
            //格式設(shè)置
            HSSFCellStyle css = wb.createCellStyle();      
            css.setBorderBottom((short)1);          
            css.setBorderLeft((short)1);
            css.setBorderRight((short)1);
            css.setBorderTop((short)1);

            HSSFFont font = wb.createFont();  
            font.setFontHeightInPoints( (short) 24);  
            font.setFontName("宋體");  
          
            HSSFCellStyle style = wb.createCellStyle();
            style.setFont(font);
            style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

      HSSFRow row = sheet.createRow((short) 0);
      row.setHeight((short)600);
    
      HSSFCell cell = row.createCell((short) 0);
      cell.setCellStyle(style);
      cell.setCellValue(new HSSFRichTextString("吉林卡號(hào)數(shù)據(jù)統(tǒng)計(jì)"));
   
      sheet.addMergedRegion(new Region(0,(short)0,0,(short)8));
    
    
      row = sheet.createRow((short) 1);
      cell = row.createCell((short) 0);
    
      sheet.addMergedRegion(new Region(1,(short)0,1,(short)8));
    
  
    
      HSSFFont endfont = wb.createFont();  
      endfont.setFontHeightInPoints( (short) 12);  
      endfont.setFontName("宋體");
     
      HSSFCellStyle headstyle = wb.createCellStyle();
      headstyle.setFont(endfont);
      row = sheet.createRow((short) 2);
    
      String[] headTitle={"序列號(hào)","卡帳號(hào)","密碼","卡類型","點(diǎn)數(shù)","卡狀態(tài)","創(chuàng)建時(shí)間","激活時(shí)間","登陸時(shí)間"};
      for(int i=0;i<headTitle.length;i++){
       cell = row.createCell((short)i);
       cell.setCellStyle(headstyle);
       cell.setCellValue(new HSSFRichTextString(headTitle[i]));
      }
      for(int i=0;i<list.size();i++){
       UserCard userCard = (UserCard)list.get(i);
       row = sheet.createRow((short)(i+3));
       cell = row.createCell((short) 0);
       cell.setCellValue(new HSSFRichTextString(userCard.getId().toString()));
       cell = row.createCell((short) 1);
       cell.setCellValue(userCard.getUserName().toString());
       cell = row.createCell((short) 2);
       cell.setCellValue(userCard.getPassword().toString());
       cell = row.createCell((short) 3);
       cell.setCellValue(userCard.getTypeDes());
       cell = row.createCell((short) 4);
       cell.setCellValue(userCard.getValue().toString());
       cell = row.createCell((short) 5);
       cell.setCellValue(userCard.getStatusDes());
       cell = row.createCell((short) 6);
       cell.setCellValue(DateUtil.Format(userCard.getCreateTime(),"yyyy-HH-dd HH:mm:ss"));
       cell = row.createCell((short) 7);
       cell.setCellValue(DateUtil.Format(userCard.getActiveTime(),"yyyy-HH-dd HH:mm:ss"));
       cell = row.createCell((short) 8);
       cell.setCellValue(DateUtil.Format(userCard.getLoginTime(),"yyyy-HH-dd HH:mm:ss"));
      }
    
      row = sheet.createRow((short) (list.size()+6));
      cell = row.createCell((short) 0);
     
         
          
      HSSFCellStyle endstyle = wb.createCellStyle();
      endstyle.setFont(endfont);
      endstyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT);
           
      cell = row.createCell((short) 6);
      cell.setCellValue(new HSSFRichTextString("卡號(hào)合計(jì):"));
      cell.setCellStyle(endstyle);
      cell = row.createCell((short) 7);
      cell.setCellValue(total.toString());
      row = sheet.createRow((short) (list.size()+7));
      cell = row.createCell((short) 6);
     
      }catch(Exception ex){
       ex.printStackTrace();
     }
     return wb;
 }