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

Does POI XSSF still have crazy bad memory issues?

A couple years ago, I ran into issues where I was creating large excel files using jXLS and POI XSSF. If my memory is correct, I think XSSF would create something like 1GB+ temp files on the disk to create 10mb excel files. So I stopped using jXLS…
Bob Thule
  • 691
  • 9
  • 15
11
votes
2 answers

how to merge cells dynamically in JXLS API in transformed template

I am using Jxls API i can now create , pass data lists to the template which creates excel output sheet as desired but now i have to merge the column cells which carry same value this is my for each tag for repeating cells
Hussain Akhtar Wahid 'Ghouri'
  • 6,527
  • 8
  • 50
  • 85
10
votes
1 answer

Search in xlsx and xls file using java

I have a large xlsx file which as huge amount of data on which I have to implement search option I have used Apache POI jar as well as jxl jar so that the search between rows and column have been made. But it took huge time to traverse between big…
ashokramcse
  • 2,841
  • 2
  • 19
  • 41
7
votes
6 answers

Jxls Error : Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath

This question has been already asked once but no one gave a absolute solution to it. Im trying to generate a xls file from a existing template but im getting an error which I dont know how to face out! My code: String nombre = "Manuel"; try…
Lorenzo Gamboa
  • 89
  • 1
  • 1
  • 8
7
votes
1 answer

Writing to an Existing Excel File

package jexcel.jxl.nimit; import java.awt.Label; import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.CellType; import jxl.LabelCell; import jxl.NumberCell; import jxl.Sheet; …
Nimit_ZZ
  • 495
  • 4
  • 10
  • 21
5
votes
1 answer

How to migration JXLS from version 1 to 2

JXLS 2 is not backward compatible with version 1. There are no upgrade instructions and while I can get things working with version two I'm having two issues. Version 1 did not require use of comment tags, but now I cant get the output to generate…
dcompiled
  • 4,762
  • 6
  • 33
  • 36
4
votes
2 answers

jxls reading excel with unknown no of rows

How do i configure jxls API to read an excel sheet , where i will not know the no of rows at compile time. what will be the loopbreakcondition. Cant jxls find out how many rows in the excel sheet have valid data , and read uptill there. What are the…
nihar
  • 41
  • 1
  • 3
4
votes
1 answer

How to make conditional formatting work with jxls

I have created an Excel template for jxls 2.x. There is one cell I have applied conditional formatting. However the conditional formatting only works in exactly the same cell I have created, and it is not duplicated to the following rows. Any idea?
Gelin Luo
  • 14,035
  • 27
  • 86
  • 139
4
votes
2 answers

JXLS auto fit row height according to the content

I'm using JXLS 2.3.0 with apache poi implementation. And I use following code to create excel : try{ InputStream is = ObjectCollectionDemo.class.getResourceAsStream("/template.xls") OutputStream os = new FileOutputStream("target/output.xls") …
frank
  • 1,169
  • 18
  • 43
4
votes
1 answer

SXSSF Transformer with JXLS 2

I'd like to use the SXSSF transformer with JXLS. I tried to write my template in such a way that I wouldn't get the "Attempting to write a row in the range that is already written to disk" exception. The template captures known columns (e.g.,…
user581638
  • 223
  • 3
  • 8
4
votes
1 answer

Java - synchronized DateFormat - jxls

I need to use DateFormat object in jxls beans. If in my class I write the following: private synchronized DateFormat df = new SimpleDateFormat("dd.MM.yyyy"); Will it be thread-safe? In the same class I have a method: public void doSomething() { …
another-programmer
  • 841
  • 13
  • 37
4
votes
3 answers

jxls file generation hangs for ever when rows > 10,000

I have a excel report that gets generated. Most of the time, it works fine when rows are up to about 2,000. This morning, I tried to generate a report that has 11,000 rows and could not figure out why it would just hang since it was following the…
user899757
  • 351
  • 2
  • 4
  • 21
4
votes
1 answer

Reading content from an Excel file

package jexcel.jxl.nimit; import java.io.*; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import jxl.read.biff.File; public class ExampleJxl { /** * @param args */ …
Nimit_ZZ
  • 495
  • 4
  • 10
  • 21
3
votes
1 answer

jXLS 2.3 - add the listener to update a cell style depending on the cell content?

There is an example of the dynamic cell styling for jXLS 1.x, but I can not find anything closer than this example for AreaListener. I have a very basic template for the XLS generation, and the processing code as simple as context.putVar("headers",…
jdevelop
  • 12,176
  • 10
  • 56
  • 112
3
votes
4 answers

How to get row index in JXLS 2.3.0

I can use varStatus property in jxls 1.X to get the row index while using foreach to traverse a list, But jxls 2.3.0 does not support this, how can output the row index in EXCEL with jxls 2.3.0 ?
Duo
  • 31
  • 1
  • 4
1
2 3
…
13 14