ExtenXLS

Last updated

ExtenXLS is a Java Excel Reporting Toolkit developed by Extentech. [1] It is a Reporting API that allows for the reading in, modifying and creation of spreadsheet-based reports from Java applications. [2]

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

Related Research Articles

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft 365

Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.

XSLT is a language originally designed for transforming XML documents into other XML documents, or other formats such as HTML for web pages, plain text or XSL Formatting Objects, which may subsequently be converted to other formats, such as PDF, PostScript and PNG. Support for JSON and plain-text transformation was added in later updates to the XSLT 1.0 specification.

<span class="mw-page-title-main">Apache Struts 1</span> Open-source web application framework

Apache Struts 1 is an open-source web application framework for developing Java EE web applications. It uses and extends the Java Servlet API to encourage developers to adopt a model–view–controller (MVC) architecture. It was originally created by Craig McClanahan and donated to the Apache Foundation in May 2000. Formerly located under the Apache Jakarta Project and known as Jakarta Struts, it became a top-level Apache project in 2005.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice is an office suite for the macOS operating system developed by Planamesa Inc. It is a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program and graphics program, it adds some features not present in the macOS versions of LibreOffice and Apache OpenOffice. Current versions are based on LibreOffice 4.4, which was released mid-2014.

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer and Oracle Application Server Reports Services.

This article describes the technical specifications of the OpenDocument office document standard, as developed by the OASIS industry consortium. A variety of organizations developed the standard publicly and make it publicly accessible, meaning it can be implemented by anyone without restriction. The OpenDocument format aims to provide an open alternative to proprietary document formats.

<span class="mw-page-title-main">Web template system</span> System in web publishing

A web template system in web publishing allows web designers and developers work with web templates to automatically generate custom web pages, such as the results from a search. This reuses static web page elements while defining dynamic elements based on web request parameters. Web templates support static content, providing basic structure and appearance. Developers can implement templates from content management systems, web application frameworks, and HTML editors.

<span class="mw-page-title-main">Template processor</span> Software designed to combine templates with a data model to produce result documents

A template processor is software designed to combine templates with a data model to produce result documents. The language that the templates are written in is known as a template language or templating language. For purposes of this article, a result document is any kind of formatted output, including documents, web pages, or source code, either in whole or in fragments. A template engine is ordinarily included as a part of a web template system or application framework, and may be used also as a preprocessor or filter.

<span class="mw-page-title-main">Adobe LiveCycle</span> Java EE server software

Adobe LiveCycle Enterprise Suite (ES4) is a service-oriented architecture Java EE server software product from Adobe Systems used to build applications that automate a broad range of business processes for enterprises and government agencies. LiveCycle ES4 is an enterprise document and form platform that allows capturing and processing information, delivering personalized communications, and protecting and tracking sensitive information. It is used for purposes such as account opening, services, and benefits enrollment, correspondence management, requests for proposal processes, and other manual-based workflows. LiveCycle ES4 incorporates new features with a particular focus on mobile devices. LiveCycle applications also function in both online and offline environments. These capabilities are enabled through the use of Adobe Reader, HTML/PhoneGap, and Flash Player clients to reach desktop computers and mobile devices.

Modes:

Java view technologies and frameworks are web-based software libraries that provide the user interface, or "view-layer", of Java web applications. Such application frameworks are used for defining web pages and handling the HTTP requests (clicks) generated by those web pages. As a sub-category of web frameworks, view-layer frameworks often overlap to varying degrees with web frameworks that provide other functionality for Java web applications.

ZK is an open-source Ajax Web application framework, written in Java, that enables creation of graphical user interfaces for Web applications with little required programming knowledge.

<span class="mw-page-title-main">I-net Crystal-Clear</span>

i-net Clear Reports is a Java-based cross-platform reporting application providing a report designer and a server component to create reports in numerous output formats like PDF, HTML, PS, RTF, XLS, TXT, CSV, SVG, XML, as well as being viewable in a Java applet or Swing component. Application programmers can integrate i-net Clear Reports using the public API which spans over 200 classes. Starting with release 11.0 i-net Clear Reports also supports the .NET programming language and offers a public API for further integration in other products.

<span class="mw-page-title-main">Sheetster</span>

Sheetster is a GPL open-source Web Spreadsheet and a Java Application Server created by Extentech Inc. The product was created for the enterprise and small and medium-sized businesses as an Open Source alternative to closed document management systems.

<span class="mw-page-title-main">FarPoint Spread</span> Computer software

FarPoint Spread is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft BizTalk Server. Software developers use the components to embed Microsoft Excel-compatible spreadsheet features into their applications, such as importing and exporting Microsoft Excel files, displaying, modifying, analyzing, and visualizing data. Spread components handle spreadsheet data at the cell, row, column, or worksheet level.

<span class="mw-page-title-main">OpenRefine</span> Application for data cleanup and data transformation

OpenRefine is an open-source desktop application for data cleanup and transformation to other formats, an activity commonly known as data wrangling. It is similar to spreadsheet applications, and can handle spreadsheet file formats such as CSV, but it behaves more like a database.

Datalogics is a computer software company formed in 1967 and based in Chicago, IL. The company licenses software development kits for working with PDF and other document file types. They have previously developed their own typesetting and database publishing software. Since 1996, Datalogics has also acted as a channel for several SDKs from Adobe Systems. These include the Adobe PDF Library, Adobe Experience Reader Extensions, Adobe Content Server, Adobe InDesign Server, Adobe PDF Converter, Adobe PDF Print Engine and Adobe Reader Mobile SDK. In 2022, Datalogics launched a new business unit called pdfRest, an API toolkit for PDF processing.

JExcel is a library (API) to read, write, display, and modify Excel files with .xls or .xlsx formats. API can be embedded with Java Swing and AWT.

References

  1. "Extentech Inc., Releases ExtenXLS 6.0". Archived from the original on 2009-01-07. Retrieved 2008-06-30.
  2. "Extentech Inc. Advances Middleware Market with Web 2.0 Enabled API". Archived from the original on 2008-02-07. Retrieved 2008-06-30.