一.POI各个jar包用途,及处理Excel需要jar包

   最近项目需要导出Excel表功能,研究了好多,最后决定用阿帕奇的POI;

    使用maven导入jar包时,发现POI有好多jar包,顿时不知应该导入那个,如果全部导入,使用应该没问题,但个人癖好是,用的导入,多余的不留,所以,又去官网查看一番,最后发现了下面这个东东:

Component Map

Apache POI分布包括对许多文档文件格式的支持。该支持在多个Jar文件中提供。并不是所有的jar包都是需要的。下表显示了POI组件、Maven存储库标记和项目Jar文件之间的关系。

Component	Application type	Maven artifactId	Notes
POIFS	OLE2 Filesystem	poi	Required to work with OLE2 / POIFS based files
HPSF	OLE2 Property Sets	poi
HSSF	Excel XLS	poi	For HSSF only, if common SS is needed see below
HSLF	PowerPoint PPT	poi-scratchpad
HWPF	Word DOC	poi-scratchpad
HDGF	Visio VSD	poi-scratchpad
HPBF	Publisher PUB	poi-scratchpad
HSMF	Outlook MSG	poi-scratchpad
DDF	Escher common drawings	poi
HWMF	WMF drawings	poi-scratchpad
OpenXML4J	OOXML	poi-ooxml plus either poi-ooxml-schemas or ooxml-schemas and ooxml-security	See notes below for differences between these options
XSSF	Excel XLSX	poi-ooxml
XSLF	PowerPoint PPTX	poi-ooxml
XWPF	Word DOCX	poi-ooxml
XDGF	Visio VSDX	poi-ooxml
Common SL	PowerPoint PPT and PPTX	poi-scratchpad and poi-ooxml	SL code is in the core POI jar, but implementations are in poi-scratchpad and poi-ooxml.
Common SS	Excel XLS and XLSX	poi-ooxml	WorkbookFactory and friends all require poi-ooxml, not just core poi

此表显示jar依赖关系。“version - yyymmdd”是POI版本。你可以在 downloads page. 看到最新信息;

Maven artifactId	Prerequisites	JAR
poi	commons-logging, commons-codec, commons-collections, log4j	poi-version-yyyymmdd.jar
poi-scratchpad	poi	poi-scratchpad-version-yyyymmdd.jar
poi-ooxml	poi, poi-ooxml-schemas	poi-ooxml-version-yyyymmdd.jar
poi-ooxml-schemas	xmlbeans	poi-ooxml-schemas-version-yyyymmdd.jar
poi-examples	poi, poi-scratchpad, poi-ooxml	poi-examples-version-yyyymmdd.jar
ooxml-schemas	xmlbeans	ooxml-schemas-1.3.jar
ooxml-security	xmlbeans For signing: bcpkix-jdk15on, bcprov-jdk15on, xmlsec, slf4j-api	ooxml-security-1.1.jar

 

    从上面表格中可以看出,如果只是处理Excel,我们只需导入poi,poi-ooxml, poi-ooxml-schemas就可;