fastexcel

quickly department excel file

License

License

Categories

Categories

fastexcel Business Logic Libraries Documents Processing
GroupId

GroupId

com.github.sd4324530
ArtifactId

ArtifactId

fastexcel
Last Version

Last Version

0.0.4
Release Date

Release Date

Type

Type

jar
Description

Description

fastexcel
quickly department excel file
Source Code Management

Source Code Management

https://github.com/sd4324530/fastexcel.git

Download fastexcel

How to add to project

<!-- https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/ -->
<dependency>
    <groupId>com.github.sd4324530</groupId>
    <artifactId>fastexcel</artifactId>
    <version>0.0.4</version>
</dependency>
// https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/
implementation 'com.github.sd4324530:fastexcel:0.0.4'
// https://jarcasting.com/artifacts/com.github.sd4324530/fastexcel/
implementation ("com.github.sd4324530:fastexcel:0.0.4")
'com.github.sd4324530:fastexcel:jar:0.0.4'
<dependency org="com.github.sd4324530" name="fastexcel" rev="0.0.4">
  <artifact name="fastexcel" type="jar" />
</dependency>
@Grapes(
@Grab(group='com.github.sd4324530', module='fastexcel', version='0.0.4')
)
libraryDependencies += "com.github.sd4324530" % "fastexcel" % "0.0.4"
[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
0.0.3
0.0.2
0.0.1