What are the differences between jxl vs apache poi vs jexcel?

apache-poi xls xlsx jxl jexcelapi
Lucian L. picture Lucian L. · Jul 30, 2013 · Viewed 18.7k times · Source

what are the relevant differences between this libs ? also can tell me anyone about the license of this products ?

i need to generate large files .xlsx files. Until now i used jxl lib in for .xls with a a formated header using jxl.write.WritableCellFormat.

Answer

Yogesh Yadav picture Yogesh Yadav · Jul 3, 2015

1) JXL is now JExcel.

2) You can get all list of differences between JExcel and Apache POI here

3) Both are free.

4)You should use Apache POI because JExcel does not support .xlsx format.

Related questions

Apache POI for Excel: Setting the cell type to "text" for an entire column

I need to generate an .xls (Excel) file, using the Java library Apache POI for spreadsheets. The file will contain a list of phone numbers in column A, formatted as "0221...." or "+49221..." - so Excel by default interprets them as numeric …

Read More
How to get the max no. of columns filled in an XLSX file using POI?

I know we can get the max number of columns by iterating over all the rows and calling getLastCellNumber on each row object.. but this approach requires iterating over all the rows which I want to avoid since it will …

Read More
How to change font color of particular cell apache poi 3.9

I can change foreground color with the following code in apache POI. Now I want to change font color of a single cell. CellStyle style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.GREEN.getIndex()); style.setFillPattern(CellStyle.SOLID_FOREGROUND); cell = rowxl.createCell((…

Read More