Home arrow Apache arrow Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API
APACHE

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
TABLE OF CONTENTS:
  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
SEARCH DEVARTICLES

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

The Apache POI contains a number of components. In this article, we’ll be focusing our study on the HSSF component. The HSSF project will provide us with the ability to read and write from XLS spreadsheets.

Gathering What You Need

As stated earlier, we’ll be using the Apache POI API to manipulate a spreadsheet. You can download that spreadsheet here (sales.xls). You also need to download the Apache POI jar files. These are available at http://www.apache.org/dyn/closer.cgi/jakarta/poi/. At the time of this article’s writing, the Apache POI was in version 1.5.1.


blog comments powered by Disqus
APACHE ARTICLES

- 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 
Support 

Developer Shed Affiliates

 




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