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
2
votes
1 answer

adding jXLS to my pom.xml seems to affect hibernate log level

Adding jXLS to my pom seems to affect my app Hibernate log level. The app will log hibernate DEBUG info at every second in the tomcat console (using eclipse). I add these two dependencies: org.jxls …
Georgi Stoyanov
  • 73
  • 6
2
votes
1 answer

jXLS jx:image ends with java.lang.IllegalArgumentException: imgBean value must contain image bytes

I want to put an image in XLS file template with jXLS 2.2.3 XLS template is defined as follows: Cell A1, added comment: jx:area(lastCell="L10") Cell A10, added comment: jx:each(items="rows" var="r" lastCell="L10") Cell D10, add…
Georgi Stoyanov
  • 73
  • 6
2
votes
0 answers

Re-compiled JXLS on java 1.6 has performance issues

I have a project with jdk 1.6, we could not use jxls2. I try to re-compile on jdk 1.6. I have got some "ArrayList not allowed with diamond sign in Java 1.6" errors, than i changed diamonds(<>) to < ... > and passed the compile... After compiling…
kkurt
  • 410
  • 3
  • 20
2
votes
3 answers

POI - ZIP entry size is too large

I use JXLS to create my woorkbook. JXLS uses POI underneath. To create a workbook JXLS either need a File or an input stream. With file object I get my desired woorkbook. But, with stream I get error ZIP entry size is too large. JXLS lib use…
Panda1667075
  • 147
  • 1
  • 10
2
votes
1 answer

JXLS can't read number whose length is greater than 10 correctly

I am using jxls for reading data from excel file. But there is something wrong when I tried to read a number like 12345678912: it would be transfer to 1.2345678E10 unless I set the format of this column to Text. Is there anything I can do to solve…
Chao
  • 21
  • 1
2
votes
3 answers

Formulas won't calculate automatically

I have a big sheet with a lot of formulas that have a dependency hierarchy between them. It starts with a cell with a date value. Then, cell x:y (and others), has formula depending on this date. Then cell w:z (and others) has a formula depending on…
qxlab
  • 1,506
  • 4
  • 20
  • 48
2
votes
1 answer

Jxls output excel file is not in same format as input template file

hi , i am using jxls for excel sheet generation , my problem is in o/p sheet i am getting extra rows , and some border styles also. for further reference i added two images here
mt_leo
  • 67
  • 1
  • 12
2
votes
1 answer

Hyperlink to download excel using jxls

First the context: I am using jxls to export to an excel using an excel template & its working fine.I am saving to a folder under webcontent WebContent\reports\report_output.xls What additionally i need to do: I have to provide a hyperlink to the…
sayannayas
  • 764
  • 9
  • 15
2
votes
3 answers

How to write a jXLS template and where to write it

I'm trying to use jXLS to export data from a list to an Excel sheet. I need to create an Excel template using jXLS and print out a list of data using that template. I have a Bean class called Department and I need to use a forEach statement to loop…
Raaz
  • 125
  • 1
  • 5
  • 16
1
vote
0 answers

org.apache.poi.ss.formula.FormulaParseException: Too many arguments to function 'IF'. At most 3 were expected but got 5

I'm new to JXLS library. Inside Jx:each area, I am using IF statement in a cell, K36, which is referencing a cell J36: $[IF("${account.type}"="Cash Flow", J36, 0)] when i run the template i'm getting error : 2023-03-23 12:02:33,566 ERROR…
Bikram Singh
  • 11
  • 2
1
vote
0 answers

How to use jxls excel fuction with ternary operator

this is my jxls code : ${data.TEST_COL18 != null ? [S3/M3*100] : ""} I think it is right, but it returns strange String like this '[l@5c6f3524' How can I solve this problem?
kukuku
  • 11
  • 1
1
vote
1 answer

Inserting new column in existing xls file keeping the format intact In Java

I want to insert a new column in between the existing columns of the excel which is in .xls format using Java retaining the existing format. Is there any api to do so?
Geeky
  • 113
  • 9
1
vote
0 answers

Cell note in jxls template is not deleted

PoiTransformer transformer = PoiTransformer.createTransformer(is, os); AreaBuilder areaBuilder = new XlsCommentAreaBuilder(transformer, false); List xlsAreaList = areaBuilder.build(); int curSheetSize = 3; …
RoyDaddy
  • 11
  • 1
1
vote
1 answer

[Jxls]Why SetFunction method cannot be found?

I had seen so many code examples in Internet about Custom Function in the Jxls. For example: Transformer transformer = TransformerFactory.createTransformer(is, os); ... JexlExpressionEvaluator evaluator = (JexlExpressionEvaluator)…
WildPig
  • 11
  • 1
1
vote
1 answer

How to autoSize cells in the jxls template, so that generated report also will have autosized cells

I have used jxls template to generate my excel report. The report data is not aligned properly. I need , Report's cells to be autosized based on the data length - both rowwise & columnwise. I have tried to used jxls comments, but didnt get correct…
jakmani
  • 9
  • 3
1 2
3
…
13 14