In this article you were introduced to the Apache Jakarta POI API. You used the HSSF component of the API to programmatically write to and read from a Microsoft Excel Spreadsheet via Java. As Microsoft Excel is one of the most common spreadsheet applications used in offices today, being able to read from and write to spreadsheets represents a much needed asset for enterprise organizations that deal with huge volumes of data. For example, using the POI offerings, a Java programmer can build an application that creates custom Excel based reports populated with dynamically generated data. Your boss wants a bar graph representing the sales of your company for the last three months. Using JDBC, you can gather the needed information from a database and then use the Apache POI API to populate a spreadsheet as needed.
In this article, weíve only glanced at the possibilities unearthed by the Apache POI. You should now feel comfortable in expanding your knowledge of the POI offerings to meet your organizationís needs. You can learn more about the Apache POI project at http://jakarta.apache.org/poi/.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |