使用Openpyxl引用numpy报错

2 个月前

阵雨

IT人

from openpyxl import Workbook
import numpy as np
import datetime
wb = Workbook()
ws = wb.active
ws['A1'] = 1
ws.append([2, 3, 4])
ws['A4'] = 'hello'
ws['A3'] = datetime.datetime.now()
wb.save("sample.xlsx")

报错如下

C:\Users\fred\anaconda3\python.exe D:/LearnPython/20230310PracticeOpenPyxl/Test-01
Traceback (most recent call last):
  File "D:/LearnPython/20230310PracticeOpenPyxl/Test-01", line 1, in <module>
    from openpyxl import Workbook
  File "C:\Users\fred\anaconda3\lib\site-packages\openpyxl\__init__.py", line 4, in <module>
    from openpyxl.compat.numbers import NUMPY, PANDAS
  File "C:\Users\fred\anaconda3\lib\site-packages\openpyxl\compat\__init__.py", line 3, in <module>
    from .numbers import NUMERIC_TYPES
  File "C:\Users\fred\anaconda3\lib\site-packages\openpyxl\compat\numbers.py", line 41, in <module>
    numpy.float,
  File "C:\Users\fred\anaconda3\lib\site-packages\numpy\__init__.py", line 305, in __getattr__