Live Breaking News and Articles From the Pharmaceutical Industry

Pharmaceutical News on Ulitzer

Subscribe to Pharmaceutical News on Ulitzer: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Pharmaceutical News on Ulitzer: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Pharmaceuticals Authors: Jolie Conahan, Jason Bloomberg

Related Topics: Java EE Journal, Pharmaceutical News

J2EE Journal: Article

Extentech Inc.: Announcing ExtenXLS Round Trip ReportingTM

New Paradigm in Spreadsheet Reporting

To learn more about Extentech, go to: www.extentech.com

What if you could update and expose business-critical formula logic to your Enterprise applications simply by uploading a spreadsheet to your server?

What if you could seamlessly utilize existing spreadsheets as a data entry tool, requiring zero coding effort and user training to get updated data back into your system?

What if you could combine the interactivity of a spreadsheet containing VB macros with the data and access control provided by your J2EE server?

ExtenXLS does all of this and more.

Extentech Inc. announces its latest development - ExtenXLS Round Trip ReportingTM - a dynamically-generated spreadsheet reporting tool that retrieves business logic trapped in file-based spreadsheets.

Round Trip ReportingTM collects data that is entered into downloaded spreadsheets back to your server-saving endless hours of data updating and retrieval and allowing reuse of existing spreadsheets as a data-entry tool.

Why ExtenXLS?
Every day, important work is misplaced on network drives: lost in inboxes, mistakenly deleted, or simply forgotten. Even when files are properly handled, the data behind the numbers quickly becomes out of date. Without accurate data, businesses risk making vital decisions based on stale information contained in stand-alone spreadsheet files.

Perhaps not as obvious, is the black hole that exists when it comes to the reuse, versioning, and access control of spreadsheet documents. In most environments, spreadsheet files reside in decentralized hard drive directories. Your business critical spreadsheet formulas, charts, pivot tables, and VB routines are simply too important to risk to this haphazard environment.

How it Works
ExtenXLS unlocks business logic tied up on hard drives by parsing spreadsheet files into robust, full-featured Java WorkBook objects. Round Trip ReportingTM provides the ability to download a spreadsheet created by ExtenXLS, edit it, then upload it a server where the modi-fied data is extracted and turned into Java data objects for subsequent use in your programs.

Efficient Report Design & Flexible Output Options
Viewing spreadsheet reports is simple and easy: managers, analysts, and other end users can view the generated spreadsheet reports instantly within their browsers or they can download and open them using any compatible spreadsheet program.

In combination with Servlets and JSP pages, any number and type of data source can easily be used within the same report. Power users, designing their reports using their favorite spreadsheet program, are freed from having to train on yet another report design tool.

Using XML report definition files, ExtenXLS automates data retrieval from any number of sources, executing parameterized queries and placing the resulting values into the appropriate cells of a spreadsheet. ExtenXLS can convert the output spreadsheets to XML for consumption by external programs or to HTML for static delivery to a variety of display devices. Using this same XML definition, ExtenXLS can read modified spreadsheets back in and convert to Java data objects for updating data sources or embedding within your application.

Run Anywhere Robust Java API
As a pure-Java API, ExtenXLS runs on any platform, including all J2EE servers. It's best-in-class Excel compatibility, flexibility and portability makes ExtenXLS a key element for any organization wishing to incorporate reporting capabilities into their heterogeneous IT environment.

Who Uses ExtenXLS?
The world's second largest automobile company depends on ExtenXLS to standardize its data-entry capability for their vendors.

"The application reports key process indicators for parts suppliers. Used by suppliers and employees, it allows the Web application to return formatted data for their use. We needed to give the end user a file that they can easily extract data from and/or manipulate. The form had to allow for both simple (tabular) and complex (charts) data display.

ExtenXLS gave us the ability to use Excel file format and functionality. And it gives the added ability to receive Excel as an electronic form. It is easy to understand and use.

Support has been excellent.

Five packages were evaluated. Only ExtenXLS performed all tests correctly. All the others dropped data or could not support the test."
- Senior Architect, for major automobile manufacturer

Our proven, robust API is the preferred choice of developers of the most demanding applications in the manufacturing, pharmaceutical, and financial services industries including companies such as: Pfizer, Ford Motor Company, and H&R Block.

Proven in Critical Applications
ExtenXLS is used around the world in financial analysis reports, web reporting, statistical charting, and many other applications to create feature-rich reports containing: charts, formatting, text, formulas, and data.

With the power to execute spreadsheet formulas within a Java program, developers are able to reuse existing business logic residing within the spreadsheet documents already available to their organizations.

Visit Extentech online today to download your free trial version of ExtenXLS: http://extentech.com/jdj

For more information, contact us at:
Extentech Inc.
1032 Irving Street #910
San Francisco, CA 94122-2200
Phone: 415-759-5292
Fax: 800-787-6849
email: [email protected]
www.extentech.com

To learn more about Extentech, go to: www.extentech.com

More Stories By IT Solutions Guide

IT Solutions Guide (ITSG), aimed at development and corporate managers, is a free quarterly supplement focusing on the most competitive tools, solutions, and services available in the IT and infrastructure technology world today.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.