What is better open source to parse Excel files in Java?

What is the best API for excel parsing in Java Apache POI or JExcel API? In terms of speed, memory usage and code stability.

+3
source share
4 answers

Personally, I would recommend a POI over JExcel. The reasons that I chose POI over JExcelAPI are:

  • POI supports both old and new MS Excel sheet formats.
  • It has a cleaner API (imho)
  • As far as I can see, it does not suffer from the annoying Date \ Time problems that JexcelApi has ( Date Display ).

. POI, , API. , factory , usermodel. , , Excel, , .

, Worksheet. JExcelApi "" "" , . , , "" "" .

, POI (POI HSSF) JExcelApi. , POI HSSF ( ) POI XSSF ( ). , - , XML.

+7

Apache POI, , OpenXML Office 2007/8. JExcel . Apache POI Office.

. Excel ( ), ( ). POI , . Excel , .

+2

Apache POI , ( ) JExcel (JExcel OpenXML, notnoop)

0

JExcelAPi , Apache POI, , Excel 2007.

0

Source: https://habr.com/ru/post/1722955/


All Articles