H5W3
当前位置:H5W3 > 其他技术问题 > 正文

用Java得到Excel中Formula的值

  工具1:POI  POI是常用的读取Office文件的开源工具。但是在它正式发布的版本中没有提供得到Excel中Formula值的功能。  这个POI还在开发中的功能。相关信息 请看http://jakarta.apache.org/poi/hssf/eval.html  工具2:JExcelAPIJava Excel API – A Java API to read, write, and modify Excel spreadsheetshttp://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

本文地址:H5W3 » 用Java得到Excel中Formula的值

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址