Skip to main content


Showing posts from July, 2011

Manipulating excel files in Java

We many times come across this situation where we want to create or edit excel files in java, although there are many open source libraries available out there which allows us to create or edit excel files in java but the most stable among them which I think is Apache Poi. Apache Poi library allows creation and editing of excel files. This library supports traditional 2003 format and 2007 format also.
Apache Poi library supports excel macros, cell customization(cell color, text color, cell background color) and much more.
Although Poi supports both xls and xlsx files, xls files are manipulated smoothly but xlsx file manipulating requires much more RAM and time for processing than that of xls.
Poi has two classes HSSFWorkbook for xls files and XSSFWorkbook for xlsx files, both implements to Workbook interface. You can create multiple workbook sheets.
In next post I will show how to use Apache Poi API to manipulate excel files.

No new posts :-(

Well this blog is not dead, actually I am busy due to office work and not getting time to post new posts on blog. But as soon I will get free time I will post new things which I came to know and want to share them... :-)