Stack Overflow
Stack Overflow

Questions tagged [jxl]

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

From http://jexcelapi.sourceforge.net/:

Java Excel API is a mature, open source java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Now 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). Any operating system which can run a Java virtual machine (i.e., not just Windows) can both process and deliver Excel spreadsheets. Because it is Java, the API can be invoked from within a servlet, thus giving access to Excel spreadsheets over internet and intranet web applications.

455 questions
96
votes
4 answers

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Which of the 2 APIs is simpler to read/write/edit excel sheets ? Do these APIs not support CSV extensions ? Using JXL for file.xls and file.xlsx, I get an exception like: jxl.read.biff.BiffException: Unable to recognize OLE stream at…
Swagatika
  • 3,376
  • 6
  • 30
  • 39
39
votes
5 answers

Exception while compiling: wrong version 50.0, should be 49.0

I am working an application with JXL API and when i tried compiling using eclipse IDE, it's working fine and the same is not compiling when i am trying to compile in Command prompt and showing the below exception.. Extract.java:6: cannot access…
i2ijeya
  • 15,952
  • 18
  • 63
  • 72
27
votes
8 answers

JXL Cell Formatting

How to autofit content in cell using jxl api?
SAK
  • 269
  • 1
  • 3
  • 4
25
votes
2 answers

How to process old excel .xls files using POI?

I switched from jxl to poi since POI has more features. However, I wasn't able to process the xls files that were generated in the old format. Now I am getting this error: org.apache.poi.hssf.OldExcelFormatException: The supplied spreadsheet …
Wael
  • 1,533
  • 4
  • 20
  • 35
16
votes
4 answers

Modifying existing excel using jxl

I m not able to edit the existing excel sheet using jxl. It always creates a new one. Can anyone please help me out with it. Please give a small sample code.
TestUser
  • 501
  • 4
  • 7
  • 17
13
votes
3 answers

How to create excel sheet with right-to-left alignment using JXL

I wonder if i can set the direction of the excel sheet to right-to-left ... I am using JXL Api. thanks in advance The bounty is about right to left and not right alignment
Imad
  • 393
  • 4
  • 14
12
votes
5 answers

BiffException while reading an excel sheet

I have a code to read from an excel sheet which is in old format(97-2003). I made some changes to data and ended up a 2007 format excel sheet. When I used this xlsx sheet instead of xls sheet, I am getting this: jxl.read.biff.BiffException: Unable…
nowfal
  • 219
  • 2
  • 3
  • 6
12
votes
2 answers

creating an excel file in memory using java and pass as bytes for downloading

I have created a excel file using jxl library. The code is working fine but the only problem is that each time for building an excel file from the dynamic values coming from a service, the excel content is overwriting onto a test.xls like as shown…
Alex Man
  • 4,746
  • 17
  • 93
  • 178
12
votes
4 answers

Microsoft Excel Macro to run Java program

I have learnt to read and write an Excel file using a Java program with the help of Jxl and POI API. Is it possible to run a Java program with the help of macros?
Nimit_ZZ
  • 495
  • 4
  • 10
  • 21
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
11
votes
1 answer

how to create appendable excelsheet using java

I want to create an append-able excel sheet. Like i have four columns stream1 stream2 stream3 stream4 first time i am inserting data only first column(stream1) after that i want to full fill other columns one by one. this is the code which i am…
narendra
  • 451
  • 3
  • 12
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
10
votes
5 answers

How Do I Create a New Excel File Using JXL?

I'm trying to create a new Excel file using jxl, but am having a hard time finding examples in their API documentation and online.
Aaron
  • 23,450
  • 10
  • 49
  • 48
9
votes
1 answer

JXL Number Format and Cell Type

I am using JXL to write an Excel file. The customer wants a certain column to display numbers with one decimal place. They also want the cell types to be "Number". When I use the following (test) code, the numbers are displayed correctly, but the…
Snowy Coder Girl
  • 5,408
  • 10
  • 41
  • 72
9
votes
1 answer

JXL solve #VALUE problem

I want to use AVERAGE function, but when I have a reference cell which happens to be a label I get #VALUE as the output. I have attached the sample piece of code for what I am trying to do: String filename = "C:\\input.xls"; WorkbookSettings ws…
Balaji.N.S
  • 745
  • 3
  • 13
  • 28
1
2 3
…
30 31