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 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:

⇒Apache POI Examples for Excel Files

⇒⇒FAQ for Apache POI (Poor Obfuscation Implementation)