ExtenXLS

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.

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.


Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.