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:

207 questions
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,673
  • 6
  • 23
  • 39
4
votes
3 answers

Is there any Java library which supports both Microsoft office and Open Office?

As Apache POI supports Microsoft office and JExcelApi supports Open Office, is there any Java library which supports both Microsoft office and Open Office? Note: In the pom.xml file we are using either POI and JExcel utilities in order to fetch/read…
mfsi_sudhansu
  • 175
  • 2
  • 3
  • 10
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 for Ukraine
  • 12,283
  • 6
  • 56
  • 83
4
votes
2 answers

JExcel/POI: Creating a cell as type Text

I have a requirement that involves reading values from an excel spreadsheet, and populating a spreadsheet for users to modify and re-upload to our application. One of these cells contains a text string of 5 characters that may be letters, numbers,…
user1411138
  • 121
  • 1
  • 4
3
votes
1 answer

Character encoding issues in Eclipse for Java using Webdriver

I'm currently using Eclipse with TestNG running selenium webdriver with java. I am using Jexcelapi to import data from OpenOffice (spreadsheet) to compare strings on the website i'm testing with values in the spreadsheet. The problem I have is that…
Ade Bakre
  • 139
  • 1
  • 2
  • 8
3
votes
1 answer

how to set number format to cells using jexcel api

I am writing a excel sheet with various floating values . It is absolutely necessary that i do not lose any decimal point when doing this. I am using this code: number = new Number(1, rowno2,biashidden[i]); …
CyprUS
  • 4,159
  • 9
  • 48
  • 93
3
votes
1 answer

Reading Excel checkbox values in Java Apache POI

I have spent countless hours trying to find a solution to this. I have tried Apache POI, JExcel and JXLS but no where have I found code to successfully read checkbox (form control) values. If anyone has found a working solution then it would be…
AngryPanda
  • 1,261
  • 2
  • 19
  • 42
3
votes
8 answers

What exactly does need for POI Excel API

I'm working on program that make Excel data via POI API 3.9 . but there are many Jar files in directory as follows. poi-3.9-20121203 poi-excelant-3.9-20121203 poi-ooxml-3.9-20121203 poi-ooxml-schemas-3.9-20121203 poi-scratchpad-3.9-20121203…
dskim
  • 731
  • 1
  • 6
  • 12
3
votes
3 answers

JExcelApi currency format on formula cell - file error

I'm writing a spreadsheet with JExcelApi. I have two cells that I want to apply currency formatting to. From reading the API I discovered jxl.write.NumberFormat, which seems to do what I want. In my application I've written: NumberFormat currency…
Brian Beckett
  • 4,742
  • 6
  • 33
  • 52
3
votes
1 answer

I have to sort xls sheet rows using a column values in java using jexcel

I am using jexcel api in java. I need to read xls paticular column value and have to sort the entire rows in xls based on that. Then I have to save those rows in sorted manner in new xls. I able to do that using TreeMap but it creates a possibility…
rax123
  • 71
  • 1
  • 6
3
votes
4 answers

Choosing an excel java api

All I need to do is open an MS excel sheet - not sure which kind yet (2003, 2007, etc.) - and parse the information in each row into an object. I'm performing only readonly operations. out of Apache POI, JExcelAPI, or OpenXLS which is best for this…
Victor
  • 5,697
  • 6
  • 34
  • 41
3
votes
2 answers

Jexcel Formula Calculation Error

I have created a worksheet, out.xls which had cell D6=D5*2 and D5 set to 1. My issue is that when I plug a value into D5 in jxl, D6 never calculates. D6 simply holds on the value it initially calculated when I plugged in 1 to D5 in excel. note: I…
user1433764
  • 31
  • 2
2
votes
2 answers

How can I export data from an array to an Excel spreadsheet?

Sorry if tutorials for this already exist, but the only help I can find is much more advanced than for what I'm trying to accomplish. I have a 100 element array of integers that I want to export into a spreadsheet. Array[0] goes to A1, Array[2] goes…
maxematician
  • 199
  • 7
2
votes
2 answers

Evaluation from Apache POI and JExcel Api

I need create Excel woorkbooks in Grails, Grails support both Apache POI and JExcel Api, but I would like you to tell me about the advantages and disadvantages of both. According to I know, Apache POI is more faster than JExcel Api, but the JExcel…
yecid
  • 180
  • 3
  • 16
2
votes
1 answer

Errors while Copying Workbook using JExcel API

I am trying to copy a large Excel file with multiple worksheets and a ton of formulas using JExcel API; however, when I run the following code-- Workbook w = Workbook.getWorkbook(inputWorkbook); WritableWorkbook wcopy = Workbook.createWorkbook(new…
Jen
  • 155
  • 1
  • 3
  • 15
1
2
3
…
13 14