Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
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 (309)
Collections:
Other Resources:
XLS2CSVmra - Apache POI Excel File Example
What is XLS2CSVmra example in the Apache POI package? How to run XLS2CSVmra example?
✍: FYIcenter.com
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 and rows.
XLS2CSVmra example uses the HSSF (Horrible SpreadSheet Format) API, which supports Excel files in *.xls format only.
Here is the command to run XLS2CSVmra to convert workbook.xls generated by the BigExample into a CSV file:
C:\fyicenter>\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; org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra workbook.xls > workbook.csv
If you open the output file, workbook.csv, in Notepad editor, you will see data from rolumns and rows from the *.xls file are extracted and displayed in CSV format:
HSSF Test [1]: 0,"TEST",2,"TEST",4,"TEST",6.001,"TEST",8.001,"TEST",10.001,"TEST",... 10000.001,"TEST",10002.0012,"TEST",10004.0014,"TEST",10006.0016,"TEST",... 20,000.002,"TEST",20,002.002,"TEST",20,004.002,"TEST",20,006.003,"TEST",... 30000.003,"TEST",30002.0032,"TEST",30004.0034,"TEST",30006.0036,"TEST",... 40,000.004,"TEST",40,002.004,"TEST",40,004.004,"TEST",40,006.005,"TEST",... 50000.005,"TEST",50002.0052,"TEST",50004.0054,"TEST",50006.0056,"TEST",... 60,000.006,"TEST",60,002.006,"TEST",60,004.006,"TEST",60,006.007,"TEST",... ...
⇒ ScatterChart - Apache POI Excel File Example
⇐ BigExample - Apache POI Excel File Example
2017-03-11, 1483👍, 0💬
Popular Posts:
The JMX technology provides the tools for building distributed, Web-based, modular and dynamic solut...
JDK 6 tools.jar is the JAR file for JDK 6 tools. It contains Java classes to support different JDK t...
What Is jniwrap.jar in JNIWrapper 3.7.1? winpack.jar in JNIWrapper 3.7.1 is an add-on JAR file for J...
What Is poi-scratchpad-3.5.jar? poi-scratchpad-3.5.jar is one of the JAR files for Apache POI 3.5, w...
JDK 11 java.rmi.jmod is the JMOD file for JDK 11 RMI (Remote Method Invocation) module. JDK 11 RMI m...