v2.5.1

Changelog

• Update Apache POI 5.2.5.
• Added readSheetOrThrow and fixed readSheet(InputStream stream, String sheetName) to return Result instead of List via #33 (contributor: @JustAnotherID)

Full Changelog: v2.5.0...v2.5.1

v2.5.0

• Update Apache POI 5.2.2.
• Replace System.out and System.err with loggers #26.
• [Breaking Change]! Remove .split() method in DataTemplate and ColumnTemplate. Add new alternative method .filter() with more explicit meaning.
  • Please notice that .split() and .filter() are not the same functionality - one removes on condition (split), and one filter by condition (filter).

v2.3.4

Changelog

• [Performance] Fix merging rows on large data set
• Add more data types for writing DTOs

v2.3.3

Changelog

• Update to POI 5.1.0
• Fix some navigation behavior

v2.3.2

Changelog

• Official update for release 2.3.2-SNAPSHOT
• Fix formula evaluation for reader
• Modify reading validation:
  • Rename:
    • validator.Error to validator.ObjectError
    • validator.TypeError to validator.FieldError
    • core.LineError to core.RowError
  • Fix built-in validators' logic
  • Add hasError(), getErrors() and terminateNow() for ReaderCell and ReaderRow

2.3.2-SNAPSHOT

Changelog

• Change interface of Validator
• Fix #12
• Fix .fromColumn() wrong behavior

Installation

<dependency>
    <groupId>io.github.nambach</groupId>
    <artifactId>ExcelUtil</artifactId>
    <version>2.3.2-SNAPSHOT</version>
</dependency>

Add below section into your pom.xml to use SNAPSHOT release:

<repositories>
  <repository>
    <id>snapshot</id>
    <url>https://s01.oss.sonatype.org/content/repositories/snapshots</url>
    <releases>
      <enabled>false</enabled>
    </releases>
    <snapshots>
      <enabled>true</enabled>
    </snapshots>
  </repository>
</repositories>

v2.3.0

Changelog:

• Update POI version to 5.0.0
• Support Excel 97-2003
• Support writing large files with POI SXSSFWorkbook
• For writer:
  • Allow expand list fields into multiple rows (#6)
  • Add comments, dropdown list (#10)
• For reader:
  • Allow validating data while reading (#7)

v2.1

Official release