无法使用python脚本保存excel文件

Question

def getFile():
    global filename, path, path2

    filename = QtWidgets.QFileDialog.getOpenFileName()[0]
    path = filename

    print(path)
    

我认为问题在于这个函数

def getTo():
    wb = load_workbook(filename = filename)

文件名函数中的某些设置有误， 我尝试使用unicode，但它不能解决问题

Traceback (most recent call last):
  File "C:/Users/pro10/PycharmProjects/Program/gui5.py", line 118, in getTo
    sheet['A' + str(rows)] = text1
  File "C:\Users\pro10\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\worksheet\worksheet.py", line 313, in __setitem__
    self[key].value = value
  File "C:\Users\pro10\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\cell\cell.py", line 216, in value
    self._bind_value(value)
  File "C:\Users\pro10\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\cell\cell.py", line 199, in _bind_value
    raise ValueError("Cannot convert {0!r} to Excel".format(value))
ValueError: Cannot convert <function text1 at 0x0000023DFE3D3A60> to Excel
 
  

Answer 1

您是否像这样导入了load_workbook函数

from openpyxl import load_workbook