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

Enterprise architects are increasingly adopting multi-cloud strategies as they seek to utilize exist...
Docker containers have brought great opportunities to shorten the deployment process through continu...
Kubernetes is a new and revolutionary open-sourced system for managing containers across multiple ho...
Leading companies, from the Global Fortune 500 to the smallest companies, are adopting hybrid cloud ...
In his session at Cloud Expo, Alan Winters, U.S. Head of Business Development at MobiDev, presented ...
"We work around really protecting the confidentiality of information, and by doing so we've develope...
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the te...
Data is the fuel that drives the machine learning algorithmic engines and ultimately provides the bu...
When shopping for a new data processing platform for IoT solutions, many development teams want to b...
In IT, we sometimes coin terms for things before we know exactly what they are and how they’ll be us...
Detecting internal user threats in the Big Data eco-system is challenging and cumbersome. Many organ...
In his session at 20th Cloud Expo, Scott Davis, CTO of Embotics, discussed how automation can provid...
In his session at @DevOpsSummit at 20th Cloud Expo, Kelly Looney, director of DevOps consulting for ...
In his session at 20th Cloud Expo, Brad Winett, Senior Technologist for DDN Storage, will present se...
Given the popularity of the containers, further investment in the telco/cable industry is needed to ...
Businesses and business units of all sizes can benefit from cloud computing, but many don't want the...
"I will be talking about ChatOps and ChatOps as a way to solve some problems in the DevOps space," e...
In his session at 21st Cloud Expo, Michael Burley, a Senior Business Development Executive in IT Ser...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know ...
For organizations that have amassed large sums of software complexity, taking a microservices approa...