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 Word Documents

⇐ AligningCells - Apache POI Excel File Example

⇑ Apache POI Examples for Excel Files

⇑⇑ FAQ for Apache POI (Poor Obfuscation Implementation)

2017-03-11, 2410👍, 0💬

ScatterChart - Apache POI Excel File Example
What is ScatterChart example in the Apache POI package? How to run ScatterChart example? ScatterChart example in the Apache POI package is created by Roman Kashitsyn. It illustrates how to create a simple scatter chart in *.xlsx format. ScatterChart example uses the XSSF (OpenXML SpreadSheet Format)... 2017-03-11, 1796👍, 0💬

SimpleDocument - Apache POI Word Document Example
What is SimpleDocument example in the Apache POI package? How to run SimpleDocument example? SimpleDocument example in the Apache POI package is created by Yegor Kozlov. It is a simple Word document in *.docx format created by POI XWPF API. SimpleDocument example uses the OpenXML Word Processing For... 2017-02-22, 1750👍, 0💬

XLS2CSVmra - Apache POI Excel File Example
What is XLS2CSVmra example in the Apache POI package? How to run XLS2CSVmra example? XLS2CSVmra example in the Apache POI package is created by Nick Burch. It works as an XLS to CSV (Comma Separated Value) processor, that uses the MissingRecordAware EventModel code to ensure it outputs all columns a... 2017-03-11, 1483👍, 0💬

SimpleTable - Apache POI Word Document Example
What is SimpleTable example in the Apache POI package? How to run SimpleTable example? SimpleTable example in the Apache POI package is created by Gisella Bronzetti and Gregg Morris. It creates Word documents with tables in *.docx format using POI XWPF API SimpleTable example uses the OpenXML Word P... 2017-02-22, 1433👍, 0💬

Word2Forrest - Apache POI Word Document Example
What is Word2Forrest example in the Apache POI package? How to run Word2Forrest example? Word2Forrest example in the Apache POI package is a Word to XML conversion program that reads a Word document in *.doc format and generates an XML file with text from the Word document. Word2Forrest example uses... 2017-02-22, 1384👍, 0💬

Apache POI Components for Word Documents
What are Apache POI components that can be used to read and write Microsoft Word documents? There are 2 components in the Apache POI Java library that can be used to read and write Microsoft Word document files: HWPF (Horrible Word Processor Format) component provides API to read and write older ver... 2017-02-22, 1326👍, 0💬

Apache POI Examples for Word Documents
Where to find answers to frequently asked questions on Apache POI Examples for Word documents (*.doc and *.docx) files. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on Apache POI Examples for Word documents (*.doc and *.docx) files. Apache POI Compone... 2017-03-11, 1233👍, 0💬

AligningCells - Apache POI Excel File Example
What is AligningCells example in the Apache POI package? How to run AligningCells example? AligningCells example in the Apache POI package is created by Cristian Petrula. It shows how various alignment options work when generating *.xlsx files. AligningCells example uses the XSSF (OpenXML SpreadShee... 2017-03-11, 1204👍, 0💬

BigExample - Apache POI Excel File Example
What is BigExample example in the Apache POI package? How to run BigExample example? BigExample example in the Apache POI package is created by Glen Stampoultzis andAndrew Oliver. It demonstrates many features of the user API at once for *.xls file format. BigExample example uses the HSSF (Horrible ... 2017-03-17, 1137👍, 0💬

All rights in the contents of this web site are reserved by the individual author. FYIcenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.