Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (322)
Collections:
Other Resources:
XLSX2CSV - Apache POI Excel File Example
What is XLSX2CSV example in the Apache POI package? How to run XLSX2CSV example?
✍: FYIcenter.com
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
2017-03-11, ∼3632🔥, 0💬
Popular Posts:
JDK 17 jdk.internal.le.jmod is the JMOD file for JDK 17 Internal Line Editing module. JDK 17 Interna...
How to download and install mysql-connector-j-8.0.31 .zip?Connector/J Java library is a JDBC Driver ...
How to compare performances of various XML parsers with the jaxp\SourceValidator.jav aprovided in th...
Apache Log4j Core Implementation provides the functional components of the logging system. Users are...
Jackson is "the Java JSON library" or "the best JSON parser for Java". Or simply as "JSON for Java"....