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

tomcat-8.0.20 - Javamail don't send emails with attachments

Hi I just wanted to ask for advice I am really thankful to those who can suggest any. Thanks in advance. I am trying to send an email with attachment it is working if I run it in desktop application netbeans maven however if it I run it in tomcat it…
Wonderer
  • 65
  • 8
1
vote
0 answers

Sort JXL Sheet alphabetically in JAVA

I need to sort a column in alphabetical order. The excel sheet is generated with groovy (or java) with the JXL API. I found a class in jxl 2.6.12 that implements a new feature jxl.write.biff.sortRecord). But it's not well documented and with no…
Hamza Amamy
  • 31
  • 6
1
vote
1 answer

Reading .CSV in Java containing Backslash

I'm having an issue when I read cells with '\' in it and then try to replace it to '\' because of java escape property. For example: "Error: The provided P\jb credenti" When I read this directly from a Cell using: if (type == TStream.Spreadsheet) { …
Matheus Bica
  • 1,055
  • 3
  • 13
  • 23
1
vote
1 answer

How to freeze a complete row in Excel with JExcelApi?

I'm generating xls files using JExcelApi. Now what I need is to lock the headers because I have more than 300 rows. Whenever I scroll I need to have headers to be shown. Can anyone help me to solve this. I have explored many sites but I didn't get…
Bhanu
  • 155
  • 1
  • 2
  • 15
1
vote
1 answer

Can't retrieve value of a computed cell using JExcelAPI

This is my first post, please bear with me. I'm trying to do something simple: look at the value of a spreadsheet cell that contains a formula. Nothing seems to work, instead of the correct answer (579) , I get "4". (output below). This program…
Michael L
  • 11
  • 1
1
vote
0 answers

JExcel: How to extract values from excel cell that are computed using formula?

I am using Jexcelapi for read of.xls excel worksheets. The problem is to read the cell value that is generated by computing formula. How to read the numeric cell value or string cell value from excel through java implementation?
silika thapa
  • 11
  • 1
  • 5
1
vote
1 answer

Using the JExcel API, how do I enter a cell value of unknown data type without a hidden apostrophe being added?

I'm using the JExcel API to create an XLS file. I can't figure out how to populate a new cell without any specific cell formatting. I would like the formatting to be automatically applied, as it does in Excel when you type a value in a cell and it…
Mike M. Lin
  • 9,992
  • 12
  • 53
  • 62
1
vote
0 answers

How to abstract and export multiple table data in a single excel file?

I am generating an Excel file with JExcel and trying to display multiple table values. @RequestMapping(value = "/resilenceCenterExcel", method = RequestMethod.GET) public void defaultPageExce654(ModelMap model, HttpServletRequest…
farooq sheikh
  • 11
  • 1
1
vote
3 answers

How to read excel using jexcel?

i am trying to read an Excel file using Java code however i am getting following error : jxl.read.biff.BiffException: Unable to recognize OLE stream when i searched on net i found jExcel supports only upto excel 2003, and this error comes when…
Simran
  • 61
  • 1
  • 3
  • 4
1
vote
1 answer

Jexcel editing existing file

package Mundo; import java.io.*; import jxl.*; import jxl.read.biff.BiffException; import jxl.write.*; public class ExcelIO { public static void main(String[] args) throws BiffException { toExcel("testName", "65", "180", "80", "120",…
Gabriel Luque
  • 117
  • 11
1
vote
2 answers

Import file excel does not enough number

I use jxl library to import data from excel. I have a cell with values : 8.628282828. When i debug as below image : I see it is type : NumberRecord and values is right : 8.628282828. But when i get content of cell : InputStream is = new…
TungHarry
  • 1,097
  • 11
  • 26
1
vote
1 answer

How to set WorkBookSetting in Apache POI for whole WorkBook

Currently I am Using JExcel to read existing xls. To set character encoding of workbook, I am using following code. WorkbookSettings ws = new WorkbookSettings(); String language=// if(!"en".equals(language)){ ws.setEncoding("Cp1252"); } WorkBook…
the-dumb-programmer
  • 485
  • 3
  • 14
  • 27
1
vote
0 answers

Load Tree based xls using a Java API

How to read a tree based xls using a Java API like Apache POI, etc. I want to read a xls which is in a tree based format i.e the data is grouped.
rkg
  • 175
  • 3
  • 13
1
vote
1 answer

jxl - MS Excel compatibility error

I'm trying to generate an Excel report using jxl API - but I have been facing compatibility issues with MS Excel. The generated report which contains some styles such as bold fonts, auto resized cells, etc. works like a charm with LibreOffice Calc.…
talha06
  • 6,206
  • 21
  • 92
  • 147
1
vote
1 answer

Format Change in XLS file with JExcel API

We have an issue where in the Format of the cells set as "Numeric Forrmat" in xls template is getting nullified (or) changed to General when the value is set from Java Code using JExcel API. NumberFormat nf = new NumberFormat("#####.###"); …
Sandeep540
  • 897
  • 3
  • 13
  • 38
1 2 3
…
13 14