HSSF and XSSF Examples

POI 3.5 and later comes with a number of examples that demonstrate how you can use POI API to create documents from "real life". The examples are based on common XSSF-HSSF interfaces so that you can generate either *.xls or *.xlsx output just by setting a command-line argument:

          BusinessPlan -xls 
          or
          BusinessPlan -xlsx
        

All sample source is available in SVN

The BusinessPlan application creates a sample business plan with three phases, weekly iterations and time highlighting. Demonstrates advanced cell formatting (number and date formats, alignmnets, fills, borders) and various settings for organizing data in a sheet (freezed panes, groupped rows).

The Calendar demo creates a multi sheet calendar. Each month is on a separate sheet.

The LoanCalculator demo creates a simple loan calculator. Demonstrates advance usage of cell formulas and named ranges.

The Timesheet demo creates a weekly timesheet with automatic calculation of total hours. Demonstrates advance usage of cell formulas.