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
0
votes
0 answers

Using JExcelAPI with Android gets NoClassDefFoundError at runtime for jxl.write.label

I am developing an Android app for 4.1.2 on Netbeans 7.3 using the NBAndroid plugin. I downloaded and compiled the JExcelAPI, and pulled the jxl.jar file into my "libs" folder. My app compiles fine and runs fine, until I try to instantiate a Label…
SB316
  • 51
  • 5
0
votes
4 answers

Working with Excel Sheets using java programming

I got a small problem while working with a project. I already have an excel file with some sheets in it. Whenever I need to create a new excel file sheet with a particular name, I need to check if there's already a sheet with that name, If it is…
ranjithnori
  • 183
  • 3
  • 15
0
votes
0 answers

Storing values in an array from excel

I'm using jexcel to store values from an excel sheet to a java array. But i'm getting only null values. Could you please tell me what i'm doing wrong? package com.tcs.urls; import java.io.File; import jxl.Sheet; import jxl.Workbook; public class…
Thomas Parayil
  • 125
  • 1
  • 10
0
votes
1 answer

Writing to an excel file - Performance Analysis

So after doing some research on writing to an Excel file i have found that both the Apache API and JExcel could cause performance issues. At the moment my application outputs the information i want to a TextArea but i was considering writing to an…
user2385671
  • 53
  • 5
0
votes
1 answer

excel file reading row wise values

im developing one tool for uploading excel and validate it, but excel file is large and the row count is about 65536. here is my code used for uploading and reading the excel sheet values int firstColNo = 1; int rowcount = sheet.getRows(); …
user2405204
  • 1
  • 1
  • 2
0
votes
1 answer

How do I 'activate' a hyperlink in excel, after writing it in JExcel?

Some of the columns in my spreadsheet, created using JExcel, are hyperlinks, that use adjacent cells. Take this example: |A |B |C |D |RowNumber |Unicorn Name|Unicorn ID|Link to Unicorn Profile |000000001 |Jefficorn |001 …
AncientSwordRage
  • 7,086
  • 19
  • 90
  • 173
0
votes
0 answers

Spring 3 (annotation) with JExcelAPI

I'm trying to do this tutorial http://www.mkyong.com/spring-mvc/spring-mvc-export-data-to-excel-file-via-abstractjexcelview/ using Spring 3 and annotations. So I have a WebAppConfig…
BkSouX
  • 739
  • 5
  • 13
  • 29
0
votes
1 answer

How to set color of cell with JExcel API

I want to know how to set color to cells in Excel using JExcel API. A sample program would do as an example.
user1971760
  • 39
  • 1
  • 2
0
votes
1 answer

Jexcel in android producing empty file

I am trying to use jexcel in my Android app to write excel file. I opened workbook, created a sheet, wrote a label and that's it An xls file is created but it is empty. I am not getting any errors. Anyone has it working or know why EDIT: Here is the…
Snake
  • 14,228
  • 27
  • 117
  • 250
0
votes
1 answer

JXL + POI : incompatibility

Im first using JXL to modify one xls file created by POI. After that I will try to read that file with POI. In the moment of POIFSFileSystem creation poFileSystem = new POIFSFileSystem(input); Im getting the exception java.io.IOException: block[…
gospodin
  • 1,133
  • 4
  • 22
  • 42
0
votes
1 answer

Getting Excel data as CSV

Please have a look at the following code. I am using JExcel API import java.io.*; import jxl.*; import java.util.*; class ConvertCSV { public static void main(String[] args) { try { //File to store data in form of CSV File…
PeakGen
  • 21,894
  • 86
  • 261
  • 463
0
votes
2 answers

Opening Excel using Jexcel

Hi Guys I am trying to display An excel sheet page in JFrame using this code JFrame frame = new JFrame(); Container cp = frame.getContentPane(); cp.setLayout(new BorderLayout()); File workbookFile = new File("C:\\Workbook.xls"); …
Stanley Mungai
  • 4,044
  • 30
  • 100
  • 168
0
votes
1 answer

Getting number of days difference between 2 dates

I am using jxl api to read an excel file in android. When I get a date like "30/11/2012" from excel, the LabelCell output shows me date as "11/30/12". 1) I need to get the output in dd/MM/yyyy format when reading the excel file, because it exists…
omkar.ghaisas
  • 235
  • 5
  • 19
0
votes
1 answer

Protecting files in Android with a password

I'm making an Android app that generates an Excel file using JExcelApi. The content of the fiel is also available as plain text but it's not stored anywhere (I'm using it for displaying it on a TextView; the content isn't too complex). To simplify…
ziritrion
  • 319
  • 2
  • 8
  • 17
0
votes
1 answer

How to read the values of a dropdown using Jxl API

I have an Excel sheet in which 2 columns have a dropdown with one about 4-5 values and the other with 2 values that can be selected. I would like to read the value that is there for each row in these two columns. . What is the code sample to do…
Raghu
  • 1,141
  • 5
  • 20
  • 39
1 2 3
…
13
14