POI操作excel常用方法总结

一、 POI简介

            Apache POI是Apache软件基金会的开放源码函式库,POI提供API给Java程序对Microsoft Office格式档案读和写的功能。

错误:org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)

错误:2003与2007版本冲突了

https://zhidao.baidu.com/question/1862130106281668227.html

使用jxl.jar包操作excel:http://www.cnblogs.com/sunzhenxing19860608/archive/2010/12/27/1918128.html

 http://www.oschina.net/p/poi/

http://mianhuaman.iteye.com/blog/1006830

原文地址:https://www.cnblogs.com/zhxn/p/6963368.html