WEB开发网
开发学院WEB开发Jsp 用Java得到Excel中Formula的值 阅读

用Java得到Excel中Formula的值

 2008-01-05 18:01:57 来源:WEB开发网   
核心提示: 工具1:POIPOI是常用的读取Office文件的开源工具,但是在它正式发布的版本中没有提供得到Excel中Formula值的功能,用Java得到Excel中Formula的值,这个POI还在开发中的功能,相关信息 请看http://jakarta.apache.org/poi/hs

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

Tags:Java 得到 Excel

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接