commons-excel

java commons-excel

License	License The Apache License, Version 2.0
GroupId	GroupId me.saro
ArtifactId	ArtifactId commons-excel
Last Version	Last Version 4.0.0.0
Release Date	Release Date Jun 23, 2019
Type	Type jar
Description	Description commons-excel java commons-excel
Project URL	Project URL https://saro.me
Project Organization	Project Organization SARO

Download commons-excel

Filename	Size
commons-excel-4.0.0.0.pom
commons-excel-4.0.0.0.jar	14 KB
commons-excel-4.0.0.0-sources.jar	8 KB
commons-excel-4.0.0.0-javadoc.jar	410 KB
Browse

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/me.saro/commons-excel/ -->
<dependency>
    <groupId>me.saro</groupId>
    <artifactId>commons-excel</artifactId>
    <version>4.0.0.0</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/me.saro/commons-excel/
implementation 'me.saro:commons-excel:4.0.0.0'

Gradle Kotlin

// https://jarcasting.com/artifacts/me.saro/commons-excel/
implementation ("me.saro:commons-excel:4.0.0.0")

Apache Buildr

'me.saro:commons-excel:jar:4.0.0.0'

Apache Ivy

<dependency org="me.saro" name="commons-excel" rev="4.0.0.0">
  <artifact name="commons-excel" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='me.saro', module='commons-excel', version='4.0.0.0')
)

Scala SBT

libraryDependencies += "me.saro" % "commons-excel" % "4.0.0.0"

Leiningen

[me.saro/commons-excel "4.0.0.0"]

Dependencies

compile (3)

Group / Artifact	Type	Version
org.apache.poi : poi	jar	4.1.0
org.apache.poi : poi-ooxml	jar	4.1.0
me.saro : commons	jar	4.0.3

provided (1)

Group / Artifact	Type	Version
org.projectlombok : lombok	jar	1.18.8

test (2)

Group / Artifact	Type	Version
org.junit.jupiter : junit-jupiter-api	jar	5.4.2
org.junit.jupiter : junit-jupiter-engine	jar	5.4.2

Project Modules

There are no modules declared in this project.

saro commons

QUICK START

maven

<dependency>
  <groupId>me.saro</groupId>
  <artifactId>commons-excel</artifactId>
  <version>4.0.0.0</version>
</dependency>

gradle

compile 'me.saro:commons-excel:4.0.0.0'

repository

see

가리사니 개발자공간

Structure

Excel

me.saro.commons.excel.Excel

Excel.create() : Excel
Excel.createBulkExcel() : Excel
Excel.open(File) : Excel
autoSizeColumn() : Excel
autoSizeColumn(int) : Excel
getCell(String) : ExcelCell
getCell(int, int) : ExcelCell
getPoiSheet() : Sheet
getRow() : ExcelRow
getRow(int) : ExcelRow
isBulk() : boolean
moveNextRow() : Excel
moveSheet(int) : Excel
output(OutputStream) : Excel
readPivotTable(String, int, ThrowableFunction<List<ExcelCell>, R>) : List<R>
readPivotTable(String, int, int, ThrowableFunction<List<ExcelCell>, R>) : List<R>
readTable(String, int, ThrowableFunction<List<ExcelCell>, R>) : List<R>
readTable(String, int, int, ThrowableFunction<List<ExcelCell>, R>) : List<R>
save(File, boolean) : Excel
writeHorizontalList(String, Collection<Object>) : Excel
writePivotTable(String, Collection<String>, List<T>) : Excel
writeTable(String, Collection<String>, List<T>) : Excel
writeVerticalList(String, Collection<Object>) : Excel

ExcelRow

me.saro.commons.excel.ExcelRow

ExcelRow.toColumnNameByRowIndex(int) : String
ExcelRow.toRowIndex(String) : int
getCell() : ExcelCell
getCell(int) : ExcelCell
getNextRow() : ExcelRow
getPoiRow(boolean) : Row
isEmpty() : boolean
moveNextCell() : ExcelRow

ExcelCell

me.saro.commons.excel.ExcelCell

ExcelCell.toCellIndex(String) : int
ExcelCell.toColumnName(int, int) : String
ExcelCell.toColumnNameByCellIndex(int) : String
ExcelCell.toDate(Cell, Date) : Date
ExcelCell.toDouble(Cell) : double
ExcelCell.toDouble(Cell, double) : double
ExcelCell.toRowCellIndex(String) : int[]
ExcelCell.toString(Cell, String) : String
getDateValue(Date) : Date
getDoubleValue() : double
getDoubleValue(double) : double
getFloatValue() : float
getFloatValue(float) : float
getIntValue() : int
getIntValue(int) : int
getIntegerStringValue(long) : String
getLongValue() : long
getLongValue(long) : long
getNextCell() : ExcelCell
getNextRowCell() : ExcelCell
getPoiCell(boolean) : Cell
getStringValue() : String
getStringValue(String) : String
isEmpty() : boolean
set(Object) : ExcelCell

SARO Lab

An open source library repository operated by SARO

Versions

Version
4.0.0.0 Jun 23, 2019