The org.apache.poi.hssf.usermodel
package classes are required to generate an Excel spreadsheet. Download the Apache POI library's poi-bin-3.0.2-FINAL-20080204.zip
file from http://www.apache.org/dyn/closer.cgi/poi/ and extract the ZIP file to an installation directory. Install JDeveloper 10g (10.1.3). Install the Oracle database 10g including sample schemas. Create a database instance. Create an example database table from which an Excel spreadsheet will be generated. The SQL script to create example table Catalog
is listed as follows:
CREATE TABLE OE.Catalog(CatalogId VARCHAR(25), Journal VARCHAR(25),
Publisher Varchar(25),Edition VARCHAR(25), Title Varchar(255),
Author Varchar(25));
INSERT INTO OE.Catalog VALUES('catalog1', 'Oracle Magazine',
'Oracle Publishing', 'March-April 2005', 'Starting with Oracle ADF
', 'Steve Muench');
INSERT INTO OE.Catalog VALUES('catalog2', 'Oracle Magazine',
'Oracle Publishing','Jan-Feb 2005', 'Understanding Optimization',
'Kimberly...