Spreadsheet Mapper - Core


License

License

GroupId

GroupId

com.supwisdom
ArtifactId

ArtifactId

spreadsheet-mapper-core
Last Version

Last Version

1.0.9
Release Date

Release Date

Type

Type

jar
Description

Description

Spreadsheet Mapper - Core
Spreadsheet Mapper - Core
Project URL

Project URL

https://github.com/supwisdom/spreadsheet-mapper

Download spreadsheet-mapper-core

How to add to project

<!-- https://jarcasting.com/artifacts/com.supwisdom/spreadsheet-mapper-core/ -->
<dependency>
    <groupId>com.supwisdom</groupId>
    <artifactId>spreadsheet-mapper-core</artifactId>
    <version>1.0.9</version>
</dependency>
// https://jarcasting.com/artifacts/com.supwisdom/spreadsheet-mapper-core/
implementation 'com.supwisdom:spreadsheet-mapper-core:1.0.9'
// https://jarcasting.com/artifacts/com.supwisdom/spreadsheet-mapper-core/
implementation ("com.supwisdom:spreadsheet-mapper-core:1.0.9")
'com.supwisdom:spreadsheet-mapper-core:jar:1.0.9'
<dependency org="com.supwisdom" name="spreadsheet-mapper-core" rev="1.0.9">
  <artifact name="spreadsheet-mapper-core" type="jar" />
</dependency>
@Grapes(
@Grab(group='com.supwisdom', module='spreadsheet-mapper-core', version='1.0.9')
)
libraryDependencies += "com.supwisdom" % "spreadsheet-mapper-core" % "1.0.9"
[com.supwisdom/spreadsheet-mapper-core "1.0.9"]

Dependencies

compile (10)

Group / Artifact Type Version
org.jodd : jodd-bean jar 3.8.1
org.apache.poi : poi jar 3.15
org.apache.poi : poi-ooxml jar 3.15
org.apache.commons : commons-lang3 jar 3.5
org.apache.commons : commons-collections4 jar 4.1
commons-io : commons-io jar 2.5
commons-beanutils : commons-beanutils jar 1.9.3
org.slf4j : slf4j-api jar 1.7.21
ch.qos.logback : logback-core Optional jar 1.1.7
ch.qos.logback : logback-classic Optional jar 1.1.7

test (1)

Group / Artifact Type Version
org.testng : testng jar 6.1.1

Project Modules

There are no modules declared in this project.

spreadsheet-mapper

Build Status codecov Maven Central License

Maven

<dependency>
    <groupId>com.supwisdom</groupId>
    <artifactId>spreadsheet-mapper-core</artifactId>
    <version>1.0.9</version>
</dependency>

<!-- (可选)对joda的支持 -->
<dependency>
    <groupId>com.supwisdom</groupId>
    <artifactId>spreadsheet-mapper-joda</artifactId>
    <version>1.0.9</version>
</dependency>

<!-- (可选)对java8的支持 -->
<dependency>
    <groupId>com.supwisdom</groupId>
    <artifactId>spreadsheet-mapper-java8</artifactId>
    <version>1.0.9</version>
</dependency>

Gradle

compile 'com.supwisdom:spreadsheet-mapper-core:1.0.9'
compile 'com.supwisdom:spreadsheet-mapper-java8:1.0.9'
compile 'com.supwisdom:spreadsheet-mapper-joda:1.0.9'

项目一览

用excel导入、导出数据是企业软件里很常见的需求,但是要实现好导入、导出并非易事,主要原因在于excel导入或导出并非简单的对数据库表的操作,往往牵涉到校验、转换等工作。 本项目希望提供一套方便好用的库,能够使得此类需求实现起来更为便捷。

spreadsheet-mapper-core

本包提供了excel文件导入、导出的基础工具。

和导入相关的工具:

  1. package f2w:读取excel文件并生成Workbook。
  2. package validation:Workbook的校验工具。
  3. package w2o:将Workbook转换成Object的工具。

和导出相关的工具:

  1. package o2w:将Object转换成Workbook。
  2. package w2f:将Workbook写到excel文件。
  3. package m2f:将Message(一般是校验失败消息)追加到excel文件。

spreadsheet-mapper-joda

在core的基础上,提供

  1. package o2w:添加joda-time数据类型的支持。
  2. package w2o:添加joda-time数据类型的支持。

spreadsheet-mapper-java8

在core的技术上,提供对

  1. package o2w:添加java 8 time数据类型的支持。
  2. package w2o:添加java 8 time数据类型的支持。
  3. package validation:添加java 8 lambda表达式的支持。

例子

  1. 读取excel文件并生成Workbook的例子:WorkbookReaderExample
  2. 校验workbook的例子:WorkbookValidatorExample WorkbookValidatorWithValidatorBuilderExample
  3. 将Workbook转换成Object的例子:Workbook2ObjectComposerExample
  4. 将Object转换成Workbook的例子:Object2WorkbookExample
  5. 将Workbook写到excel文件的例子:Workbook2ExcelWriterExample
  6. 将Message写到excel文件的例子:Message2ExcelWriterExample

License

Released under the Apache 2.0 license.

com.supwisdom

上海树维

Versions

Version
1.0.9
1.0.8
1.0.7
1.0.6
1.0.5
1.0.4
1.0.3
1.0.2
1.0.1
1.0.0