生成EXCELlent

最新推荐文章于 2024-04-24 09:45:11 发布

icbcrenvectra

最新推荐文章于 2024-04-24 09:45:11 发布

阅读量127

点赞数

文章标签： string hashmap exception

本文链接：https://blog.csdn.net/icbcrenvectra/article/details/5869381

版权

static String CreadExcel(String Title,String [] headerCH,String [] headerEN,ArrayList DatList) throws Exception{
   String EXCELFile =  new String();
   EXCELFile=UniqueStringGenerator.getUniqueString()+".xls";
   EXCELFile="d://"+EXCELFile;
   WriteExcel ExcelOp = new WriteExcel();
   ExcelOp.WriteExcel(EXCELFile);
   ExcelOp.createNewSheet("页面一");
   ExcelOp.setTitle(Title,(short) 12,(short)12);
   ExcelOp.setField(headerCH,(short) 12,(short)0);
   for(int  record=0;record<DatList.size();record++){
    HashMap  MAP =(HashMap) DatList.get(record);
    String Ldate[] = new String[MAP.size()];
    for(int  HD=0;HD<headerEN.length ;HD++){
     Ldate[HD]=(String)MAP.get(headerEN[HD]);
    }
    ExcelOp.creatNewRow(Ldate);
   }
   ExcelOp.close();
   return EXCELFile;

  }

}