python - 使用openpyx打开下载的excel表格，只有在自己再次保存后才能使用

Question

我想用 Python 打开一个 excel 工作表，但是在尝试打开下载的工作表时出现了一个巨大的错误。

但是，当我在 excel 中打开工作表并将其另存为副本时 - 它适用于该文件。我相信它与安全设置有关（从互联网下载的文件，可能被阻止以保护计算机等）。

我该如何解决这个问题？这是我的python程序：

import openpyxl

wb = openpyxl.load_workbook('C://users//userme/Downloads/file.xlsx')
sheet = wb.active
print (sheet.cell(row=15, column=2).value)

这是错误：

Traceback (most recent call last):
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\base.py", line 57, in _convert
    value = expected_type(value)
TypeError: an integer is required (got type datetime.date)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:/Users/userme/AppData/Local/Programs/Python/Python37-32/xlsimp.py", line 5, in <module>
    wb = openpyxl.load_workbook('C://users//userme/Downloads/Daily_20181002_TTT.xlsx')
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\reader\excel.py", line 211, in load_workbook
    wb.properties = DocumentProperties.from_tree(src)
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\serialisable.py", line 100, in from_tree
    return cls(**attrib)
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\packaging\core.py", line 110, in __init__
    self.modified = modified
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\base.py", line 270, in __set__
    super(DateTime, self).__set__(instance, value)
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\nested.py", line 36, in __set__
    super(Nested, self).__set__(instance, value)
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\base.py", line 69, in __set__
    value = _convert(self.expected_type, value)
  File "C:\Users\userme\AppData\Local\Programs\Python\Python37-32\lib\site-packages\openpyxl\descriptors\base.py", line 59, in _convert
    raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'datetime.datetime'>

标签： pythonpython-3.xopenpyxl