JXLS -

Time 2021-11-24 06:58:14

Web Name: JXLS -

WebSite: http://jxls.sourceforge.net

ID:246974

Keywords:

JXLS,

Description:

keywords:
description:
JXLS

---

Last Published: 2021-03-16 | Version: 2.10.0 | Sourceforge page | Source License Home Overview Getting Started Getting Help Release Notes Reference Main Concepts POI Transformer XLS Area SimpleExporter Excel mark-up Expression Language Each-command If-command UpdateCell-command Grid-command Image-command MergeCells-command Custom Commands Excel Formulas Multiple Sheets Area Listener Jxls Reader SQL In Template Samples Output Object Collection Excel Formulas Area Listener Output Collection with XML Builder Multi Sheets Markup Multi Sheets CellRefGenerator Grouping Sample Parameterized Excel Formulas Dynamic Grid SQL in Template SimpleExporter JavaDoc Jxls API Jxls POI Transformer Jxls Jexcel Transformer Jxls Reader API

---

Jxls 2.10.0 is available!

New features and fixed bugs

#78 Add support for JSR310 types (aka Java Time API), contribution by wagnerluis1982 #79 Multi-line and comment support for SQL queries in jx:each, contribution by alexlust #85 Distinguish between unknown key and run var #87 Formula recalculation, contribution by Turbocube644 #93 Backup/restore varIndex in jx:each #108 bug in 2.10.0 RC1: Dont call getRunVar with null #111 bug in 2.10.0 RC2: LiteralsExtractor buggy

other resolved issues:

#75 Documented varIndex argument, contribution by sapradhan #90 Escaping single quotes in query is possibleThe latest component versions

org.jxls:jxls:2.10.0

org.jxls:jxls-poi:2.10.0

Introduction

Jxls is a small Java library to make generation of Excel reports easy. Jxls uses a special markup in Excel templates to define output formatting and data layout.

Excel generation is required in many Java applications that have some kind of reporting functionality.

Java has a few libraries for creating Excel files e.g. Apache POI.

Those libraries are great but quite low-level as they require a developer to write a lot of Java code even to create a simple Excel file.

Usually one has to manually set each cell formatting and data for the spreadsheet. Depending on the complexity of the report layout and data formatting the Java code can become quite complex and difficult to debug and maintain.

In addition not all Excel features are supported and can be manipulated with libraries API (e.g. limited support for macros, graphs etc). The suggested workaround for unsupported features is to create an object manually in an Excel template and fill in the template with data after that. Jxls takes this approach to a higher level.

When working with Jxls one just needs to define the required report formatting and data layout in an Excel template file and then run Jxls engine to fill in the template with data. A developer needs to write just a little bit of Java code to trigger Jxls engine processing of the template.

Features XML and binary Excel format output (depends on underlying low-level Java-to-Excel implementation) Java collections output by rows and by columns Conditional output Expression language in report definition markup Multiple sheets output Native Excel formulas Parameterized formulas Grouping support Merged cells support Area listeners to adjust excel generation Excel comments mark-up for command definition XML mark-up for command definition Custom Command definition Streaming for fast output and less memory consumption Streaming for selected sheets (SelectSheetsForStreamingPoiTransformer) Table support

---

TAGS:JXLS 

<<< Thank you for your visit >>>

Hot Websites