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:
BigExample - Apache POI Excel File Example
What is BigExample example in the Apache POI package? How to run BigExample example?
✍: FYIcenter.com
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 SpreadSheet Format) API, which supports Excel files in *.xls format only.
Here is the command to run BigExample to generate a sample *.xlsx file. Note that poi-ooxml.jar is not needed for HSSF API.
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.usermodel.examples.BigExample
If you open the output file, workbook.xls, in Excel, you will see a sample text as shown below:
⇒ XLS2CSVmra - Apache POI Excel File Example
⇐ WorkingWithFonts - Apache POI Excel File Example
2017-03-17, 1173🔥, 0💬
Popular Posts:
layout.jar is a component in iText Java library to provide layout functionalities. iText Java librar...
JDK 11 jdk.crypto.mscapi.jmod is the JMOD file for JDK 11 Crypto MSCAPI module. JDK 11 Crypto MSCAPI...
What Is javamail-1_2.zip? javamail-1_2.zip is the binary package of JavaMail API 1.2 in ZIP format. ...
JasperReports, the world's most popular open source business intelligence and reporting engine and J...
What Is commons-codec-1.4.jar? commons-codec-1.4.jar is the JAR file for Apache Commons Codec 1.4, w...