| Search 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 ### Business Plan 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). ### Calendar The Calendar demo creates a multi sheet calendar. Each month is on a separate sheet. ### Loan Calculator The LoanCalculator demo creates a simple loan calculator. Demonstrates advance usage of cell formulas and named ranges. ### Timesheet The Timesheet demo creates a weekly timesheet with automatic calculation of total hours. Demonstrates advance usage of cell formulas. ### Conditional Formats The ConditionalFormats demo is a collection of short examples showing what you can do with Excel conditional formating in POI: Highlight cells based on their values Highlight a range of cells based on a formula Hide errors Hide the duplicate values Highlight duplicate entries in a column Highlight items that are in a list on the worksheet Highlight payments that are due in the next thirty days Shade alternating rows on the worksheet Shade bands of rows on the worksheet ### ToHtml The ToHtml example shows how to display a spreadsheet in HTML using the classes for spreadsheet display. ### ToCSV The ToCSV example demonstrates one way to convert an Excel spreadsheet into a CSV file. by Yegor Kozlov