Stack Overflow
Stack Overflow

Questions tagged [jexcelapi]

Java Excel API(jexcelapi) - A Java API to read, write, and modify Excel spreadsheets

Java Excel API is a mature, open source (GNU Lesser General Public License) Java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e.g. disk, HTTP, database, or any socket).

Similar Java libraries include Apache POI

Major features include:

  • Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks
  • Reads and writes formulas (Excel 97 and later only)
  • Generates spreadsheets in Excel 2000 format
  • Supports font, number and date formatting
  • Supports shading, bordering, and coloring of cells
  • Modifies existing worksheets
  • Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated)
  • Supports copying of charts
  • Supports insertion and copying of images into spreadsheets
  • Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc

Known Limitations:

  • JExcelApi does not generate or chart, graph or macro information. This information is however preserved when spreadsheets are copied
  • When adding images to a sheet, only PNG image formats are supported

Useful Links:

209 questions
50
votes
10 answers

Create Excel file in Java

I want to create an Excel file and write data just like writing a text file with Java. I tried to change file extension from .txt to .xls. But I want to bold letters in the Excel file. How can I do that? I have tried using the JXL API, but every…
guna
18
votes
8 answers

how to solve JXL error : jxl.read.biff.BiffException: Unable to recognize OLE stream

i am trying to get cell data from my .csv file but it gets error : jxl.read.biff.BiffException: Unable to recognize OLE stream I don't understand how to solve this,please give me some solution this code is for jxl api & is that api support to…
user1263633
  • 279
  • 1
  • 3
  • 13
14
votes
3 answers

Encoding problem in JExcel

I am loading an excel file in an GAE/Java application with JExcel like this: The html form to upload the file islike this:
Javi
  • 17,777
  • 30
  • 97
  • 132
11
votes
3 answers

Opening an Excel file using the default program

My program successfully creates and fills a Excel(.xls) file. Once created, I would like the new file to open in the system's default program (Excel in my case). How can I achieve this? For an older program where I wanted to open a txt file in…
clang1234
  • 1,644
  • 2
  • 15
  • 26
8
votes
2 answers

How to write formatted numbers as numbers in JExcel (jxl)

I am using Java Spring and jxl to create Excel workbook on server side. The data that needs to be shown in Excel consists of already formatted numbers. I am using WritableCellFormat wcf = new…
engg
  • 281
  • 4
  • 5
  • 6
8
votes
3 answers

Making new colors in JExcelApi

I'm using JExcelApi for generating XLS files. From jxl.format.Colour, I see how to get any of the colors in the "standard Excel colour palette", but not how to create a new color (say, given its RGB). But in Excel itself, I can pick any color at…
Ken
  • 1,076
  • 1
  • 10
  • 17
7
votes
2 answers

Trouble copying excel sheets with JExcel API

I was working on some fairly complex excel files and ran into a problem with copying sheets. Whenever I attempt to copy a sheet that is not completely blank i recieve the following message: Exception in thread "main" java.lang.NullPointerException …
Kevin Brey
  • 1,205
  • 1
  • 12
  • 18
7
votes
5 answers

Which library should I use to write an XLS from Linux / Python?

I'd love a good native Python library to write XLS, but it doesn't seem to exist. Happily, Jython does. So I'm trying to decide between jexcelapi and Apache…
Jeremy Dunck
  • 5,234
  • 5
  • 23
  • 29
6
votes
2 answers

What are the best practices for rendering excel sheet reports in Java?

I have a need to generate an excel sheet report which looks like the following template -- I know this can be done using libraries like JExcelApi and Apache POI. However I would like to know if there are means of accomplishing this by writing a…
ping
  • 1,209
  • 3
  • 20
  • 41
5
votes
2 answers

Writing JTable into Excel

I am planning to move the contents of a JTable into a Microsoft Excel sheet. The Excel sheet should have some format specifications. For instance if a column has a value 'A' it should be green in colour. If it is 'B' red in colour. I am in analysis…
Harish
  • 2,850
  • 14
  • 47
  • 73
5
votes
2 answers

Create Multiple Sheet in jExcel API

I need to create multiple excel sheet in Java using jExcel API if one sheet is full (65536 rows). Suppose if one sheet got full then in the next sheet it should start writing automatically from where it left off in the first sheet. I am just stuck…
arsenal
  • 20,650
  • 79
  • 217
  • 317
4
votes
2 answers

JExcelAPI - writing date to Excel sheet ignores day, month and year

I try to generate some Excel sheets in Java application using JExcelAPI (v. 2.6.3) and can't generate date cells properly. For example, for code: WritableWorkbook workbook = null; workbook = Workbook.createWorkbook(new…
Tadeusz Kopec
  • 11,984
  • 6
  • 51
  • 79
4
votes
3 answers

What is the best API to read large excel files using Java?

I need to read large excel sheets using Java. The Excel sheet may be .xls or .xlsx. The sheet may have thousands of rows. I have to read all rows and insert that row in the database. So basically read from Excel and write in database. The APIs…
ashishjmeshram
  • 11,077
  • 50
  • 148
  • 224
4
votes
2 answers

What is the best way to write an excel file from Java?

What library would you guys recommend to write an excel file from Java? It has to be pure Java solution, so it will work on any platform. Thanks, Grae EDIT: It can't be CSV file format. It has to have column headers, data format type, etc.
GC_
  • 1,613
  • 4
  • 22
  • 37
4
votes
4 answers

jExcelApi - cell date format reusing doesn't work

I created a wrapper to jExcelApi classes to easily export lists of objects to Excel. To minimize object creation cell formats are created as static fields and reused in consecutive calls to export. But I have problems with Date format - the first…
Tadeusz Kopec
  • 11,984
  • 6
  • 51
  • 79
1
2 3
…
13 14