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
1
vote
1 answer

Create Excel File Using jExcel

I made an excel file using jExcel API, but when I tried to open that file I got error filename.xls:file format is not valid and I can not open this file, here is my Java code File file = new File("C:\\Users\\Giga\\Desktop\\yvela.xls"); …
G.Ch.
  • 35
  • 6
1
vote
1 answer

Using JExcelApi to write BigInteger to xls with $ and , formatting

I am trying to write values stored as BigDecimals e.g. 6789456123 to an xls file but I require the xls file to display $6,789,456,123 (As a currency with 0dp. I can do it as a string with this formatting however this ins't ideal). I am using…
Rudder_NZ
  • 57
  • 1
  • 5
1
vote
2 answers

Could not find or load main class cmd, it works fine in Eclipse, build paths seem ok

Hi guys and thanks for trying I am using the JExcelApi to create an excel file from a cmd prompt with a java file. The code works perfectly within eclipse with the right build paths etc. When i try it in the cmd prompt the javac works then when i…
Lethal420
  • 73
  • 1
  • 12
1
vote
0 answers

JExcel -- Write a cell value that may be a number or empty

In JExcel, you can do: new Number(column,row,value) but null is not an accepted value. For labels, using null as a value is fine. Is there a way to create a cell that is either a Number or null, without doing this logic manually, as in: if (value…
Jeremy
  • 5,365
  • 14
  • 51
  • 80
1
vote
1 answer

JExcel : Losing Cell Precison On Cells Having Formula ROUNDUP in MS Excel

I am unable to properly read numeric cells which has ROUNDUP in the formula, for example Cell C25 is =ROUNDUP(5296.43899096,2) it shows 5296.44 in Excel but the below code Cell cell = worksheet.getCell("C25"); System.out.println(…
zambezi
  • 21
  • 2
1
vote
1 answer

Inserting an array into Excel

I have an array that I want to retrieve the values from and insert them into excel using Jxl, one value into one row eg: 1| blah blah blah 2| blah blah blah 3| blah blah blah I can retrieve the values from the array as is shown in the code below,…
J4C3N-14
  • 686
  • 1
  • 13
  • 32
1
vote
1 answer

jxl set font to date type cell

I'm using jxl to create excel files. I need to set a particular font for date type cells. When I write a text cell it's easy to do: WritableFont arial10pt = new WritableFont(WritableFont.ARIAL, 10); arial = new…
Silvio
  • 123
  • 1
  • 11
1
vote
0 answers

Java Errors From an Excel API

I do hope someone can help me or point me to someone who can, with this problem. I have been working with someone who wanted to extend the capabilities of an Excel Spreadsheet that is embedded in a Third Party application that provides streamed…
user3519343
  • 11
  • 1
1
vote
2 answers

jExcel getting cell content missing

I read excel file correctly.For example my cell content is 0,987654321 in excel file.When I read it with jExcel api i reads just few chars of cell.For example 0,987. here is my read excel code part: Cell A = sheet.getCell(1, 1); String stringA =…
Kaan Kılıç
  • 27
  • 1
  • 6
1
vote
1 answer

Jexcelapi Getting the number of rows in one column

I can find the number of rows in the excel document using sheet.getRows(); however the rows in my excel file are of different lengths, how could I get the number of rows in only 1 column. I've found getting rows in file and List of methods in…
OrigamiEye
  • 864
  • 1
  • 12
  • 31
1
vote
0 answers

Specify File Path in Formula String in POI

Im new to POI and I have requirement to search a given list of strings in two different excel sheets which will have the occurence of the search Strings, one or more times. Now, im using Cell itereator to iterate through all rows to search the…
user1909657
  • 91
  • 1
  • 1
  • 5
1
vote
1 answer

Excel file access from internal storage android app

I want to be able to copy an excel file from my android app res\raw folder to the client phone's internal storage, and be able to retrieve the data from the excel file and update the excel file in the internal storage as needed. So far all I have is…
Ahmed Zafar
  • 665
  • 2
  • 10
  • 24
1
vote
2 answers

What are the differences between jxl vs apache poi vs jexcel?

what are the relevant differences between this libs ? also can tell me anyone about the license of this products ? i need to generate large files .xlsx files. Until now i used jxl lib in for .xls with a a formated header using…
Lucian L.
  • 11
  • 1
  • 1
  • 3
1
vote
1 answer

Lexical error in formula that contains ampersand

I'm trying to add a formula to my spreadsheet that contains a SUMIF that references a cell. Here's the code for the formula I'm trying to add: addFormula("(100 * " + dRangeCell + " / 256) * (SUMIF(B" + (dip.start+1) + ":B" + (dip.end+1) + ",\"<\"&"…
almostkorean
  • 41
  • 2
1
vote
1 answer

how to display up to 1 decimal place

I am using jxl-2.6.3.jar. I want to display bigdecimals, which are up to 1 decimal point. If i write like below, then 1.2 is displayed as "1.2" , but 1.0 appears as "1." . I need 0 as well in case of 1.0, i.e "1.0" instead of simply "1."…
Johnn
  • 35
  • 5
1 2 3
…
13 14