Digital Edition

SYS-CON.TV
Extentech Inc: It's 1 a.m. - Do You Know Where Your Business Logic Is?
If it's locked up in a spreadsheet, ExtenXLS can bring it home

To download your free evaluation of ExtenXLS, please visit: www.extentech.com/itsg/

You don't need a whitepaper to tell you that whenever numbers and calculations are involved, the spreadsheet is the de facto standard for business applications. Ever since the invention of the graphical user interface, businesses have relied heavily on the spreadsheet as an invaluable analysis tool.

Perhaps not as obvious is the black hole that exists when it comes to the reuse, versioning, and access control of spreadsheet documents. Every single day, important work is misplaced on network drives, lost in inboxes, mistakenly deleted, or simply forgotten. Even if the files are handled well, the data behind the numbers quickly becomes out of date - which costs time and money to update and redistribute. Worst of all, vital business decisions can be made based on stale data contained in stand-alone spreadsheet files.

The business-specific formulas, charts, pivot tables, and presentation formatting of spreadsheets are simply too important to risk to this haphazard environment.

What if you could retrieve the business logic trapped in file-based spreadsheets and reuse it in dynamically generated, server-based reports?

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 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.

ExtenXLS bridges the benefits of Java with the ubiquity and functionality of the spreadsheet, providing a powerful, supported, and scalable solution for generating native spreadsheet files from dynamic data sources.

Supported data sources include: XML, EJBs, Plain Old Java Objects, and of course JDBC. Additionally, any number and type of data source can easily be used within the same report. And Power Users, designing their reports using their favorite spreadsheet program, are freed from having to train on yet another report design tool.

ExtenXLS unlocks the business logic tied up on hard drives by parsing spreadsheet files into robust, full-featured Java WorkBook objects. 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. From there, 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.

Managers, analysts, and other end users can view the generated spreadsheet reports within their browsers or they can download and open them using any compatible spreadsheet program.

In combination with Servlets and JSP pages, ExtenXLS streams dynamic spreadsheet files to users visiting web sites - an essential feature for organizations that are reporting in real time to a broad audience.

As a pure-Java API, ExtenXLS runs on any platform, including all J2EE servers. This flexibility and portability of ExtenXLS is a key element for any organization wishing to incorporate reporting capabilities into their heterogeneous IT environment.

Version 4 of ExtenXLS continues the Extentech tradition of high-quality, feature-rich releases. Along with huge gains in memory efficiency and scalability, ExtenXLS 4 also boasts many robust new features:

  • Support for unlimited spreadsheet file sizes
  • Customizable conversion of spreadsheets to XML and HTML formats
  • Enhanced CellBinder functionality including Hyperlink drilldowns and JNDI data sources
  • Improved GUI components for embedding spreadsheets in Java applications
  • Support for explicit formula calculation control
  • High performance default settings
  • Improved color and pattern handling
  • Flexible cross-platform installer - includes server deploy and custom install
  • Row and column grouping
  • New font alignment and border formatting functions
  • Totally revised user manual and API documentation
  • New comprehensive CellBinder API documentation
  • Disk-based IO - reduces the need for in-memory storage and improves scalability

To download your free evaluation of ExtenXLS, please visit: www.extentech.com/itsg/

About 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.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

I've tried several of these types of systems and am in constant search for new ones. KDCalc seems to be the most functional.

Extentech Inc: It's 1 a.m. - Do You Know Where Your Business Logic Is? You don't need a whitepaper to tell you that whenever numbers and calculations are involved, the spreadsheet is the de facto standard for business applications. Ever since the invention of the graphical user interface, businesses have relied heavily on the spreadsheet as an invaluable analysis tool.

Extentech Inc: It's 1 a.m. - Do You Know Where Your Business Logic Is? You don't need a whitepaper to tell you that whenever numbers and calculations are involved, the spreadsheet is the de facto standard for business applications. Ever since the invention of the graphical user interface, businesses have relied heavily on the spreadsheet as an invaluable analysis tool.

Many companies find it more desirable to execute their spreadsheets on the web rather than distributing desktop-bound Excel files.

KDCalc converts your spreadsheets into complete ASP.NET and JSP applications that run without Excel.
- scale far beyond Excel's capacity
- protect your formulas and logic on the server
- authenticate and log all users
- connect with corporate Databases
- process huge data volumes in batch

www.KDCalc.com

Extentech Inc: It's 1 a.m. - Do You Know Where Your Business Logic Is? You don't need a whitepaper to tell you that whenever numbers and calculations are involved, the spreadsheet is the de facto standard for business applications. Ever since the invention of the graphical user interface, businesses have relied heavily on the spreadsheet as an invaluable analysis tool.

Extentech Inc: It's 1 a.m. - Do You Know Where Your Business Logic Is? You don't need a whitepaper to tell you that whenever numbers and calculations are involved, the spreadsheet is the de facto standard for business applications. Ever since the invention of the graphical user interface, businesses have relied heavily on the spreadsheet as an invaluable analysis tool.




ADS BY GOOGLE
Subscribe to the World's Most Powerful Newsletters

ADS BY GOOGLE

"Codigm is based on the cloud and we are here to explore marketing opportunities in America. Our mis...
In his session at 21st Cloud Expo, Carl J. Levine, Senior Technical Evangelist for NS1, will objecti...
High-velocity engineering teams are applying not only continuous delivery processes, but also lesson...
"CA has been doing a lot of things in the area of DevOps. Now we have a complete set of tool sets in...
"Cloud Academy is an enterprise training platform for the cloud, specifically public clouds. We offe...
Data scientists must access high-performance computing resources across a wide-area network. To achi...
"Akvelon is a software development company and we also provide consultancy services to folks who are...
"MobiDev is a software development company and we do complex, custom software development for everyb...
Agile has finally jumped the technology shark, expanding outside the software world. Enterprises are...
"We're developing a software that is based on the cloud environment and we are providing those servi...
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22n...
The question before companies today is not whether to become intelligent, it’s a question of how and...
SYS-CON Events announced today that Telecom Reseller has been named “Media Sponsor” of SYS-CON's 22n...
In his session at 21st Cloud Expo, James Henry, Co-CEO/CTO of Calgary Scientific Inc., introduced yo...
While some developers care passionately about how data centers and clouds are architected, for most,...
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native a...
"NetApp is known as a data management leader but we do a lot more than just data management on-prem ...
"We're focused on how to get some of the attributes that you would expect from an Amazon, Azure, Goo...
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection...
"We work around really protecting the confidentiality of information, and by doing so we've develope...