| 導購 | 订阅 | 在线投稿
分享
 
 
 

用Java得到Excel中Formula的值

來源:互聯網  2008-05-31 11:17:56  評論

工具1:POI

POI是常用的讀取Office文件的開源工具。但是在它正式發布的版本中沒有提供得到Excel中Formula值的功能。

這個POI還在開發中的功能。相關信息 請看http://jakarta.apache.org/poi/hssf/eval.Html

工具2:JExcelAPI

Java Excel API - A Java API to read, write, and modify Excel spreadsheets

http://jexcelapi.sourceforge.net/

目前的最新版本是2.6

Some Features

* Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks

* Reads and writes formulas (Excel 97 and later only)

* Generates spreadsheets in Excel 2000 format

* Supports font, number and date formatting

* Supports shading, bordering, and coloring of cells

* Modifies existing worksheets

* Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, * * Spanish, and German, but more can be added if translated)

* Supports copying of charts

* Supports insertion and copying of images into spreadsheets

* Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc

...and mUCh more

  工具1:POI   POI是常用的讀取Office文件的開源工具。但是在它正式發布的版本中沒有提供得到Excel中Formula值的功能。   這個POI還在開發中的功能。相關信息 請看http://jakarta.apache.org/poi/hssf/eval.Html   工具2:JExcelAPI Java Excel API - A Java API to read, write, and modify Excel spreadsheets http://jexcelapi.sourceforge.net/ 目前的最新版本是2.6 Some Features * Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks * Reads and writes formulas (Excel 97 and later only) * Generates spreadsheets in Excel 2000 format * Supports font, number and date formatting * Supports shading, bordering, and coloring of cells * Modifies existing worksheets * Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, * * Spanish, and German, but more can be added if translated) * Supports copying of charts * Supports insertion and copying of images into spreadsheets * Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc ...and mUCh more
󰈣󰈤
 
 
 
>>返回首頁<<
 
 
 
 
 熱帖排行
 
王朝網路微信公眾號
微信掃碼關註本站公眾號 wangchaonetcn
 
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有