ExtenXLS
Encyclopedia
ExtenXLS is a Java Excel
Reporting Toolkit developed by Extentech. It is a Reporting
API that allows for the reading in, modifying and creation of spreadsheet
-based reports from Java applications.
Written entirely in the Java programming language
, ExtenXLS creates new spreadsheet files from scratch as well as from existing spreadsheet files templates. ExtenXLS has the ability to utilize data from any source and output it in Excel-compatible XLS
, XML
, and HTML
formats.
Common uses range from a Java Servlet
that produces financial analysis reports to Java beans embedded in JavaServer Pages
for use in executing formula calculations. The ExtenXLS API can be used as a desktop spreadsheet component or embedded in a server application. With the ability to reuse existing spreadsheets, ExtenXLS can update template XLS files with fresh data from databases and output to custom reports. It has an Excel compatibility, template input files can range from a variety of complex legacy spreadsheets such as: surveys, checklists, what-if scenarios, and historical portfolio data.
ExtenXLS contains methods that can create new WorkBooks from scratch, allowing for the insertion of new cells containing text, and numeric data. The product allows for customization of output with hundreds of fonts, colors, patterns, borders, formulas, named ranges, and built-in formats such as: currency, date, financial and numeric formatting patterns.
Other potential uses include: user interfaces built with the included Java Swing
spreadsheet components, and transformations of spreadsheets into HTML, and XML.
Microsoft Excel
Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...
Reporting Toolkit developed by Extentech. It is a Reporting
Report
A report is a textual work made with the specific intention of relaying information or recounting certain events in a widely presentable form....
API that allows for the reading in, modifying and creation of spreadsheet
Spreadsheet
A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. Each cell contains alphanumeric text, numeric values or formulas...
-based reports from Java applications.
Written entirely in the Java programming language
Java (programming language)
Java is a programming language originally developed by James Gosling at Sun Microsystems and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities...
, ExtenXLS creates new spreadsheet files from scratch as well as from existing spreadsheet files templates. ExtenXLS has the ability to utilize data from any source and output it in Excel-compatible XLS
Microsoft Excel
Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...
, XML
XML
Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
, and HTML
HTML
HyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....
formats.
Common uses range from a Java Servlet
Java Servlet
A servlet is a Java programming language class used to extend the capabilities of servers that host applications accessed via a request-response programming model. Although servlets can respond to any type of request, they are commonly used to extend the applications hosted by Web servers...
that produces financial analysis reports to Java beans embedded in JavaServer Pages
JavaServer Pages
JavaServer Pages is a Java technology that helps software developers serve dynamically generated web pages based on HTML, XML, or other document types...
for use in executing formula calculations. The ExtenXLS API can be used as a desktop spreadsheet component or embedded in a server application. With the ability to reuse existing spreadsheets, ExtenXLS can update template XLS files with fresh data from databases and output to custom reports. It has an Excel compatibility, template input files can range from a variety of complex legacy spreadsheets such as: surveys, checklists, what-if scenarios, and historical portfolio data.
ExtenXLS contains methods that can create new WorkBooks from scratch, allowing for the insertion of new cells containing text, and numeric data. The product allows for customization of output with hundreds of fonts, colors, patterns, borders, formulas, named ranges, and built-in formats such as: currency, date, financial and numeric formatting patterns.
Other potential uses include: user interfaces built with the included Java Swing
Swing (Java)
Swing is the primary Java GUI widget toolkit. It is part of Oracle's Java Foundation Classes — an API for providing a graphical user interface for Java programs....
spreadsheet components, and transformations of spreadsheets into HTML, and XML.