代码地址:
https://github.com/lorenzowu/SIONR
test.py遇到的问题及解决方案:
1. 输入xlsx文件报错
importError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.
解决方案1:
conda install xlrd
importError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.解决方案1:
conda install xlrd
xlrd版本过高,同时需要修改xlsx文件为xls
解决方案2:可以卸了重装：pip install xlrd==1.2.0
2. OMP:Error #15报错
输出到test 239时报错:
OMP: Error #15: Initializing libiomp5md.dll, but found libiomp5md.dll already initialized. OMP: Hint This means that multiple copies of the OpenMP runtime have been linked into the program. That is dangerous, since it can degrade performance or cause incorrect results. The best thing to do is to ensure that only a single OpenMP runtime is linked into the process, e.g. by avoiding static linking of the OpenMP runtime in any library. As an unsafe, unsupported, undocumented workaround you can set the environment variable KMP_DUPLICATE_LIB_OK=TRUE to allow the program to continue to execute, but that may cause crashes or silently produce incorrect results. For more information, please see http://www.intel.com/software/products/support/.解决方案:
参考: 解决OMP: Error #15: Initializing libiomp5md.dll, but found libiomp5md.dll already initialized. OMP: Hi_peachhhh的博客-CSDN博客
增加代码块:
import os os.environ['KMP_DUPLICATE_LIB_OK'] = 'TRUE'
3. 保存excel时报错
报错:
解决方案:虚拟环境下安装xlwt
conda install xlwt
在test.py最后一行代码中.toExcel中使用.
