JarCasting
JarCasting JarCasting

report-excel

Report Excel

Лицензия

Лицензия
Группа

Группа

com.github.bld-commons.excel
Идентификатор

Идентификатор

report-excel
Последняя версия

Последняя версия

2.0.5
Дата

Дата
Тип

Тип

jar
Описание

Описание

report-excel
Report Excel

Скачать report-excel

Имя Файла Размер
report-excel-2.0.5.pom
report-excel-2.0.5.jar 36 MB
report-excel-2.0.5-sources.jar 2 KB
report-excel-2.0.5-javadoc.jar 22 KB
Обзор

Как подключить последнюю версию

<!-- https://jarcasting.com/artifacts/com.github.bld-commons.excel/report-excel/ -->
<dependency>
    <groupId>com.github.bld-commons.excel</groupId>
    <artifactId>report-excel</artifactId>
    <version>2.0.5</version>
</dependency>
// https://jarcasting.com/artifacts/com.github.bld-commons.excel/report-excel/
implementation 'com.github.bld-commons.excel:report-excel:2.0.5'
// https://jarcasting.com/artifacts/com.github.bld-commons.excel/report-excel/
implementation ("com.github.bld-commons.excel:report-excel:2.0.5")
'com.github.bld-commons.excel:report-excel:jar:2.0.5'
<dependency org="com.github.bld-commons.excel" name="report-excel" rev="2.0.5">
  <artifact name="report-excel" type="jar" />
</dependency>
@Grapes(
@Grab(group='com.github.bld-commons.excel', module='report-excel', version='2.0.5')
)
libraryDependencies += "com.github.bld-commons.excel" % "report-excel" % "2.0.5"
[com.github.bld-commons.excel/report-excel "2.0.5"]

Зависимости

compile (5)

Идентификатор библиотеки Тип Версия
org.springframework.boot : spring-boot-starter-web jar 2.1.6.RELEASE
com.github.bld-commons.excel : generator-excel jar 2.0.5
com.github.bld-commons.excel : read-excel jar 2.0.5
org.springframework : spring-tx jar
org.springframework.boot : spring-boot-configuration-processor Необязательный jar 2.1.6.RELEASE

runtime (1)

Идентификатор библиотеки Тип Версия
org.springframework.boot : spring-boot-devtools Необязательный jar 2.1.6.RELEASE

test (1)

Идентификатор библиотеки Тип Версия
org.springframework.boot : spring-boot-starter-test jar 2.1.6.RELEASE

Модули Проекта

Данный проект не имеет модулей.

dev-excel

In this project 2 libraries were created in order to speed up and make easier the generation and reading of excel files through the library apache-poi. The 2 libraries are:

  1. generator-excel
  2. read-excel

The main classes to start developing the generator-excel library are:

  1. ReportExcel is the entity from which the excel file will be generated.
  2. BaseSheet is the class that represents the Excel sheet, it is extended from:
    • SheetData
    • SheetSummary
    • MergeSheet
  3. RowSheet is the entity that reprents the row of the sheet
  4. In the package "bld.generator.report.excel.annotation" there are the annotations to configure the sheet layout, the most important annotations are:
    • ExcelHeaderLayout
    • ExcelSheetLayout
    • ExcelColumn
    • ExcelCellLayout

It generates sheets with the following functionalities:

  1. Functions(sum by column and row).
  2. Charts.
  3. It merges cells between rows when they are equals if the option "notMerge" is disabled in the annotation "ExcelSheetLayout".
  4. To get rows list through a query by the annotation "ExcelQuery" and the "QuerySheetData" entity type.

For the complete documnetation of the generator-excel library, click on the following link:

The main classes to start developing the read-excel library are:

  1. ExcelRead is the object that represents the excel file.
  2. SheetRead is the object that represents the excel sheet.
  3. RowSheetRead is impletened for creating an object that represents the rows of the sheet.
  4. In the package "bld.read.report.excel.annotation" there are the annotations to map the entities with the sheets an columns of the excel file.

For the complete documnetation of the read-excel library, click on the following link:

Below is a summary table with the features of the functions for generating excel files within class GeneateExcel.

HSSF XSSF SXSSF
Function createFileXls createFileXlsx createBigDataFileXlsx
CPU and memory efficiency Varies varies Good
Read Files Yes Yes No
Write Files Yes Yes Yes
Create sheets/rows/cells Yes Yes Yes
Delete sheets/rows/cells Yes Yes No
Styling cells Yes Yes Yes
Shift rows Yes Yes No
Cloning sheets Yes Yes No
Formula evaluation Yes Yes No
Cell comments Yes Yes No
Picture Yes Yes No

Версии библиотеки

Версия
2.0.5