生成Excel文件的Java類庫：JETT (Java Excel Template Translator)

jopen 11年前發布 | 90K 次閱讀 JETT Office文檔處理

JETT (Java Excel Template Translator)是一個 Java 5.0 API能夠快速建立Excel電子表格報表，使用Excel電子表格模板。

JETT構建在 Apache POI 類庫之上，所以可以讓開發人員完全控制Excel文件的創建，讀取和修改。包括字體，顏色，高亮，邊框，對齊，頁眉/頁腳等。


以下是它的主要特性：

  • Integration with Apache Commons JEXL 2.1.1 (Java Expression Language). This allows for easy creation of expressions that are substituted with model data in the form of beans at runtime.
  • Integration with Apache POI 3.8. JETT is built on top of the extensive Apache POI library with which it controls sheet transformations.
  • Integration with the SourceForge project jAgg 0.7.0. JETT uses this library to evaluate Aggregate Expressions, a JETT-based extension to JEXL that allows aggregate expressions to be evaluated, such as Sum, Count, Avg, etc.
  • Built-in Tag library that allows XML-like tags to be placed in template spreadsheets, allowing such simple programming-like constructs as “if”, “for”, “forEach”, and more.
  • Looping tags support “copy down” and “copy right” behavior for the display of Collections.
  • Custom Tag Libraries may be coded and supplied to JETT for execution.
  • Like Apache POI, JETT attempts as much as possible to keep existing Excel features intact, including Charts, Macros, etc.
  • The CellListener interface allows dynamic, custom processing of Cells, such as alternate row highlighting, value manipulation, etc.
  • Merged cell regions are shifted and copied as appropriate.
  • Row heights and columns widths are respected as best as possible.
  • Template sheets may be dynamically cloned and separately evaluated in the resultant spreadsheet.
  • Multiple collections may be implicitly processed using a single loop.
  • It is possible to implement and display adjacent, or side-by-side, lists.
  • Supports binary Excel (.xls) and XML Excel (.xlsx) documents.
  • RichTextStrings are supported, even within Expressions.
  • JETT gives access to POI Objects in JEXL Expressions, which in turn allows access to Workbook and Sheet properties, including the Header & Footer, and PageSetup objects.
  • Excel Formula generation support.

項目主頁：http://www.baiduhome.net/lib/view/home/1382788477624

 本文由用戶 jopen 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
 轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！