JAVA 高级报表导出Excel

缺乏、安全感 2022-08-21 04:44 245阅读 0赞

有些时候简单的excel数据导出并不能真正满足我们的需求，有的时候我们导出之后的excel需要非常复杂，例如下面我们的这种的：

![Center][]

我们非常难于处理，下面我给大家介绍一种解决方案。

用到的jar包：

![Center 1][]

![Center 2][]

![Center 3][]

代码：

People.java

package entity;
    
    public class People {
    	
    	private int id;
    	private String name;
    	private String nickname;
    	private int age;
    	
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getNickname() {
    		return nickname;
    	}
    	public void setNickname(String nickname) {
    		this.nickname = nickname;
    	}
    	public int getAge() {
    		return age;
    	}
    	public void setAge(int age) {
    		this.age = age;
    	}
    	
    
    }

Export.java:

package 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;
    import entity.People;
    
    public class Export {
    	
    		public void export(){
    		
    	        List<People> list = getData();
    			String file=this.getClass().getClassLoader().getResource("")+"";
    			String files=file.substring(6, file.length()-16);
    			String templateFileName =files+"template/people.xls";	
    			long time = System.currentTimeMillis();
    			String destFileName =files+"outfiles/people"+time+".xls";
    			Map<String, List<People>> map = new HashMap<String, List<People>>();
    			map.put("people", list);
    			XLSTransformer transformer = new XLSTransformer();
    			try {
    				
    				transformer.transformXLS(templateFileName, map, destFileName);
    				
    			} catch (ParsePropertyException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			} catch (IOException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    		
    	}
    	
    	public static List<People> getData(){
    		
    		List<People> list = new ArrayList<People>();
    		
    		for (int i = 1;i<=10;i++){
    			
    			People p = new People();
    			p.setId(i);
    			p.setName("王晓明"+i);
    			p.setNickname("王晓明"+i);
    			p.setAge(i+1);
    			
    			list.add(p);
    		}
    		return list;
    		
    	}
    	
    	
    	public static void main(String[] args) {
    		
    		
    		new Export().export();
    		
    	}
    
    }

运行代码之后:

![Center 4][]

源码下载链接:[http://download.csdn.net/detail/gaoxuaiguoyi/9462598][http_download.csdn.net_detail_gaoxuaiguoyi_9462598]

[Center]: /images/20220731/c1812b644b2842da9addb43ce9e16e71.png
[Center 1]: /images/20220731/c8feb6a35ddd44939d64591204922988.png
[Center 2]: /images/20220731/166ffe1b4ce24dc197b0201361684e79.png
[Center 3]: /images/20220731/e38ebafad2824c14b2efe261a1b46110.png
[Center 4]: /images/20220731/92b7c7b80121466c940dcd1c3090e515.png
[http_download.csdn.net_detail_gaoxuaiguoyi_9462598]: http://download.csdn.net/detail/gaoxuaiguoyi/9462598