Create, Read and Write MS EXCEL files from JAVA

Following are the potential of the Apache-POI project APIs, following can be done within java code  itself using link given at the end of this post.

• 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
• 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 Validation
• Embedded Object

Source: Link