91 Star 190 Fork 66

sd4324530 / fastexcel

Create your Gitee Account
Explore and code with more than 8 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README.md

fastexcel

作者:peiyu
我的微博
QQ:125331682

快速简单读取excel数据,将Apache POI进行了薄封装,基于注解,更加易于使用

#使用样例

FastExcel fastExcel = new FastExcel("E:/data.xlsx");
        fastExcel.setSheetName("活动信息数据");
        List<MyTest> tests = fastExcel.parse(MyTest.class);
        if(null != tests && !tests.isEmpty()) {
            for(MyTest myTest : tests) {
                LOG.debug("记录:{}", myTest.toString());
            }
        } else {
            LOG.debug("没有结果");
        }

映射类

 public class MyTest {

    @MapperCell(cellName = "名称")
    private String name;

    @MapperCell(cellName = "联系电话")
    private String phone;

    @MapperCell(cellName = "地址")
    private String address;

    @MapperCell(cellName = "一级分类ID")
    private int type;

    @MapperCell(cellName = "经度")
    private double lat;

}

Maven 项目引入

<dependency>
    <groupId>com.github.sd4324530</groupId>
    <artifactId>fastexcel</artifactId>
    <version>0.0.4</version>
</dependency>

开源协议

Apache License

About

快速简单读取excel数据 expand collapse
Java
Cancel

Releases

No release

fastexcel

Contributors

All

Activities

Load More
can not load any more
Java
1
https://gitee.com/pyinjava/fastexcel.git
git@gitee.com:pyinjava/fastexcel.git
pyinjava
fastexcel
fastexcel
master

Search

E71a60c3 8189591 Df7b7c6b 8189591