HSSF和XSSF的區別:
http://poi.apache.org/spreadsheet/index.htmlhttp://poi.apache.org/spreadsheet/quick-guide.html
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