java导出excel简单实例

   

  
    HSSFWorkbook work = new HSSFWorkbook();
    //创建一张表
    HSSFSheet sheet = work.createSheet("项目固定资产投入情况表");
    //创建行
    HSSFRow rows = null;
    //创建单元格
    HSSFCell cell = null;
    rows = sheet.createRow(0);
    cell = rows.createCell((short)0);
    cell.setCellValue("年份");
    cell = rows.createCell((short)1);
    cell.setCellValue("月份");
    cell = rows.createCell((short)2);
    cell.setCellValue("状态");
    cell = rows.createCell((short)3);
    cell.setCellValue("提交时间");
    cell = rows.createCell((short)4);
    cell.setCellValue("备注");
    //10行3列
    for(short r = 0;r<list.size();r++){
     rows = sheet.createRow(r+1);
     cell = rows.createCell((short)0);
     cell.setCellValue(list.get(r).getId().getNian());
     cell = rows.createCell((short)1);
     cell.setCellValue(list.get(r).getId().getYue());
     cell = rows.createCell((short)2);
     cell.setCellValue(list.get(r).getIsSubmit());
     cell = rows.createCell((short)3);
     cell.setCellValue(new SimpleDateFormat().format(list.get(r).getSubmitDate()));
     cell = rows.createCell((short)4);
     cell.setCellValue(list.get(r).getRemarks());
    
    
    }
    ByteArrayOutputStream arrayIo=new ByteArrayOutputStream();
      try {
    work.write(arrayIo);
   } catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
      byte[] by=arrayIo.toByteArray();
         InputStream is = new  ByteArrayInputStream(by);
         if(arrayIo!=null){
          try {
     arrayIo.close();
    } catch (IOException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
         }
  return is;