Java生成和读取Excle文件之JXL框架辅助工具

在程序项目开发中，无论是Android还是Java，在很多地方都会使用到Excle表格作为数据的存储方式，这就避免不了程序对Excle文件的操作。
问题：目前，无论是JXL还是POI，对Excel的操作都是比较原始的，用户无法使用这些框架代码直接读取Excle并相应相应的数据实体（Entity），也无法直接将数据实体写入到Excle文件中去。
本文章要介绍的是一个对JXL框架进行封装，实现读取Excle文件数据并生成相应的Entity对象，实现直接将Entity数据写入到Excellent文件中。

JXLUtil框架功能
1、读取Excle数据，生成相应的Entity
2、将Entity数据直接写入到Excle文件中
注意：Entity支持日期属性、支持继承、支持包含其他Entity

下面是框架的一个使用Demo
作者实体AuthorEntity

package com.winway.jxl.test;import com.winway.jxl.anomotion.CellColum;public class AuthorEntity {    @CellColum(headerName = "作者", index = 0)    private String name;    @CellColum(headerName = "国籍", index = 1)    private String country;    @CellColum(headerName = "性别", index = 2)    private String sex;    @CellColum(headerName = "出生年月", index = 3)    private String birth;    @CellColum(headerName = "年龄", index = 4)    private int age;    @CellColum(headerName = "学历", index = 5)    private String edu;    @CellColum(headerName = "简介", index = 6)    private String product;    public AuthorEntity() {        super();    }    public AuthorEntity(String country, String name, String sex, String birth, int age, String edu,            String product) {        super();        this.country = country;        this.name = name;        this.sex = sex;        this.birth = birth;        this.age = age;        this.edu = edu;        this.product = product;    }    public String getCountry() {        return country;    }    public void setCountry(String country) {        this.country = country;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getSex() {        return sex;    }    public void setSex(String sex) {        this.sex = sex;    }    public String getBirth() {        return birth;    }    public void setBirth(String birth) {        this.birth = birth;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    public String getEdu() {        return edu;    }    public void setEdu(String edu) {        this.edu = edu;    }    public String getProduct() {        return product;    }    public void setProduct(String product) {        this.product = product;    }    @Override    public String toString() {        // TODO Auto-generated method stub        return name + "," + sex + "," + birth + "," + country;    }}

书本BookEntity

package com.winway.jxl.test;import com.winway.jxl.anomotion.CellColum;import com.winway.jxl.anomotion.CellEntity;public class BookEntity {    @CellColum(headerName = "书名", index = 0)    private String name;    @CellEntity(offset = 8)    private AuthorEntity author;    @CellColum(headerName = "出版社", index = 1)    private String publicCompony;    @CellColum(headerName = "语种", index = 2)    private String laguage;    @CellColum(headerName = "价格", index = 3)    private float price;    @CellColum(headerName = "类别", index = 4)    private String type;    @CellColum(headerName = "简介", index = 5)    private String product;    @CellColum(headerName = "存货", index = 6)    private boolean has;    public BookEntity() {        super();    }    public BookEntity(String name, AuthorEntity author, String publicCompony, String laguage,            float price, String type, String product, boolean has) {        super();        this.name = name;        this.author = author;        this.publicCompony = publicCompony;        this.laguage = laguage;        this.price = price;        this.type = type;        this.product = product;        this.has = has;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public AuthorEntity getAuthor() {        return author;    }    public void setAuthor(AuthorEntity author) {        this.author = author;    }    public String getPublicCompony() {        return publicCompony;    }    public void setPublicCompony(String publicCompony) {        this.publicCompony = publicCompony;    }    public String getLaguage() {        return laguage;    }    public void setLaguage(String laguage) {        this.laguage = laguage;    }    public float getPrice() {        return price;    }    public void setPrice(float price) {        this.price = price;    }    public String getType() {        return type;    }    public void setType(String type) {        this.type = type;    }    public String getProduct() {        return product;    }    public void setProduct(String product) {        this.product = product;    }    public boolean isHas() {        return has;    }    public void setHas(boolean has) {        this.has = has;    }    @Override    public String toString() {        return name + "," + price + "," + has + "," + author.toString();    }}

主类

package com.winway.jxl.test;import java.util.ArrayList;import java.util.List;import com.winway.jxl.core.ExcelReader;import com.winway.jxl.core.ExcelWriter;public class TestXN2 {    static void write() throws Exception {        ExcelWriter<BookEntity> writer = new ExcelWriter<>("D:/test.xls");        ArrayList<BookEntity> list = new ArrayList<>();        AuthorEntity author = new AuthorEntity("中华人民共和国", "无名团体", "男女", "1960-12", 56, "本科",                "FFFFFFFFFFFFFFFFFFFFFFFFFFFF");        BookEntity book = new BookEntity("十万个为什么", author, "国家教育出版社", "中文", 12.80f, "儿童教育读物",                "《十万个为什么》启发儿童积极思考、大胆想象，充分发挥自己的智慧和创造力。为什么是每个人童年的主旋律，跳动着无数天真好奇的音符，不要小看了孩子们不断提出 的一个个为什么，因为这是激发他们求知举的重要推动力，让孩子们获得最准确的科学知识，增长智慧，激发孩子热爱科学，探索科学的热情，瞪大好奇的双眼，刨根部底找答案！小小的头脑在解答中渐渐成长。",                true);        int max = 10;        for (int i = 0; i < max; i++) {            list.add(book);        }        writer.writeExcel(list);    }    static void read() throws Exception {        ExcelReader<BookEntity> reader = new ExcelReader<>(BookEntity.class, "D:/test.xls");        List<BookEntity> readExcel = reader.readExcel(0, 0);        for (BookEntity bookEntity : readExcel) {            System.out.println(bookEntity.toString());        }    }    public static void main(String[] args) throws Exception {        write();        read();    }}

以下是运行结果

以下是项目工程的下载，包含JXLUtil.jar包和源码
源码下载