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

JXL api issue: Standard out displays rounded off decimal instead of actual number

When I try and print out the content in a cell containing a number with five decimal places, the number is automatically rounded off to 3 d.p. This is what I have so far: Cell cellNum = sheet1.getCell(col,row); WritableCell cell =…
Paul O.
  • 5
  • 4
0
votes
1 answer

Error 'java.lang.IllegalArgumentException Invalid format is malformed at' using jxl

Hello I'm trying to read a date value from an excel file using jxl, I have no problem with the other values but the date displays an error that says java.lang.IllegalArgumentException: Invalid format: "342/Dec/17" is malformed at "/Dec/17", am I…
MSV123
  • 39
  • 8
0
votes
1 answer

outOfMemoryException while reading excel data

I am trying to read data from an excel file(xlsx format) which is of size 100MB. While reading the excel data I am facing outOfMemoryException. Tried by increasing the JVM heap size to 1024MB but still no use and I cant increase the size more than…
Pavan Kumar O V S
  • 1
0
votes
0 answers

Only edit Excel sheet with Jexcel

I have to create an application in java to help filling data in Excel file with multiple sheets. The problem is I need to call my function write every time I insert data and currently everytime it does replace my actual file by an new one. I…
LoP Castro
  • 25
  • 8
0
votes
0 answers

Excel file isn't downloaded with spring and JExcel Api

I need a downloadedable excel file by clicking a link I use Spring and JExcel Api This is controller: @RequestMapping(value = "/download", method = RequestMethod.GET) public ModelAndView generateScheduleReport(HttpServletResponse response) { …
cadmy
  • 515
  • 12
  • 32
0
votes
1 answer

JExcelApi does not work in Android

When i click the button nothing happens; i have given external write permissions in manifest file. What is wrong? Thank you in advance. (code is jumbled up i will straighten it later sorry) Here's my code: excelButton.setOnClickListener( …
Fractal
  • 88
  • 1
  • 6
0
votes
1 answer

Office Addin fails to load in Excel 2013 when requirement set for Excel API 1.2 is added in manifest

Excel addin which uses Excel API 1.2. Add-in loads fine in Excel 2016 for Windows and Excel online. Save the file from Excel online and open in Excel 2013, addin fails to load in Excel 2013 with following errors: When loading the Addin published in…
Pradip Fopse
  • 1
  • 1
0
votes
1 answer

How to mantain formatting in Excel with JExcel

I'm using JExcel API to open and edit an existing .xls file. First problem was that I can't directly edit the opened xls file. I need to make a copy of that first. (Question1: It is possible to edit the opened workbook or not?) My solution to that…
João Pereira
  • 673
  • 1
  • 9
  • 29
0
votes
1 answer

JExcel Output Issues

I'm trying to write out to an Excel Sheet in Java using JExcel. I successfully write out, however I keep running into the "java.lang.OutOfMemory: Java heap space" error. From what I've read there are two solutions. 1) Change My Eclipse settings,…
user387049
  • 6,647
  • 8
  • 53
  • 55
0
votes
0 answers

I want to extract data with formatting from jexcel library

I am creating an app which will view excel files within my app without going to any third party app. So for this i have used jexcel library. I am able to retrieve data from any Excel file through this library. This is my code. import…
Pratibha Mache
  • 11
  • 2
0
votes
0 answers

AppCompat crash when adding jar

I have a big problem with Android Studio. I am actually coding a basic accelerometer and I want to export the data to excel. To accomplish this I've decided to add jexcel api in my project. Well, the problem is that when I add the jar jxl.jar in my…
Roman Panaget
  • 1,578
  • 12
  • 21
0
votes
1 answer

jexcel - transpose question

I am trying to work with JExcel API and had the following question. I have queried my database tables for 3 columns: id, time, value. I am adding them into different arrays as objects. I want to output them into an excel sheet as follows: id …
JJunior
  • 2,831
  • 16
  • 56
  • 66
0
votes
2 answers

Installing jexcelapi

how do you use the third party libraries? I have downloaded it, but am unsure what to do with it, do i place it in my eclipse project folder etc? I did look on the website but to no avail Thanks
Ricki
  • 13
  • 2
  • 4
0
votes
2 answers

how to pass a string value in for loop to 2 dimensional array in java

import java.io.*; import java.util.*; import jxl.*; import jxl.read.biff.BiffException; public class ExcelIO { // A factory method which takes in an excel file and reads in the contents. public static void readData(String args[]) throws…
Padmini
  • 1
0
votes
1 answer

How to use JExcel WritableFont in ColdFusion

How can I use WritableFont in ColdFusion ? variables.labelObj=loader.create("jxl.write.Label"); variables.numberObj=loader.create("jxl.write.Number"); variables.formulaObj = loader.create("jxl.write.Formula"); variables.cellColor =…
Egemen Ates
  • 51
  • 4
1 2 3
…
13 14