用Java得到Excel中Formula的值

王朝java/jsp·作者佚名  2008-05-31
宽屏版  字体: |||超大  

工具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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
© 2005- 王朝网络 版权所有