Apache -poi

Busy Developers' Guide to Features

                Want to use HSSF and XSSF read and write spreadsheets in a hurry?  This                 guide is for you.  If you're after more in-depth coverage of the HSSF and                 XSSF user-APIs, please consult theHOWTO                guide as it contains actual descriptions of how to use this stuff.           

Index of Features

• How to create a new workbook
• How to create a sheet
• How to create cells
• How to create date cells
• Working with different types of cells
• Iterate over rows and cells
• Getting the cell contents
• Text Extraction
• Files vs InputStreams
• Aligning cells
• Working with borders
• Fills and color
• Merging cells
• Working with fonts
• Custom colors
• Reading and writing
• Use newlines in cells.
• Create user defined data formats
• Fit Sheet to One Page
• Set print area for a sheet
• Set page numbers on the footer of a sheet
• Shift rows
• Set a sheet as selected
• Set the zoom magnification for a sheet
• Create split and freeze panes
• Repeating rows and columns
• Headers and Footers
• Drawing Shapes
• Styling Shapes
• Shapes and Graphics2d
• Outlining
• Images
• Named Ranges and Named Cells
• How to set cell comments
• How to adjust column width to fit the contents
• Hyperlinks
• Data Validations
• Embedded Objects
• Autofilters
• Conditional Formatting
• Hiding and Un-Hiding Rows