XLSX2CSV - Apache POI Excel File Example

Q

What is XLSX2CSV example in the Apache POI package? How to run XLSX2CSV example?

✍: FYIcenter.com

A

XLSX2CSV example in the Apache POI package is a rudimentary XLSX to CSV processor modeled on the POI sample program XLS2CSVmra.

XLSX2CSV example uses the XSSF Event SAX helpers to do most of the work of parsing the Sheet XML, and outputs the contents as a (basic) CSV.

XLSX2CSV example uses the XSSF (OpenXML SpreadSheet Format) API, which supports Excel files in *.xlsx format only.

Here is the command to run XLSX2CSV to convert xssf-align.xlsx generated by the AligningCells example into a CSV file:

C:\fyicenter>c:\local\jdk-1.8.0\bin\java 
   -cp .;C:\local\poi-3.15\poi-examples-3.15.jar;
         C:\local\poi-3.15\poi-3.15.jar;
         C:\local\poi-3.15\poi-ooxml-3.15.jar;
         C:\local\poi-3.15\ooxml-lib\xmlbeans-2.6.0.jar;
         C:\local\poi-3.15\lib\commons-collections4-4.1.jar;
         C:\local\poi-3.15\poi-ooxml-schemas-3.15.jar 
   org.apache.poi.xssf.eventusermodel.XLSX2CSV xssf-align.xlsx

Sheet0 [index=0]:

"Align It","Align It","Align It","Align It","Align It","Align It","Align It"
,"Align It"   

 

Apache POI Examples for Excel Files

⇒⇒FAQ for Apache POI (Poor Obfuscation Implementation)

2017-03-11, 578👍, 0💬