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

xPath expression in Java

I have the following xml file:
MegaCleptomaniac
  • 133
  • 12
0
votes
0 answers

Iterating metadata.getColumnCount()

Basically I am trying to read multiple queries from excel sheet through jexel and I am adding the cell contents to Key and Value in hashmap. For example A1=1 (Key) , A2 =2 .... B1 = "SELECT * FROM ABCD;" (Value), B2 = "SELECT * FROM…
WolfSkin
  • 73
  • 4
  • 10
0
votes
1 answer

Unable to write test results in existing excel using JExcelApi

I am unable to write test results in existing excel using selenium I have tried but always new sheet override my existing sheet String usernamevalidationmsg = a.findElement(By.id("UserNameRequired")).getText() String…
bala raju
  • 41
  • 1
  • 3
0
votes
1 answer

How to get calculated value of the formula? here cell that contains a formula

I am using JExcel API, to read the contents of a existing excel file. I am trying to read a cell that contains a formula, and displays the calculated value in that cell. For example : 25 = (a1 * b1), where 456 is displayed in the cell. Using JExcel…
Pooja Singh
  • 1
  • 1
0
votes
1 answer

How to hide different columns in different sheets of Excel using jXLS library to generate excel reports

I am using jXLS library to generate excel reports. I am using a generic template for all the reports and the column headers are populated from query result set metadata. My generic template would contain 50 columns and if the result set has only…
Pro
  • 582
  • 2
  • 8
  • 23
0
votes
1 answer

Date format is written as numerical value after multiple writes in JXL

I am using JXL (JExcelAPI) to write data to excel. One of the columns is date column and I am adding a lot of rows per sheet (225+). I have 3 sheets and each sheet has a date column. First sheet works fine. Second sheet works fine up to like 40…
Snake
  • 14,228
  • 27
  • 117
  • 250
0
votes
1 answer

Browsers freeze by file download

I got a problem when files were download , I can't get any actions or events when clicking any links , butttons and menues after download process was done. Below is my codes for excel file download button ... Button btnDownloadExcel = new…
Cataclysm
  • 7,592
  • 21
  • 74
  • 123
0
votes
1 answer

Jexcel and choice of type of variables

The code is: package reader; import java.io.File; import java.io.IOException; import java.util.ArrayList; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class ReadExcel { public static void…
sarah
  • 1
0
votes
1 answer

How to can process xlsx file (from template) in Java?

In my application we generate Excel files using JExcel API which allows us to use XLS templates file. Now we must also manage XLSX format, but JExcel can not handle this format. What other API can be used ? I wanted to use POI but it does not take…
Ousmane MBINTE
  • 664
  • 4
  • 15
  • 37
0
votes
1 answer

JExcel doesn't copy Array formula

I open excel file by JExcel, modify some cells and save it. As result Array formulas({ ... } CTRL+SHIFT+ENTER) was broken. Does anybody know what to do? (FormulaException is rasing during copy)
Fletcher
  • 1
  • 1
0
votes
2 answers

JExcel getCellFormat() always null

I have a problem with Jexcel. I want read an excel file and detect for each cell the background color. I'm doing in this way : Cell cell = sheet.getCell(i, j); Colour cellColor = cell.getCellFormat().getBackgroundColour(); I have always…
Suxper
  • 31
  • 5
0
votes
2 answers

getting file not found exception when working with jExcel

I am relatively new to java. I am writing a piece of code that will work with excels. For that purpose i am using jExcel API. Now my code is like this. import java.io.File; import jxl.*; class main{ private File outputFile; private String …
Roy
  • 15
  • 3
0
votes
2 answers

Empty cells issue when extracting excel data using POI in JAVA?

I have just Extracted the cells from the excel sheet using Apache POI, everything is working fine. But whenever there is an empty cell, the very next right cell data is what I get as a output. But, if exists a value in the latter, the desired output…
i2ijeya
  • 15,952
  • 18
  • 63
  • 72
0
votes
2 answers

How to Edit/Modify an existing Excel file in Java with Jexcel API

I want to edit an existing Excel file with Java, to add some more data to an existing template excel file. So i used Jexcel for this purpose. As suggested everywhere, I tried the following, Workbook existingWorkbook = Workbook.getWorkbook(new…
hsemarap
  • 227
  • 3
  • 15
0
votes
1 answer

getting FileNotFoundException when trying to read an excel file from resource directory

I am getting FileNotFoundException when trying to read a .xls file from src/main/resources InputStream is = ReportGenerationServiceImpl.class.getResourceAsStream("/bqp_template.xls"); Workbook workbook = Workbook.getWorkbook(is); this is my…
Amit
  • 97
  • 1
  • 1
  • 8
1 2 3
…
13 14