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

Bhogal, Kulvir S. Dev Articles (2003). Articles>Web Design>Server Side Includes>Microsoft Excel