Pyinstaller 打包用到xlrd3模块的脚本为exe后，exe程序无法读取.xlsx文件故障解决 – 小飞侠

Pyinstaller 打包用到xlrd3模块的脚本为exe后，exe程序无法读取.xlsx文件故障解决

Post author:xfxia
Post published:2023年10月3日
Post category:其他

需要在xlrd3模块下，xlsx.py中开头位置加入此语句：

import xml.etree.ElementTree

版权声明：本文为Rudy_Han原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/Rudy_Han/article/details/115037927

如何防止自己的网站被比人嵌套在, 中</a> </h3> </article> <article class="related-post clr post-54739 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/54739.html" title="Eclipse集成Tomcat后配置项目启动路径" rel="bookmark">Eclipse集成Tomcat后配置项目启动路径</a> </h3> </article> <article class="related-post clr post-41104 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/41104.html" title="蓝桥杯 PREV-3 历届试题带分数" rel="bookmark">蓝桥杯 PREV-3 历届试题带分数</a> </h3> </article> <article class="related-post clr post-115505 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/115505.html" title="如何将PCB区域修改为板子形状大小(修改黑色区域大小)" rel="bookmark">如何将PCB区域修改为板子形状大小(修改黑色区域大小)</a> </h3> </article> <article class="related-post clr post-39725 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/39725.html" title="openstack用户管理笔记" rel="bookmark">openstack用户管理笔记</a> </h3> </article> <article class="related-post clr post-52523 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/52523.html" title="关于adb命令没有权限访问手机设备的问题" rel="bookmark">关于adb命令没有权限访问手机设备的问题</a> </h3> </article> <article class="related-post clr post-96903 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/96903.html" title="OSPF相关知识与实例配置【第一部分】" rel="bookmark">OSPF相关知识与实例配置【第一部分】</a> </h3> </article> <article class="related-post clr post-126013 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/126013.html" title="把文件怎么上传到云服务器,把文件怎么上传到云服务器" rel="bookmark">把文件怎么上传到云服务器,把文件怎么上传到云服务器</a> </h3> </article> <article class="related-post clr post-58954 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/58954.html" title="将空闲空间合并到现有分区时出现错误：检测到下列文件系统错误，分区容量未做调整，无效的的文件记录" rel="bookmark">将空闲空间合并到现有分区时出现错误：检测到下列文件系统错误，分区容量未做调整，无效的的文件记录</a> </h3> </article> <article class="related-post clr post-92354 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/92354.html" title="【转】一位36岁程序员的困惑" rel="bookmark">【转】一位36岁程序员的困惑</a> </h3> </article> <article class="related-post clr post-115540 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/115540.html" title="android Compose Modifier介绍" rel="bookmark">android Compose Modifier介绍</a> </h3> </article> <article class="related-post clr post-73971 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/73971.html" title="ROS智能车定位导航仿真（原赛道自主导航，构建地图再导航）" rel="bookmark">ROS智能车定位导航仿真（原赛道自主导航，构建地图再导航）</a> </h3> </article> <article class="related-post clr post-108532 post type-post status-publish format-standard hentry category-other entry"> <h3 class="related-post-title"> <a href="https://xfxia.com/108532.html" title="虚拟机上Ubuntu搭建gitlab全过程" rel="bookmark">虚拟机上Ubuntu搭建gitlab全过程</a> </h3> </article> </div> </section> </article> </div> </div> <aside id="right-sidebar" class="sidebar-container widget-area sidebar-primary" itemscope="itemscope" itemtype="https://schema.org/WPSideBar" role="complementary" aria-label="Primary Sidebar"> <div id="right-sidebar-inner" class="clr"> <div id="categories-2" class="sidebar-box widget_categories clr"><h4 class="widget-title">目录</h4> <ul> <li class="cat-item cat-item-10"><a href="https://xfxia.com/category/apicloud">APICloud</a> <span class="cat-count-span">(3) </li> <li class="cat-item cat-item-26"><a href="https://xfxia.com/category/golang">golang</a> <span class="cat-count-span">(228) </li> <li class="cat-item cat-item-27"><a href="https://xfxia.com/category/java">java</a> <span class="cat-count-span">(8,236) </li> <li class="cat-item cat-item-11"><a href="https://xfxia.com/category/linux">linux</a> <span class="cat-count-span">(4,002) </li> <li class="cat-item cat-item-29"><a href="https://xfxia.com/category/mysql">mysql</a> <span class="cat-count-span">(2,800) </li> <li class="cat-item cat-item-28"><a href="https://xfxia.com/category/php">php</a> <span class="cat-count-span">(1,070) </li> <li class="cat-item cat-item-35"><a href="https://xfxia.com/category/python">python</a> <span class="cat-count-span">(5,439) </li> <li class="cat-item cat-item-34"><a href="https://xfxia.com/category/solidity">solidity</a> <span class="cat-count-span">(25) </li> <li class="cat-item cat-item-3"><a href="https://xfxia.com/category/uniapp">uniapp</a> <span class="cat-count-span">(235) </li> <li class="cat-item cat-item-4"><a href="https://xfxia.com/category/vue">vue</a> <span class="cat-count-span">(2,463) </li> <li class="cat-item cat-item-5"><a href="https://xfxia.com/category/other">其他</a> <span class="cat-count-span">(88,233) </li> <li class="cat-item cat-item-1"><a href="https://xfxia.com/category/wechat">小程序</a> <span class="cat-count-span">(801) </li> </ul> </div><div id="archives-2" class="sidebar-box widget_archive clr"><h4 class="widget-title">文章归档</h4> <ul> <li><a href='https://xfxia.com/date/2023/12'>2023年十二月</a> (1872)</li> <li><a href='https://xfxia.com/date/2023/11'>2023年十一月</a> (477)</li> <li><a href='https://xfxia.com/date/2023/10'>2023年十月</a> (17371)</li> <li><a href='https://xfxia.com/date/2023/09'>2023年九月</a> (44974)</li> <li><a href='https://xfxia.com/date/2023/08'>2023年八月</a> (26399)</li> <li><a href='https://xfxia.com/date/2023/07'>2023年七月</a> (14793)</li> <li><a href='https://xfxia.com/date/2023/06'>2023年六月</a> (1)</li> <li><a href='https://xfxia.com/date/2023/05'>2023年五月</a> (2186)</li> <li><a href='https://xfxia.com/date/2023/04'>2023年四月</a> (3838)</li> <li><a href='https://xfxia.com/date/2023/03'>2023年三月</a> (1544)</li> <li><a href='https://xfxia.com/date/2023/02'>2023年二月</a> (3)</li> <li><a href='https://xfxia.com/date/2023/01'>2023年一月</a> (4)</li> <li><a href='https://xfxia.com/date/2022/12'>2022年十二月</a> (3)</li> <li><a href='https://xfxia.com/date/2022/11'>2022年十一月</a> (36)</li> <li><a href='https://xfxia.com/date/2022/10'>2022年十月</a> (16)</li> <li><a href='https://xfxia.com/date/2022/09'>2022年九月</a> (8)</li> <li><a href='https://xfxia.com/date/2021/09'>2021年九月</a> (1)</li> <li><a href='https://xfxia.com/date/2020/09'>2020年九月</a> (6)</li> <li><a href='https://xfxia.com/date/2020/08'>2020年八月</a> (5)</li> </ul> </div><div id="tag_cloud-2" class="sidebar-box widget_tag_cloud clr"><h4 class="widget-title">标签</h4><div class="tagcloud"><a href="https://xfxia.com/tag/aave" class="tag-cloud-link tag-link-21 tag-link-position-1" style="font-size: 8pt;" aria-label="Aave (1个项目)">Aave<span class="tag-link-count"> (1)</span></a> <a href="https://xfxia.com/tag/cosmos" class="tag-cloud-link tag-link-19 tag-link-position-2" style="font-size: 10.127071823204pt;" aria-label="cosmos (6个项目)">cosmos<span class="tag-link-count"> (6)</span></a> <a href="https://xfxia.com/tag/defi" class="tag-cloud-link tag-link-22 tag-link-position-3" style="font-size: 16.160220994475pt;" aria-label="defi (255个项目)">defi<span class="tag-link-count"> (255)</span></a> <a href="https://xfxia.com/tag/flag" class="tag-cloud-link tag-link-30 tag-link-position-4" style="font-size: 12.447513812155pt;" aria-label="flag (27个项目)">flag<span class="tag-link-count"> (27)</span></a> <a href="https://xfxia.com/tag/gitee" class="tag-cloud-link tag-link-37 tag-link-position-5" style="font-size: 8pt;" aria-label="gitee (1个项目)">gitee<span class="tag-link-count"> (1)</span></a> <a href="https://xfxia.com/tag/github" class="tag-cloud-link tag-link-36 tag-link-position-6" style="font-size: 8pt;" aria-label="github (1个项目)">github<span class="tag-link-count"> (1)</span></a> <a href="https://xfxia.com/tag/golang" class="tag-cloud-link tag-link-16 tag-link-position-7" style="font-size: 16.005524861878pt;" aria-label="golang (234个项目)">golang<span class="tag-link-count"> (234)</span></a> <a href="https://xfxia.com/tag/java" class="tag-cloud-link tag-link-31 tag-link-position-8" style="font-size: 22pt;" aria-label="java (8,234个项目)">java<span class="tag-link-count"> (8234)</span></a> <a href="https://xfxia.com/tag/linux%e5%91%bd%e4%bb%a4" class="tag-cloud-link tag-link-12 tag-link-position-9" style="font-size: 14.265193370166pt;" aria-label="linux命令 (82个项目)">linux命令<span class="tag-link-count"> (82)</span></a> <a href="https://xfxia.com/tag/list" class="tag-cloud-link tag-link-33 tag-link-position-10" style="font-size: 8pt;" aria-label="List (1个项目)">List<span class="tag-link-count"> (1)</span></a> <a href="https://xfxia.com/tag/map" class="tag-cloud-link tag-link-32 tag-link-position-11" style="font-size: 18.635359116022pt;" aria-label="map (1,115个项目)">map<span class="tag-link-count"> (1115)</span></a> <a href="https://xfxia.com/tag/mysql" class="tag-cloud-link tag-link-24 tag-link-position-12" style="font-size: 20.337016574586pt;" aria-label="mysql (3,093个项目)">mysql<span class="tag-link-count"> (3093)</span></a> <a href="https://xfxia.com/tag/npm" class="tag-cloud-link tag-link-15 tag-link-position-13" style="font-size: 16.044198895028pt;" aria-label="npm (237个项目)">npm<span class="tag-link-count"> (237)</span></a> <a href="https://xfxia.com/tag/tendermint" class="tag-cloud-link tag-link-20 tag-link-position-14" style="font-size: 10.127071823204pt;" aria-label="tendermint (6个项目)">tendermint<span class="tag-link-count"> (6)</span></a> <a href="https://xfxia.com/tag/uuid" class="tag-cloud-link tag-link-25 tag-link-position-15" style="font-size: 13.182320441989pt;" aria-label="uuid (43个项目)">uuid<span class="tag-link-count"> (43)</span></a> <a href="https://xfxia.com/tag/vant" class="tag-cloud-link tag-link-14 tag-link-position-16" style="font-size: 13.839779005525pt;" aria-label="vant (64个项目)">vant<span class="tag-link-count"> (64)</span></a> <a href="https://xfxia.com/tag/vmware" class="tag-cloud-link tag-link-13 tag-link-position-17" style="font-size: 16.237569060773pt;" aria-label="vmware (270个项目)">vmware<span class="tag-link-count"> (270)</span></a> <a href="https://xfxia.com/tag/%e5%8c%ba%e5%9d%97%e9%93%be" class="tag-cloud-link tag-link-18 tag-link-position-18" style="font-size: 13.839779005525pt;" aria-label="区块链 (63个项目)">区块链<span class="tag-link-count"> (63)</span></a> <a href="https://xfxia.com/tag/%e5%90%88%e7%ba%a6" class="tag-cloud-link tag-link-23 tag-link-position-19" style="font-size: 12.950276243094pt;" aria-label="合约 (37个项目)">合约<span class="tag-link-count"> (37)</span></a> <a href="https://xfxia.com/tag/%e5%b0%8f%e7%a8%8b%e5%ba%8f%e7%89%88%e6%9c%ac%e6%9b%b4%e6%96%b0" class="tag-cloud-link tag-link-9 tag-link-position-20" style="font-size: 9.1602209944751pt;" aria-label="小程序版本更新 (3个项目)">小程序版本更新<span class="tag-link-count"> (3)</span></a></div> </div> </div> </aside> </div> </main> <footer id="footer" class="site-footer" itemscope="itemscope" itemtype="https://schema.org/WPFooter" role="contentinfo"> <div id="footer-inner" class="clr"> <div id="footer-widgets" class="oceanwp-row clr"> <div class="footer-widgets-inner container"> <div class="footer-box span_1_of_4 col col-1"> </div> <div class="footer-box span_1_of_4 col col-2"> </div> <div class="footer-box span_1_of_4 col col-3 "> </div> <div class="footer-box span_1_of_4 col col-4"> </div> </div> </div> <div id="footer-bottom" class="clr"> <div id="footer-bottom-inner" class="container clr"> <div id="footer-bottom-menu" class="navigation clr"> <div class="menu-topmenu-container"><ul id="menu-topmenu-1" class="menu"><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-15"><a href="/">首页</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-19"><a href="https://xfxia.com/category/wechat">小程序</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-16"><a href="https://xfxia.com/category/uniapp">uniapp</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-17"><a href="https://xfxia.com/category/vue">vue</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-254"><a href="https://xfxia.com/category/apicloud">APICloud</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-18"><a href="https://xfxia.com/category/other">其他</a></li> </ul></div> </div> <div id="copyright" class="clr" role="contentinfo"> Copyright xfxia.com <a href="https://beian.miit.gov.cn/">鲁ICP备19024253号-2</a> </div> </div> </div> </div> </footer> </div> </div> <a id="scroll-top" class="scroll-top-right" href="#"><span class="fa fa-angle-up" aria-label="Scroll to the top of the page"></span></a> <div id="sidr-close"> <a href="#" class="toggle-sidr-close" aria-label="Close mobile Menu"> <i class="icon icon-close" aria-hidden="true"></i><span class="close-text">关闭菜单</span> </a> </div> <div id="mobile-menu-search" class="clr"> <form method="get" action="https://xfxia.com/" class="mobile-searchform" role="search" aria-label="Search for:"> <label for="ocean-mobile-search2"> <input type="search" name="s" autocomplete="off" placeholder="搜索" /> <button type="submit" class="searchform-submit" aria-label="Submit Search"> <i class="icon icon-magnifier" aria-hidden="true"></i> </button> </label> </form> </div> <script type='text/javascript' src='https://xfxia.com/wp-includes/js/imagesloaded.min.js?ver=3.2.0'></script> <script type='text/javascript' src='https://xfxia.com/wp-content/themes/oceanwp/assets/js/third/magnific-popup.min.js?ver=1.8.7'></script> <script type='text/javascript' src='https://xfxia.com/wp-content/themes/oceanwp/assets/js/third/lightbox.min.js?ver=1.8.7'></script> <script type='text/javascript'> /* <![CDATA[ / var oceanwpLocalize = {"isRTL":"","menuSearchStyle":"drop_down","sidrSource":"#sidr-close, #site-navigation, #mobile-menu-search","sidrDisplace":"1","sidrSide":"left","sidrDropdownTarget":"link","verticalHeaderTarget":"link","customSelects":".woocommerce-ordering .orderby, #dropdown_product_cat, .widget_categories select, .widget_archive select, .single-product .variations_form .variations select"}; / ]]> */ </script> <script type='text/javascript' src='https://xfxia.com/wp-content/themes/oceanwp/assets/js/main.min.js?ver=1.8.7'></script> <script type='text/javascript' src='https://xfxia.com/wp-includes/js/wp-embed.min.js?ver=5.4.2'></script>  <script> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?c059b62ee4dd5661794737c9c17ea527"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script> </body> </html>