Loiste 2.0 updates to POI 6. Loiste's own API is unchanged, but the new POI version requires Java 17. Stay on Loiste 1.2.x if you need Java 8 or 11.
:interop functions, may need changes.
POI 6 removes deprecated methods, e.g. Font.getIndexAsInt (use getIndex, which now returns int),
and changes some behavior, e.g. DataFormatter uses cached values for formula cells by default.
See the POI changelogjava.time values (#14)
LocalDate and LocalDateTime are written as isInstant and ZonedDateTime are written like java.util.Date, as wall-clock time in the JVM default time zonejava.util.Date, use a style with a date :data-format to show the cell as a dateBorderStyle and FillPatternType values in cell styles (#9)
:medium-dashed, :double, :fine-dots
(:solid still means SOLID_FOREGROUND):border-bottom BorderStyle/DOTTEDIllegalArgumentException, like invalid fill patterns already did:interop function, called with the Cell or Row and the options map,
after the values have been written. The options map contains :workbook, :sheet and the created :styles:interop function, called with the CellStyle or Font:font accepts a Font instance and write-rows! :styles values accept CellStyle instances,
so fonts and styles can be created once and shared, e.g. between styles and rich text written in :interop.
Instances created in another workbook throw IllegalArgumentException(l/streaming-workbook (l/workbook) {:shared-strings-table? true}) to write rich text.org.joda.time.DateTime values with loiste.joda-time:
the CellWrite implementation had the wrong arity and threw ArityException.nil values as BLANK cells, instead of empty string.color function to use rgb byte-array instead of going through java.awt.Color
(should not break existing uses)isCellDateFormatted to check if numeric cell value should be
returned as Dateread-sheet function which uses column headers from the first row
for data map keysTRUE() and FALSE() formulas (coerced to booleans)-to-workbook URL implementation (#4)Can you improve this documentation? These fine people already did:
Juho Teperi, Tuukka Kataja & Matti NieminenEdit on GitHub
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |