Stack Overflow
Stack Overflow

Questions tagged [jxls]

jXLS is a Java library for writing Excel files using XLS templates and reading data from Excel into Java objects using XML configuration.

jXLS is a small and easy-to-use Java library for writing Excel files using XLS templates and reading data from Excel into Java objects using XML configuration.

In addition to Excel generation functionality jXLS also contains jxls-reader module which provides a great help if you need to parse Excel files created in a predefined format to pull in the data. jXLS-reader allows you to describe parsing rules in a simple XML and all the other work on reading Excel file and population of your Java objects will be done automatically.

Features:

  • Using SQL queries directly in XLS templates
  • Simple property access notation
  • Full expression language support
  • Complex object graph export
  • Flexible collection export
  • Flow-Control Tags support
  • Dynamic grouping of data
  • Export of a single collection into multiple worksheets
  • Adjacent tables support!
  • Complex formulas support
  • Charts, Macros and many other Excel features in XLS template
  • Dynamic Outlines
  • Dynamic Columns Hiding
  • Dynamic Cell Style processing through custom Processors
  • JDBC ResultSet export
  • Merged Cells support
  • Multiple bean properties in a single cell
  • Reading XLS files

Details are available at http://jxls.sourceforge.net/

200 questions
3
votes
3 answers

JXLS - how to create hyperlink to Excel worksheets in workbook

I am trying to create an Excel workbook with with JXLS. I want a text hyperlink for navigating through worksheets in a workbook. I couldn't find any helpful information online. Please give any idea or hyperlink for that can help to to solve the…
Techno
  • 166
  • 1
  • 3
  • 13
3
votes
2 answers

jxls - create Excel file with dynamic images

I want to create an Excel file with a dynamic logo and a list of dynamic images. The creation of the text part in the Excel file works great with jxls. But I'm not able to insert one image in each row with jxls. Please, does anyone have advice for…
user1732091
  • 41
  • 1
  • 4
3
votes
2 answers

How to sum columns of a dynamically created range of cells in Excel

There are a number of rows created using a jxls forEach loop in an Excel spreadsheet. Within each of these rows, there are a set of columns that are also dynamically created with a forEach. So essentially one cell turns into a range of a few cells…
ciaranodc
  • 398
  • 4
  • 16
2
votes
2 answers

Compatibility between Apache Poi 4.1.2 and net.sf.jxls (jxls-core 1.0.6)

I need to know if those libraries mentioned in the title are compatible between each other. What I need to do is to change libraries: from net.sf.jxls to org.jxls 2.10.0 (and therefore adapt the implementation that was made using jxls-core 1.0.6).…
Paul
  • 21
  • 3
2
votes
2 answers

JXLS 2.0 Conditional Formatting Forumla not updated per row

Trying to create an JXLS excel template where it should be possible to copy conditional formatting from a cell on a specific row to the next generated row. In the template, I create my formatting. If the value in the cell is equal to "yes" the row…
Jonathan Andersson
  • 1,342
  • 3
  • 16
  • 31
2
votes
2 answers

Angular 6 reading XLS file and saving it into a variable

I've been trying to read a XLS file and save it into a local variable for ease of use but I am constantly getting TypeError: Cannot set property 'songs' of undefined I have never tried to read a XLS before only csv's which are a lot easier but…
amedeiros
  • 167
  • 3
  • 13
2
votes
0 answers

Java JXLS API ForEach

I am using JXLS API for generating Excel reports. I am trying to achieve nested loops in such a way that I want to iterate FIRST column-wise the array of OuterObjects, where each OuterObject has an array for InternalObject, and then iterate SECOND…
Nevil
  • 45
  • 1
  • 6
2
votes
2 answers

Use function in JXLS template

My template has some function such as TODAY(), CHOOSE(),... but when I use Jxls to write contents, these function not working, its display 0. How to make these functions works?
Nhân Trần
  • 85
  • 11
2
votes
2 answers

Is an if-elseif-else construct possible in JXLS?

Is it possible to use an if / elseif / elseif / ... / else construct with JXLS? In the docu I see jx:if(condition="employee.payment <= 2000", lastCell="F9", areas=["A9:F9","A18:F18"]) I already used it and it works fine. But, taking this example, I…
BAERUS
  • 4,009
  • 3
  • 24
  • 39
2
votes
1 answer

Improve performance of jXLS

I have some problems when I use JXLS to do the excel file export. It is really slow to transform the param list to the excel file when the map size is larger than 5000. Is there any faster solution? This is the code: private Workbook…
Aezio
  • 203
  • 5
  • 18
2
votes
1 answer

May I use jxls and apache poi together?

I'm making an application to analize some data and the result must be presented in excel files. In that sense I started to use Apache POI (3.11). Due to some reports consumes a lot of time and memory to be reproduce, I made an investigation and I…
José Castillo
  • 160
  • 1
  • 15
2
votes
3 answers

Java JXLS Transformer error

I'm just trying to prove a demo code from Java JXLS : http://jxls.sourceforge.net/samples/object_collection.html but after adding (without MAVEN) necessary libraries: jxls-2.3.0.jar jxls-poi-1.0.9.jar jxls-reader-2.0.2.jar poi-3.14-20160307.jar…
NachoR
  • 31
  • 1
  • 2
2
votes
3 answers

JXLS2, XLSCommentBuilder and row overwrite white iterating over the passed collection

I have rather simple XLS template, and one of the rows is annotated with the comment on the cell A10: jx:each(items="obj.reportRows" var="reportRow" lastCell="H10") it works well - takes the collection and adds all the data from it, however it does…
jdevelop
  • 12,176
  • 10
  • 56
  • 112
2
votes
2 answers

Writing large number of rows using jxls to excel in java

I am using the below code to to write data to excel XLSTransformer transformer = new XLSTransformer(); InputStream is = this.getServlet().getServletContext() .getResourceAsStream(templateFilePath); HSSFWorkbook…
user2025528
  • 155
  • 3
  • 9
2
votes
2 answers

Putting two dynamic grids beside each other with JXLS

I want to define an Excel template to be used with JXLS (current version 2.2.5) in such a way that there is a dynamic grid (i.e. I do not know the number of columns before-hand), and to the right side of it, another grid: Header 1.1 | Header 1.2 | …
Matthias
  • 1,759
  • 16
  • 34
1
2
3
…
13 14