openpyxl.load__workbook(filename）报错ValueError: Max value is 52

Question

openpyxl.load__workbook(filename）报错ValueError: Max value is 52，但是只有个别表格会出现报错，什么原因？

import openpyxl
filename="测试2.xlsx"#读取excel
workbook=openpyxl.load_workbook(filename,data_only=True)
worksheet=workbook.get_sheet_by_name("Sheet1")

报错信息如下：

 File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py", line 314, in load_workbook
    reader.read()
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py", line 279, in read
    self.read_worksheets()
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py", line 254, in read_worksheets
    charts, images = find_images(self.archive, rel.target)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\drawings.py", line 27, in find_images
    drawing = SpreadsheetDrawing.from_tree(tree)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  [Previous line repeated 3 more times]
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
    return cls(**attrib)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\drawing\text.py", line 115, in __init__
    self.pitchFamily = pitchFamily
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\base.py", line 108, in __set__
    super(Min, self).__set__(instance, value)
  File "C:\Users\mayn\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\descriptors\base.py", line 87, in __set__
    raise ValueError('Max value is {0}'.format(self.max))
ValueError: Max value is 52

Answer 1

https://blog.csdn.net/qiwulongqingying1/article/details/91436768