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

Designing a webscraper using selenium webdriver, Jexcelapi and Multithreading

I'm trying to make sure I have my design correct (or at least efficient) for what I'm undertaking for a client. I have a lot of the code written for the GUI and for some of the data extraction, except I fear it may take too long to accomplish on one…
jDave1984
  • 896
  • 4
  • 13
  • 43
0
votes
1 answer

can't find stock price in yahoo finance using selenium webdriver

I've been trying to find a way to pull stock data from yahoo finance for the past two days. I've used selenium webdriver before and I find it very useful, however I can't seem to get it to locate the price for stocks. The html is rather complicated…
jDave1984
  • 896
  • 4
  • 13
  • 43
0
votes
0 answers

JExcel : Saving a workbook without closing it

I am running long computations (run time measured in days) and I am saving the results to an Excel worksheet using the JExcel API. I would like to save the results to disk at regular intervals to prevent any loss of data due to, say, power outages…
user3359546
  • 1
0
votes
1 answer

Detecting struckout text in a cell using JExcelApi

I need to detect whether the text within a cell is struck out or not. I'm using this: Cell cc = sheet.getCell("B1"); CellFormat format = cc.getCellFormat(); System.out.println(format.getFont().isStruckout()); but I remember I read somewhere that…
Geo
  • 93,257
  • 117
  • 344
  • 520
0
votes
2 answers

OutofMemoryError:Java heap space when writing large no. of rows to xls file

I need to write a resultset of more than 1,000,000 rows in xls file(Microsoft 97-xp). So I am trying to use JExcel API But I get error OutOfMemoryError: Java heap space . How do I solve this problem besides increasing JVM memory or creating…
user2994919
  • 1
  • 2
0
votes
1 answer

Writing data to excel in existing sheet every time

Could someone please help me how to append data to excel sheet. I have tried with using jxl.jar file . But every time it creates new sheet. I want to use the existing excel sheet and need to append my data every time my test runs. Here is the code…
KarthickNanjan
  • 11
  • 1
  • 5
0
votes
1 answer

javax.el.ELException: java.lang.NoClassDefFoundError: jxl/read/biff/BiffException

In a JSF 2.x application, I'm using PrimeFaces V-3.5 and JasperReports V-5.2. I am trying to export some reports with JasperReports. I am able to export report in PDF and RTF format; however, Excel format does not work and I encounter error as the…
nudastack
  • 155
  • 1
  • 5
  • 18
0
votes
1 answer

Read an excel sheet in, process it and output it

I am playing around with the jexcel libary I have tried to code a small program which does the following: Read an xls File Make some computaitons in the sheet and write it to another place public class DataProcessor { private String…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
0
votes
2 answers

Null pointer exception with jexcel while writing

I need to append contents to an existing excel file using JExcel. I am trying the following approach: Read from existing workbook workbook = Workbook.getWorkbook(new File(errorFilePath)); Create writable workbook from exisitng workbook into a temp…
willowherb
  • 837
  • 1
  • 13
  • 21
0
votes
1 answer

Getting java.lang.ArrayIndexOutOfBoundsException at jxl.read.biff.SheetImpl.getCell(SheetImpl.java:356)

import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class SpreadsheetRead { /** * @param args * @throws IOException * @throws…
Paras
  • 3,197
  • 2
  • 20
  • 30
0
votes
1 answer

Manipulating and editing an excel file in android app/assets folder

I'm developing an app that has an excel data-base in its assets folder. The app retrieves data from this excel file that's preloaded into the app. Thing is this file has to be updatable from an online server i.e. when I press a button called Update…
Ahmed Zafar
  • 665
  • 2
  • 10
  • 24
0
votes
1 answer

Where to keep my excel file in Android Project

Bit of a n00b question but I plan on using jexcel for an android database I'm making to read from the file and make modifications of it. The excel file will be a part of the program (but will be editable through the app). My question is where do I…
Ahmed Zafar
  • 665
  • 2
  • 10
  • 24
0
votes
2 answers

Method Workbook.createWorkbook method in JexcelAPI throwing indexoutofbounds exception

I am using JexcelAPI in java in order to manipulate excel files. I need to make 2 copies of a Workbook object, one a WritableWorkbook for further manipulation, and one simply to copy from the original Workbook and then save it, so that in case…
Paul
  • 1,106
  • 1
  • 16
  • 39
0
votes
1 answer

How to autoupdate the excel dates using java

I'm automating a scenario in which I need excel file to be updated with current date on daily basis( using java or any macro).For this to update on daily basis,I need to open and close the file so that it can save the current date.I'm using a…
farheen
  • 1,786
  • 1
  • 15
  • 22
0
votes
0 answers

Error occured in copying excel sheet with JExel API

I am using JExcel(2.6.10) and I want to copy sheet . I want to create as like that Open existing Excel file (pre created it as template for don't need to add style and layout) Update or insert required fields return it as ByteArrayOutPutStream for…
Cataclysm
  • 7,592
  • 21
  • 74
  • 123
1 2 3
…
13 14