使用模板导出-- 简单实例(POI)

港控/mmm° 2022-05-15 00:16 159阅读 0赞

注意：POI的jar包需要3.2及以上版本才具有此模板导出功能（且POI版本不向下兼容）

*  Student.java

package cn.chen.demo;
    public class Student { 
         private int num;
         private String name;
    
         public Student(int num, String name) {
               super();
               this.num = num;
               this.name = name;
         }
         public int getNum() {
               return num;
         }
         public void setNum(int num) {
               this.num = num;
         }
         public String getName() {
               return name;
         }
         public void setName(String name) {
               this.name = name;
         }
    }

*  ExcelUtil.java

package cn.chen.demo;
    import java.io.IOException;
    import java.util.ArrayList;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    import net.sf.jxls.exception.ParsePropertyException;
    import net.sf.jxls.transformer.XLSTransformer;
    public class ExcelUtil { 
    
    
        public static void main(String[] args) { 
            List<Student> list = new ArrayList<Student>(); 
            list.add(new Student(88,"小陈")); 
            list.add(new Student(99,"咩咩")); 
            list.add(new Student(66,"喵喵")); 
            list.add(new Student(22,"在在")); 
            for(Student l:list){
               System.out.println(l.getNum()+","+l.getName());
            }
            Map beanParams = new HashMap(); 
            beanParams.put("list", list);
    
            String srcFilePath = "f:/template.xls";
            String destFilePath = "f:/test.xls";
            XLSTransformer former = new XLSTransformer();
            try {
    
                    former.transformXLS(srcFilePath, beanParams, destFilePath);
    
               } catch (ParsePropertyException e) {
                    e.printStackTrace();
               } catch (IOException e) {
                    e.printStackTrace();
               }
        } 
    }

template.xls （那里是$\{l.name\} ）

<table> 
 <thead> 
  <tr> 
   <th>学号</th> 
   <th>姓名</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>&lt;jx:forEach items=”${list}” var=”l”&gt;</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>${l.num}</td> 
   <td>￥{l.name}</td> 
  </tr> 
  <tr> 
   <td>&lt;/jx:forEach&gt;</td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>