|Apache | POI||
HSSF and XSSF Examples
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.
The ConditionalFormats demo is a collection of short examples showing what you can do with Excel conditional formating in POI:
The ToHtml example shows how to display a spreadsheet in HTML using the classes for spreadsheet display.
The ToCSV example demonstrates one way to convert an Excel spreadsheet into a CSV file.