Java201.com

• Generate External Tables from an Excel Spreadsheet Using Apache Jakarta POI by Casimir Santeros   - [Clicks: 344]
  In this article you will learn how to use the Apache Jakarta POI open-source project to create external tables referencing data contained in an Excel spreadsheet with multiple sheets of data. During this process you will create a custom utility named ExternalTableGenerator to accomplish this goal. Given an Excel spreadsheet containing one or more sheets with data, the ExternalTableGenerator utility generates flat datafiles and a DDL script that users can run to view the data as an external table. This project can also help clarify external table concepts for those who are new to the feature. The article includes the source code for the ExternalTableGenerator, which can be used as a standalone application or as a basis for a more sophisticated and robust solution, and a sample spreadsheet for testing the process.
  http://www.oracle.com/technology/pub/articles/saternos_tables.html - Mar, 2005
• Manage Database Metadata with POI and Excel by Doug Tillman   - [Clicks: 183]
  Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
  [Includes source code]
  http://www.devx.com/dbzone/Article/26722 - Jan, 2005

[Top]