ExtenXLS is a Java

Excel ExCeL London (an abbreviation for Exhibition Centre London) is an exhibition centre, international convention centre and former hospital in the Custom House area of Newham, East London. It is situated on a site on the northern quay of the ...

Reporting Toolkit developed by Extentech. It is a

Report A report is a document that presents information in an organized format for a specific audience and purpose. Although summaries of reports may be delivered orally, complete reports are almost always in the form of written documents. Usage In ...

ing

API An application programming interface (API) is a way for two or more computer programs to communicate with each other. It is a type of software Interface (computing), interface, offering a service to other pieces of software. A document or standa ...

that allows for the reading in, modifying and creation of

spreadsheet A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cel ...

-based reports from

Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's List ...

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 Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. T ...

, and

HTML The HyperText Markup Language or HTML is the standard markup language for documents designed to be displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets (CSS) and scripting languages such as JavaScri ...

formats. Common uses range from a Java Servlet that produces financial analysis reports to

JavaBeans In computing based on the Java Platform, JavaBeans is a technology developed by Sun Microsystems and released in 1996, as part of JDK 1.1. The 'beans' of JavaBeans are classes that encapsulate one or more objects into a single standardized objec ...

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 Swing is a GUI widget toolkit for Java. It is part of Oracle's Java Foundation Classes (JFC) – an API for providing a graphical user interface (GUI) for Java programs. Swing was developed to provide a more sophisticated set of GUI com ...

spreadsheet components, and transformations of spreadsheets into HTML, and XML.

References

External links

ExtenXLSSheetster.com Web Spreadsheet based on ExtenXLS
Java platform software Reporting software {{programming-software-stub