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

JExcelApi: multiple different formats for parts of a cell?

I wonder whether it's possible to use Java JExcepAPI to create an Excel file cell (Label) containing text "Red Rose Blue Sky" where "Rose" is shown in red and "Blue" is - guess what? So far, it looks like JExcelAPI can set the style for each cell as…
mgaert
  • 2,338
  • 21
  • 27
0
votes
1 answer

Error when call write()

I have error in line: workbook.write(); When I try debug, i see massage: "Source not found." How it fix? private void exportExcel() throws IOException, WriteException{ File file = new File(Environment.getExternalStorageDirectory() +…
Elvis
  • 831
  • 7
  • 9
0
votes
1 answer

email Excel file (in memory) as an attachment on Google app Engine

I googled and tried several approaches but failed. Here is the question: I try to create a excel file (using JExcelApi) and email it as an attachment on google app engine. public void doGet(HttpServletRequest req, HttpServletResponse resp) …
Vincent Zhou
  • 503
  • 1
  • 6
  • 17
0
votes
0 answers

Jspreadsheet v4.9.0 change the data type of cell to text

Jspreadsheet v4.9.0 change the data type of cell to text. Column type is numeric, requirement is for some cells in that column need to change data type to text. Locale settings causes problem when alphanumeric value is populated in cell, when it is…
Balasubramanian Ramamoorthi
  • 67
  • 1
  • 9
0
votes
2 answers

How to get and put columns name of Excel using Java?

How to get column name of Excel sheets using Java? I am using jexcel package for reading from and writing into excel sheet. And also how to change a column name of an Excel sheet?
user934219
  • 1
  • 1
  • 2
0
votes
2 answers

How can I create a Excel Table using Java?

I am using JExcel for creating an excel document. I want to create a Excel table in Excel document using JAVA. I have populated the rows and columns in cells, I could not able to create Excel table and populate data into Excel Table
Dhakshana Murthy
  • 11
  • 1
  • 3
0
votes
2 answers

Using conditional formulas in JExcel

I'm using the javascript library JExcel.js in version 4. I need to insert conditional formulas just like this: =IF(A1<>0,'ZERO','NOT ZERO') But it's giving an error. Is Jexcel able to do that?
Gustavo Menezes
  • 137
  • 9
0
votes
1 answer

Pushing arrays using jexcel plugin to customize a subtitle editor

Please be kind enough to let me know how I can push arrays using the jexcel plugin. https://bossanova.uk/jexcel/v3/ The push functionality must work in the exact same way as for arrays with 6 different colors as shown below. Subtitles = orange,…
Indunil Sanjeewa
  • 1
  • 1
0
votes
1 answer

jexcel load data from ajax with empty cells

Wasim A.
  • 9,660
  • 22
  • 90
  • 120
0
votes
1 answer

Regarding using of external json file in angular 8 and convert into string array

im working in a project where are using a JExcel Grid,in that we are using a json file containing some data and we want to use it in one of the component and we also want to convert the json data into array of string so that we can use that data as…
Aashiq
  • 447
  • 1
  • 12
  • 27
0
votes
2 answers

Reading multiple excel sheet

I am trying to read the sheets of a spread sheet uisng a foor loop. I wanted to know is this the right way of reading especially the use of Sheet Propety [highlighted in the code] : Cell[][] newcell=new Cell[200][200]; int newsheet =…
user756742
  • 33
  • 1
  • 4
0
votes
2 answers

jexcel failed to read DB data

I can successfully load declared hard coded list of array but if I am going to read the data from DB through jquery then pass to jexcel with same object type result it gives me this error: .jexcel is not a function I could even print the same…
Syntax Rommel
  • 932
  • 2
  • 16
  • 40
0
votes
1 answer

Excel Match function not working properly with the MS-Graph API

When sending a match-function post request to an Excel workbook with the MS-Graph API I'm not recieving the value of the first column that contains the lookup value but of the second column that does. let functionArgs = { lookupValue:…
MMF
  • 33
  • 7
0
votes
1 answer

Java Excel Api character codification issue

I'm developing a java application that reads an Excel file and writes it back to a PDF with some processing inbetween. For reading the spreadsheet I'm using the excellent jExcelApi library, and this is a code excerpt: workbook =…
Fel
  • 4,428
  • 9
  • 43
  • 94
0
votes
4 answers

Change Double format - dot to comma

I must change Double format from dot to comma. I try this: DecimalFormat df = new DecimalFormat("#,00", DecimalFormatSymbols.getInstance(Locale.GERMANY)); selectedSheet.addCell(new Number(selectedCellColumn, …
xampo
  • 369
  • 1
  • 7
  • 22
1 2 3
…
13 14