解决方法1:降numpy版本。把原来的numpy库删掉再下指定版本。
pip install numpy == 1.23.5
如果太慢了,从镜像下载:
pip install -i https://pypi.tuna.tsinghua. edu.cn/simple numpy==1.23.5
解决方法2:
找到Lib\site-packages\openpyxl\compat\numbers.py文件(我的文件在anaconda目录里面)把numpy.float删除。或者跟着报错的代码点击直接跳到numbers.py文件。
if NUMPY:
NUMERIC_TYPES = NUMERIC_TYPES + (numpy.short,
numpy.ushort,
numpy.intc,
numpy.uintc,
numpy.int_,
numpy.uint,
numpy.longlong,
numpy.ulonglong,
numpy.half,
numpy.float16,
numpy.single,
numpy.double,
numpy.longdouble,
numpy.int8,
numpy.int16,
numpy.int32,
numpy.int64,
numpy.uint8,
numpy.uint16,
numpy.uint32,
numpy.uint64,
numpy.intp,
numpy.uintp,
numpy.float32,
numpy.float64,
# numpy.float, 这句删除了
numpy.bool_,
numpy.floating,
numpy.integer)