Search Results for "apache poi"

EasyExcel is a Java library focused on reading and writing Excel files with very low memory usage, making it suitable for large datasets that overwhelm traditional APIs. It uses streaming/event-driven parsing to avoid loading entire workbooks into memory, and it maps rows to Java objects via simple annotations. Writers support multiple sheets, custom styles, merged cells, and template-based filling so production reports remain maintainable. The API emphasizes developer ergonomics: callbacks...

I was unable to find a minimal XLSX (Excel) parser. The closest free option would be apache POI with about 8+ megabyte of JARs and features I don't need. The input is an XLSX file and the output is a Map<String,String[][]> with key of 'sheet name' and a String[][] of cell data. Dates are reformatted to dd/MM/yyyy (configurable in the code). The output of String[][] is to keep the interface compatible with CSV (eg. OpenCSV).

...Of the first objective, was born the OLExcel library, which lets use the OLE Compound File technology (http://msdn.microsoft.com/en-us/library/dd942557.aspx), using the Apache POI library (http://poi.apache.org). OLExcel greatly simplifies the job of creating Excel files using Java through OLE2.0 technology. Of the second objective, was born the JForex2Excel system, that making use of the OLExcel library, send data from the JForex platform to a file in Excel format.

A JSP taglibray for creating Excel spreadsheets. Based on Apache POI