Home arrow Apache arrow Page 4 - Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API

Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API

The Apache Jakarta POI project consists of Java APIs dedicated to the manipulation of files based on Microsoftís OLE 2 Compound Document format. In this article, youíll learn how to use the APIs of the POI project to read from and write to Microsoft Excel spreadsheets. As you will see, the programmatic liberty to manipulate Excel files represents a powerful offering to the Java programmer.

Author Info:
By: Kulvir S. Bhogal
Rating: 4 stars4 stars4 stars4 stars4 stars / 65
November 26, 2003
  1. · Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API
  2. · Letís Learn How to Write to a Spreadsheet
  3. · Letís Learn How to Read From a Spreadsheet
  4. · Conclusion

print this article

Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API - Conclusion
(Page 4 of 4 )

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.

blog comments powered by Disqus

- Programmatically Manipulating Microsoft Exce...
- Installing PHP under Windows
- Compressing Web Content with mod_gzip and mo...
- Compressing Web Output Using mod_deflate and...
- Setting Up Apache 2.0.45 to Parse PHP Pages
- Custom Error 404 Documents with PHP
- Using Apache and PHP on Mac OS X
- ASP: Active Sessions, Active Logins and Tota...
- Working With Oracle on Windows: Part 1
- The Quick-n-Dirty Guide to Setting Up Apache...
- Installing Apache With SSL: The Complete Gui...
- 7 Powerful .htaccess Customization Tips
- Trap And Get Notified: A Practical Solution ...
- One Way To Use Server Side Includes
- Using ForceType For Nicer Page URLs

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials