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

Why does the same android java code shows different languages on device Nexus 7 and device Nexus 5x

System environment: Android Studio 3.4 with Gradle plugin to version 3.4.0 and Gradle to version 5.1.1. I created a new project --> File --> New --> Import Sample --> Ndk --> Hello JNI. I changed in build.gradle file minSdkVersion to 22, because…
hatietz
  • 1
  • 1
0
votes
1 answer

Jexcel removes all cells and leaves a number 1 on an if statement

When trying to run an if statement with Javascript on a Jexcel to look at Cell 1,1 it seems to remove all the cells and leaves just one cell with a number 1 in it. I am new to Javascript so it is quite possible I am just not understanding it well…
Kyoujin
  • 315
  • 1
  • 5
  • 19
0
votes
1 answer

().jexcel not a function

I would like to ask why the console always prompt that "TypeError: $(...).jexcel is not a function" when i try to convert the data of the table in jexcel plugin into JSON. Here's my code: Import Excel …
jayromel lawas
  • 25
  • 7
0
votes
0 answers

Can't read a cell value from using Jexcel API

I am trying to read a .xls file by JExecel Api. I can read some column data by using cell.getContents() easily. But some column give me mysterious value 1, but column type looks like Date. So i check those column type and Find they are Number Type.…
Mahbubur Rahman Khan
  • 375
  • 3
  • 22
0
votes
2 answers

Prevent Excel making URL clickable in file created by JXL API

I use JExcelApi (JXL, version 2.6.12) to create an Excel file. If a cell has an URL as value, then that cell is displayed in Excel* as plain text, but if the user double-clicks it (an thus enters edit mode), and then immediately clicks somewhere…
David Balažic
  • 1,319
  • 1
  • 23
  • 50
0
votes
0 answers

Cannot resolve symbol "AbstractJExcelView"

I am writing a simple spring mvc application that writes the content in the xls format: public class ExcelBuilder extends AbstractJExcelView { @Override protected void buildExcelDocument(Map model, …
Arul Suju
  • 706
  • 1
  • 9
  • 21
0
votes
2 answers

Tomcat error java.lang.ClassCastException:

Hi I am using maven I am trying to generate excel then send it as attachment to email in netbeans I am not gettig any error however in my tomcat I am getting error below I will really appreciate any hel or advice thank you my pom …
Wonderer
  • 65
  • 8
0
votes
1 answer

Generate Excel from database data using JEXCEL API and netbeans Maven then send it as attachment to email

Hi I am trying to learn jexcel api if I am running it through a main class its actually working and generating the excel file however if I put in maven plugin I cannot find the generated excel anymore I am not getting error it keeps saying excel…
Wonderer
  • 65
  • 8
0
votes
1 answer

faced with date parsing problem in jexcel api

I have created a file named tablenew.xls which has date with following code: DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); Date date = (Date)formatter.parse(st[length]); datecell=new…
CyprUS
  • 4,159
  • 9
  • 48
  • 93
0
votes
1 answer

not able to parse string into date using jexcel api

I am faced with a problem i faced a few days ago. i have to parse this file and convert the string into date. I had done the same to another CSV file few days ago. However, the new file is giving this error: java.text.ParseException: Unparseable…
CyprUS
  • 4,159
  • 9
  • 48
  • 93
0
votes
1 answer

How to convert a string to Date and then add it to excel using jexcel api

I am currently reading a CSV file. I have to extract the dates from it and add them to excel file in dd-MM-yy format. I am faced with two problems. I am using String.split(delim) where, delim="[,]". I am getting the date in yyyy-MM-dd format. I am…
CyprUS
  • 4,159
  • 9
  • 48
  • 93
0
votes
1 answer

NETWORKDAYS.INTL support missing in Apache POI

I am using Apache POI 3.9 library & noticed that it complains me of below error for excel function Name 'NETWORKDAYS.INTL' is completely unknown in the current workbook Is this formula supported in Apache POI ?.
user8373873
  • 31
  • 8
0
votes
1 answer

How to Track Changes with jexcelapi or Apache HSSF

I am writing an MS Excel file with Java and what to set the "Track Changes" flag so I can see where people make modifications later. How can I set this flag in either jexcelapi or Apache HSSF?
Tony Merrit
  • 171
  • 2
  • 6
0
votes
1 answer

Keeping Pivot Table and Formating intact in JExcel

I am trying to write data to an excel sheet using JExcel. I have an excel file placed on disk and I opened it using JExcel and then created a Writable Workbook. The Excel workbook contains sheets having pivot table. Idea is to just populate source…
Muhammad Salman Farooq
  • 1,325
  • 9
  • 26
  • 54
0
votes
1 answer

Can not write to excel file using JexcelAPI

import java.io.File; import java.io.IOException; import jxl.*; import jxl.write.*; import jxl.write.Number.*; import jxl.Cell; import jxl.CellType; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class reader…
Ivan Chemeris
  • 1
1 2 3
…
13 14