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

SOFTWARES

UBUNTU:
Google Chrome web-browser
Adobe Flash Player
Picasaflock web-browser
MiniLyrics Alternative
Oracle XE(Express Edition)

Windows XP:
Youtube Video Download S/W