Apache Poi 不能干什么？

原文在文章末尾。

当前 HSSF/XSSF 主要的短板

这篇文档的目的是介绍一下HSSF和XSSF API 的短板。但不打算列出HSSF 或者XSSF 所有的bug和遗漏点，尽管对于遗漏和残破的功能，我们打算提供更为广泛的用户体验。

图表：

HSSF 支持一些较为简单的图表类型，但是大多数它还是不支持。HSSF（大部分）不支持动态图表。尽管这样，你还是可以利用HSSF创建一个图表，使用已知的数据范围并且修改图表数据，最后还能将图表放在一个新的工作簿中。Poi试图尽可能地保持已存信息的紧密度。

宏

所有的宏都不能在POI中创建。并且我们也没有计划支持宏。但是，读取和重写一个包含宏的Excel是可以安全的保存这些宏。

透视表（更改参考点的表）

HSSF不包含也不支持读取和创建任何的透视表，XSSF支持有限的创建透视表，并且支持极为有限地更改和重写透视表。

通过以上我们知道，poi能支持大多数上的工作但是对于图表的支持极为有限（而且很难看），所以我大多数情况下是利用JFreeChart产生图表的，然后再将图片导入Excel。（是不是感觉不爽？！）

Current HSSF / XSSF main limitations

The intent of this document is to outline some of the known limitations of the POI HSSF and XSSF API's. It is not intended to be complete list of every bug or missing feature of HSSF or XSSF, rather it's purpose is to provide a broad feel for some of the functionality that is missing or broken.

• Charts
  
  
  • HSSF has some limited support for creating a handful of very simple Chart types, but largely this isn't supported. HSSF (largely) doesn't support changing Charts. You can however create a chart in Excel using Named ranges, modify the chart data values using HSSF and write a new spreadsheet out. This is possible because POI attempts to keep existing records intact as far as possible.
    
  • XSSF has only limited chart support including making some simple changes and adding at least some line and scatter charts, see the examplesLineChart and ScatterChart.
    
    
• Macros
  
  Macros can not be created. The are currently no plans to support macros. However, reading and re-writing files containing macros will safely preserve the macros.
  
  
• Pivot Tables
  
  HSSF doesn't have support for reading or creating Pivot tables. XSSF has limited support for creating Pivot Tables, and very limited read/change support.