XLSBeans

XLSBeans is a library for mapping Excel sheets to POJOs.

License	The Apache Software License, Version 2.0
Categories	SBE Data Data Structures
GroupId	com.github.takezoe
ArtifactId	xlsbeans
Last Version	1.2.7
Release Date	Feb 10, 2019
Type	jar
Description	XLSBeans XLSBeans is a library for mapping Excel sheets to POJOs.
Project URL	http://maven.apache.org
Source Code Management	https://github.com/takezoe/xlsbeans

Download xlsbeans

Filename	Size
xlsbeans-1.2.7.pom
xlsbeans-1.2.7.jar	85 KB
xlsbeans-1.2.7-sources.jar	52 KB
xlsbeans-1.2.7-javadoc.jar	435 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.github.takezoe/xlsbeans/ -->
<dependency>
    <groupId>com.github.takezoe</groupId>
    <artifactId>xlsbeans</artifactId>
    <version>1.2.7</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.github.takezoe/xlsbeans/
implementation 'com.github.takezoe:xlsbeans:1.2.7'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.github.takezoe/xlsbeans/
implementation ("com.github.takezoe:xlsbeans:1.2.7")

Apache Buildr

'com.github.takezoe:xlsbeans:jar:1.2.7'

Apache Ivy

<dependency org="com.github.takezoe" name="xlsbeans" rev="1.2.7">
  <artifact name="xlsbeans" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.github.takezoe', module='xlsbeans', version='1.2.7')
)

Scala SBT

libraryDependencies += "com.github.takezoe" % "xlsbeans" % "1.2.7"

Leiningen

[com.github.takezoe/xlsbeans "1.2.7"]

Dependencies

compile (4)

Group / Artifact	Type	Version
net.sourceforge.jexcelapi : jxl	jar	2.6.12
org.apache.poi : poi	jar	3.6
org.apache.poi : poi-ooxml	jar	3.6
ognl : ognl	jar	3.1.4

test (1)

Group / Artifact	Type	Version
junit : junit	jar	3.8.1

Project Modules

There are no modules declared in this project.

XLSBeans

XLSBeans is a Java library for mapping Excel sheets to POJO.

Setup

To use XLSBeans, add the following dependency to your pom.xml:

<dependencies>
  <dependency>
    <groupId>com.github.takezoe</groupId>
    <artifactId>xlsbeans</artifactId>
    <version>1.2.7</version>
  </dependency>
</dependencies>

Getting Started

For example, here is one Excel sheet.

Map this Excel sheet to POJO using @HorizontalRecords and @LabelledCell.

@Sheet(name="Users")
public class UserList {

  @LabelledCell(label="Title", type=LabelledCellType.Right)
  public String title;

  @HorizontalRecords(tableLabel="User list", recordClass=User.class)
  public List<User> users;

}

And the following is the record class. Properties of the record class is mapped to columns by @Column.

public class User {

  @Column(columnName="ID")
  public int id;

  @Column(columnName="Name")
  public String name;

  @Column(columnName="Gender", merged=true)
  public String gender;

}

You can get the mapped POJO using XLSBeans#load() like following:

UserList userList = (UserList)new XLSBeans().load(
  new FileInputStream("example.xls"), UserList.class);

Documentation

See more details in http://amateras.sourceforge.jp/site/xlsbeans/howtouse.html (in Japanese)

Versions

Version
1.2.7 Feb 10, 2019
1.2.6 Apr 21, 2018