fastexcel

quickly department excel file

License	The Apache Software License, Version 2.0
Categories	fastexcel Business Logic Libraries Documents Processing
GroupId	com.github.sd4324530
ArtifactId	fastexcel
Last Version	0.0.4
Release Date	Sep 22, 2016
Type	jar
Description	fastexcel quickly department excel file
Source Code Management	https://github.com/sd4324530/fastexcel.git

Download fastexcel

Filename	Size
fastexcel-0.0.4.pom
fastexcel-0.0.4.jar	9 KB
fastexcel-0.0.4-sources.jar	4 KB
fastexcel-0.0.4-javadoc.jar	37 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/ -->
<dependency>
    <groupId>com.github.sd4324530</groupId>
    <artifactId>fastexcel</artifactId>
    <version>0.0.4</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/
implementation 'com.github.sd4324530:fastexcel:0.0.4'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/
implementation ("com.github.sd4324530:fastexcel:0.0.4")

Apache Buildr

'com.github.sd4324530:fastexcel:jar:0.0.4'

Apache Ivy

<dependency org="com.github.sd4324530" name="fastexcel" rev="0.0.4">
  <artifact name="fastexcel" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.github.sd4324530', module='fastexcel', version='0.0.4')
)

Scala SBT

libraryDependencies += "com.github.sd4324530" % "fastexcel" % "0.0.4"

Leiningen

[com.github.sd4324530/fastexcel "0.0.4"]

Dependencies

compile (2)

Group / Artifact	Type	Version
org.apache.poi : poi-ooxml	jar	3.15
org.slf4j : slf4j-api	jar	1.7.21

test (2)

Group / Artifact	Type	Version
junit : junit	jar	4.12
ch.qos.logback : logback-classic	jar	1.1.7

Project Modules

There are no modules declared in this project.

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

Versions

Version
0.0.4 Sep 22, 2016
0.0.3 Sep 29, 2015
0.0.2 Mar 15, 2015
0.0.1 Dec 28, 2014