The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with

已于 2023-05-05 11:04:15 修改
阅读量2.2w 收藏 4
点赞数 13
分类专栏： Java excel 工具类 文章标签： html5
于 2021-09-08 11:04:08 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40603183/article/details/120175313
版权
Java 同时被 3 个专栏收录
7 篇文章 1 订阅
订阅专栏
工具类
5 篇文章 0 订阅
订阅专栏
excel
3 篇文章 0 订阅
订阅专栏

The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)

场景：easyExcel导入时报错，百度之后发现是.xls文件手动修改后缀为.xlsx，poi识别报错

解决方法：.xls另存为.xlsx而不是手动修改后缀

月亮与山与草
关注
  • 13
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
matlabtocarrecognition.rar_In the Making_matlab 车牌识别_杞︾墝瀹氫綅_车牌定位
07-15
％ character_segmentation: Returns the digit segments in the supplied binary image. ％ The function uses the "segment" function, keeping only the seven ％ segments in the result with largest area, and...
NNFL-master.zip_The Power of Logic_demand_demand forecasting_fuz
07-14
This project is essentially a simulation of hydroelectric dam created on MATLAB ,to predict the electricity supplied by hydroelectric dam by forecasting the next hour electricity demand based on three...
POI OLE2NotOfficeXmlFileException:The supplied data appears to be in the OLE2 Format问题解决
旭东怪的博客
04-27 3万+
问题描述： org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException: The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to pro
The supplied data appears to be in the OLE2 Format.
热门推荐
qq_40014707的博客
03-03 5万+
ThesupplieddataappearstobeintheOLE2Format.YouarecallingthepartofPOIthatdealswithOOXML(OfficeOpenXML)Documents.YouneedtocalladifferentpartofPOItoprocessthisdata(egHSSFinsteadofXSSF) 在做Excel导入功能时，发现导入的文件报错，代码中判断了文件类...
解析docx报错The supplied data appears to be in the OLE2 Format. You are calling the part
最新发布
由入门到精通
12-16 820
在解析word文档的时候突然解析报错The supplied data appears to be in the OLE2 Format. You are calling the part。doc格式和docx格式的解析方式是不一样的，检查是否用的docx文档。
使用poi导入Excel文件兼容性问题，The supplied data appears to be in the OLE2 Format.
karlif的博客
01-17 8090
今天在处理Excel文件时候，发现对于以xls和xlsx为后缀的文件，用以下的代码处理时候抛 The supplied data appears to be in the OLE2 Format.异常，百思不得其姐！！！ 明明都判断类型对应的文件类型也没毛病啊！！ try { if ((filename.endsWith(".xls"))) { workbook = new HSSFWorkbook(inputStream);
The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals
程序源的博客
12-31 2975
报错: Exception in thread "main" 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 PO
PB.rar_PowerBuilder_The Safety Net_pb
09-20
3.we are not responsible for the severe result of your website or computer caused by the program supplied by our website.　 4. 转载本站提供的资源请勿删除本说明文件。 4.when you transfer the resources...
sam_ba.zip_SAM-BA_The Process_sam_ba
09-14
A Fujitsu Microelectronics, Inc. application engineer works with the customer to select the process technology best suited ...selected, the following information can be supplied to the customer
BS ISO 20417-2021 Information to be supplied by the manufacturer
04-28
BS ISO 20417-2021 Medical devices — Information to be supplied by the manufacturer.pdf
The supplied data appears to be in the Office 2007+ XML
yhj198927的博客
07-24 1万+
错误原文 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 dat...
Java导入excel文件报 The supplied data appears to be in the Office 2007+ XML. You are calling the part of
weixin_43652507的博客
03-12 9217
Java导入excel文件报 The supplied data appears to be in the Office 2007+ XML
异常：The supplied data appears to be in the Office 2007+ XML
Rosen's
05-27 1315
我遇到这个异常时，是在处理excel时，根据字节数组流创建HSSFWorkbook对象时报的错，这个是excel兼容性的问题。 处理xls结尾的文件时，用HSSFWorkbook及其相关类型；而处理xlsx结尾的文件时，需要用XSSFWorkbook及其相关类。两种类型其实方法都差不多，但在使用的时候，还是需要注意的。 ...
The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML
09-06
"The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (e.g. HSSF instead of XSSF)"这个错误是由于使用了错误的POI部分处理给定的数据格式引起的。您需要调用POI的另一个部分来处理数据。具体来说，如果您处理的是doc文件，应该使用HWPFDocument来读取；如果您处理的是xls文件，应该使用HSSFWorkbook来读取。如果您处理的是docx文件，应该使用XWPFDocument来读取；如果您处理的是xlsx文件，应该使用XSSFWorkbook来读取。请根据您所处理的文件类型选择正确的POI部分进行处理。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [The supplied data appears to be in the OLE2 Format.](https://blog.csdn.net/qq_40014707/article/details/114318042)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *3* [POI OLE2NotOfficeXmlFileException:The supplied data appears to be in the OLE2 Format问题解决](https://blog.csdn.net/qq_38974638/article/details/116210340)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值