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, 1137👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Using JDK (Java Development K...
JDK 11 java.base.jmod is the JMOD file for JDK 11 Base module. JDK 11 Base module compiled class fil...
What Is in Xerces-J-bin.2.12.2.zip? Xerces-J-bin.2.12.2.zip file is the distribution package ZIP fil...
JDOM provides a solution for using XML from Java that is as simple as Java itself. There is no compe...
jlGui is a music player for the Java platform. It is based on Java Sound 1.0 (i.e. JDK 1.3+). It sup...