org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Offic
壮心未与年俱老,死去犹能作鬼雄。这篇文章主要讲述org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Offic相关的知识,希望能为你提供帮助。
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)
【org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Offic】原因是:
HSSFWorkbook:是操作Excel2003以前(包括2003)的版本,扩展名是.xls
XSSFWorkbook:是操作Excel2007的版本,扩展名是.xlsx
< !--处理2003 excel--> < dependency> < groupId> org.apache.poi< /groupId> < artifactId> poi< /artifactId> < version> 3.16< /version> < /dependency> < !--处理2007 excel--> < dependency> < groupId> org.apache.poi< /groupId> < artifactId> poi-ooxml< /artifactId> < version> 3.16< /version> < /dependency>
推荐阅读
- 安卓22学分绩点系统(app+server)
- Android零基础入门第54节(视图切换组件ViewSwitcher)
- Android TextUtils类
- android ——Toolbar
- Android Studio出现Failed to open zip file问题的解决方法
- 安装Android Studio开发环境
- 自主学习Flappy Bird游戏
- BorderLayout(LayoutManagers)
- Java KeyListener接口