ExtenXLS API gives you full control over Excel from Java.
Edit by : ExtenXLS bridges the benefits of Java with the ubiquity of Excel by allowing developers to merge external data with Excel thus creating actionable documents from data sources. The toolkit can be used in financial analysis reports, web reporting, statistical charting, and other applications to Create feature-rich Excel reports with charts, formatting, text, formulas, and numerical data. With ExtenXLS, businesses can efficiently deliver critical information throughout an organization in the Worlds most popular and useful reporting format, the spreadsheet.

With the release of ExtenXLS 3.0, Extentech has built on the success of version 2.4, an indispensable tool for developers, architects, and analysts for many of the Worlds most successful companies including JPMorgan/Chase, General Electric, and Equifax.

As a Pure-Java API, ExtenXLS can be run on any platform, including any J2EE server, and can incorporate data from any available source. This flexibility and portability is a key element for businesses looking to incorporate reporting capabilities into existing IT environments without fear of vendor Lock-in.

The new release of the toolkit includes built-in functionality that enables developers to convert spreadsheets to XML format, as well as enhanced support for the modification of Charts, Formulas, and the preservation of Excel Macros.

With ExtenXLS, developers now have the ability to use a single Java command to generate an Excel file that merges data with a template, binding database query results to individual cells on the worksheets. And, with the power to execute Excel Formulas within a Java program, developers can re-use existing business Logic residing within Excel documents already available to the organization.

Managers, analysts, and other end-users can view the generated Excel reports within their browsers, or they can be downloaded and opened using any Excel-compatible program. you can free download ExtenXLS JavaXLS Toolkit 3.0 now.