Advertisement
Promo

Databases Toolkit

Download now

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

PublisherOracle
Format HTMLDate added08 Nov 2006
Topics Database Applications
Downloads123

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.

Download now

Did you find this white paper useful?
30 out of 50 users found this white paper useful


  • Trackback
  • Clip Link

Related white papers

Improving the Accuracy of Spend Analysis through Data Quality

Organisations can spend as much as 60 percent of revenue to acquire the goods and services necessary to conduct business. Procurement professionals are being asked to reduce the organisation's overall...


The ROI of Data Governance: Seven Ways Your Data Governance Program Can Help Save You Money

In difficult economic climates, responsible leaders look for opportunities to contain costs. Data governance programs are well positioned to assist in these efforts. This white paper from Gwen Thomas of...


Observing Data Quality Service Level Agreements

This white paper by David Loshin from Knowledge Integrity examines how to measure data quality and what to do when the data does not meet the level of acceptability. When...


Populating a Data Quality Scorecard with Relevant Metrics

Too often, data governance teams rely on existing measurements as the metrics used to populate a data quality scorecard. But without a defined understanding of the relationship between specific measurement...


ADO RecordSet CursorLocation and CursorType

During this webcast, the presenter will talk about the CursorLocation and the CursorType properties of the ADO Recordset object. The presenter will also discuss how these properties affect the functionality...


FreshDirect Improves Technology Infrastructure Scalability and Lowers Total Cost of Ownership

FreshDirect is one of the nation's leading online fresh food delivery services. The company wanted to scale to support an ever-growing number of concurrent online customers, while lowering total cost...


Starwood Hotels & Resorts Worldwide, Inc. Creates Highly Available and Easily Managed IT Foundation

Starwood Hotels & Resorts Worldwide, Inc. is one of the world's leading hotel and leisure companies with approximately 850 properties in more than 95 countries. The challenge was to create...


Broadband Deals? Powered by Top 10 Broadband

150+ broadband packages

Compare 30+ mobile broadband deals

Mobile Broadband »
White Paper

Featured White Paper

Technical Description: IBMXIV Storage System

The IBMXIV® Storage System offers a new level of high-end disk system performance and reliability. It is a core component of theIBMInformation Infrastructure which helps clients address their needs for availability, security, compliance and retention of information. The XIVsystem provides consistency under all conditions, immunity to hotspots, ...

Download Now

Other White Papers

Best Practices for Translating Customer Satisfaction into Revenue

Today's support organisations are focused on two top-level metrics: financial results and customer...

Data Quality Considerations for a Master Data Management Structure

Companies acquiring companies. Human Resources sharing information with Finance. Businesses...

See All White Papers


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters