White Papers

Create an Excel Report From Several Oracle Databases Using Apache Jakarta POI

Tags: spreadsheet, open source, excel, linux

Overview Microsoft Excel spreadsheets are ubiquitous in today's business environment. Although Excel can read and display delimited files, the .xls proprietary format provides additional expressive features, including font formatting and multiple sheets per spreadsheet. Many tools - commercial as well as open source - provide a mechanism for producing reports that Excel can read. Depending on the structure and use of particular databases, there are additional reasons why one might produce this type of spreadsheet, but these reasons are dependent upon functional requirements and definitions of particular databases. This paper describes how to use the Apache Jakarta POI open source project to produce a spreadsheet from several different datasources.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Oracle
File Format: HTML
Date Published: Nov 8, 2006
Format: White Papers
Topics: Database Applications

Similiar White Papers

Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features

The IBM System Storage DS8000 and DS6000 Disk Storage systems are both high performance storage systems that offer expan

Publisher: IBM | Tags: data, database, server

Ten Things to Know About Grid Computing on Windows

This Oracle whitepaper offers insights into Oracle Grid.A grid allows a business to add capacity, cheaply, whenever it i

Publisher: Oracle | Tags: application server, computing, database, server

Maxmise IT Flexibility and Lower Costs With Grid Computing

This document discusses grid computing: Oracle's definition of it, the benefits of it, and the elements that comprise an

Publisher: Oracle | Tags: computing, grid computing

SGeRAC and Oracle RAC 10g R2 on HP-UX 11i Best Practices

This paper describes common best practices for configuring clusters with Serviceguard, Serviceguard Extension for RAC (S

Publisher: Hewlett-Packard (HP) | Tags: network

Oracle Database 10g Development With Visual Studio 2005 and the Oracle Data Provider for .NET: Retrieving Data From Oracle Using ODP.NET

Oracle's ODP.NET is a .NET data provider that can connect to and access Oracle databases with tight integrity. It can be

Publisher: Packt Publishing | Tags: applications, data, database

Oracle White Papers

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »