public class ErrorCondition { 
  private String name; // 姓名 
  private String idCard; // 身份證 
  private String status; // 錯(cuò)誤狀態(tài) 
  private String message; // 錯(cuò)誤信息 
 
  ErrorCondition(String name,String idCard,String status,String message){ 
    this.name = name; 
    this.idCard = idCard; 
    this.status = status; 
    this.message = message; 
  } 
   
  public String getName() { 
    return name; 
  } 
 
  public void setName(String name) { 
    this.name = name; 
  } 
 
  public String getIdCard() { 
    return idCard; 
  } 
 
  public void setIdCard(String idCard) { 
    this.idCard = idCard; 
  } 
 
  public String getStatus() { 
    return status; 
  } 
 
  public void setStatus(String status) { 
    this.status = status; 
  } 
 
  public String getMessage() { 
    return message; 
  } 
 
  public void setMessage(String message) { 
    this.message = message; 
  } 
 
} 

public class ExportErrorExcel { 
  public static void main(String[] args) { 
    //第一步創(chuàng)建workbook 
    HSSFWorkbook wb = new HSSFWorkbook(); 
     
    //第二步創(chuàng)建sheet 
    HSSFSheet sheet = wb.createSheet("身份證錯(cuò)誤信息"); 
     
    //第三步創(chuàng)建行row:添加表頭0行 
    HSSFRow row = sheet.createRow(0); 
    HSSFCellStyle style = wb.createCellStyle();   
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); //居中 
     
     
    //第四步創(chuàng)建單元格 
    HSSFCell cell = row.createCell(0);     //第一個(gè)單元格 
    cell.setCellValue("姓名");         //設(shè)定值 
    cell.setCellStyle(style);          //內(nèi)容居中 
     
    cell = row.createCell(1);          //第二個(gè)單元格   
    cell.setCellValue("身份證"); 
    cell.setCellStyle(style); 
     
    cell = row.createCell(2);          //第三個(gè)單元格  
    cell.setCellValue("錯(cuò)誤狀態(tài)"); 
    cell.setCellStyle(style); 
     
    cell = row.createCell(3);          //第四個(gè)單元格  
    cell.setCellValue("錯(cuò)誤信息"); 
    cell.setCellStyle(style); 
     
    //第五步插入數(shù)據(jù) 
    List<ErrorCondition> list = ExportErrorExcel.getErrorCondition(); 
    for (int i = 0; i < list.size(); i++) { 
      ErrorCondition errorCondition = list.get(i); 
      //創(chuàng)建行 
      row = sheet.createRow(i+1); 
      //創(chuàng)建單元格并且添加數(shù)據(jù) 
      row.createCell(0).setCellValue(errorCondition.getName()); 
      row.createCell(1).setCellValue(errorCondition.getIdCard()); 
      row.createCell(2).setCellValue(errorCondition.getStatus()); 
      row.createCell(3).setCellValue(errorCondition.getMessage()); 
    } 
     
    //第六步將生成excel文件保存到指定路徑下 
    try { 
      FileOutputStream fout = new FileOutputStream("D:\\errorCondition.xls"); 
      wb.write(fout); 
      fout.close(); 
    } catch (IOException e) { 
      e.printStackTrace(); 
    } 
     
    System.out.println("Excel文件生成成功..."); 
  } 
   
  public static List<ErrorCondition> getErrorCondition(){ 
    List<ErrorCondition> list = new ArrayList<ErrorCondition>(); 
     
    ErrorCondition r1 = new ErrorCondition("張三", "4306821989021611", "L", "長(zhǎng)度錯(cuò)誤"); 
    ErrorCondition r2 = new ErrorCondition("李四", "430682198902191112","X", "校驗(yàn)錯(cuò)誤"); 
    ErrorCondition r3 = new ErrorCondition("王五", "", "N", "身份證信息為空"); 
     
    list.add(r1); 
    list.add(r2); 
    list.add(r3); 
     
    return list; 
  } 
} 

public class ExcelImageTest { 
  public static void main(String[] args) { 
     FileOutputStream fileOut = null;   
     BufferedImage bufferImg = null;   
    //先把讀進(jìn)來的圖片放到一個(gè)ByteArrayOutputStream中，以便產(chǎn)生ByteArray  
    try { 
      ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();   
      bufferImg = ImageIO.read(new File("F:/圖片/照片/無名氏/小昭11.jpg"));   
      ImageIO.write(bufferImg, "jpg", byteArrayOut); 
       
      HSSFWorkbook wb = new HSSFWorkbook();   
      HSSFSheet sheet1 = wb.createSheet("test picture");  
      //畫圖的頂級(jí)管理器，一個(gè)sheet只能獲取一個(gè)（一定要注意這點(diǎn)） 
      HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();   
      //anchor主要用于設(shè)置圖片的屬性 
      HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 255, 255,(short) 1, 1, (short) 5, 8);   
      anchor.setAnchorType(3);   
      //插入圖片  
      patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));  
      fileOut = new FileOutputStream("D:/測(cè)試Excel.xls");   
      // 寫入excel文件   
       wb.write(fileOut);   
       System.out.println("----Excle文件已生成------"); 
    } catch (Exception e) { 
      e.printStackTrace(); 
    }finally{ 
      if(fileOut != null){ 
         try { 
          fileOut.close(); 
        } catch (IOException e) { 
          e.printStackTrace(); 
        } 
      } 
    } 
  } 
} 

HSSFClientAnchor anchor1 = new HSSFClientAnchor(0, 0, 1023,100,(short) 1, 1, (short)5, 8); 
      HSSFClientAnchor anchor2 = new HSSFClientAnchor(0, 0, 1023,100,(short) 1, 9, (short)5, 16); 
      
      //插入圖片 
      patriarch.createPicture(anchor1, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG)); 
      patriarch.createPicture(anchor2, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));