python - ValueError：最大值为 52 - 目标 excel 文件问题

Question

所以我碰壁了。我正在尝试使用 Openpyxl 将日期从一个 excel 表移动到另一个，并得到他的错误。对于我的生活，我无法弄清楚我做错了什么，或者解决它。这似乎是我正在加载的目标工作簿的问题。当我使用新的空文件时，它工作正常。任何帮助，将不胜感激。

  File "C:\Users\ron\Documents\Python\AndreaMilage2.py", line 43, in <module>
    dest_wb = load_workbook('Destination.xlsx')
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
    reader.read()
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 280, in read
    self.read_worksheets()
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 255, in read_worksheets
    charts, images = find_images(self.archive, rel.target)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\drawings.py", line 27, in find_images
    drawing = SpreadsheetDrawing.from_tree(tree)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  [Previous line repeated 4 more times]
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
    return cls(**attrib)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\drawing\text.py", line 115, in __init__
    self.pitchFamily = pitchFamily
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\descriptors\base.py", line 108, in __set__
    super(Min, self).__set__(instance, value)
  File "C:\Users\ron\AppData\Local\Programs\Python\Python39\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

~~~
from openpyxl import load_workbook
from openpyxl import Workbook
trips = int(input('How many trips?'))

#Load Workbooks and read sheets
src_wb = load_workbook('Source.xlsx')
dest_wb = load_workbook('Destination.xlsx')

src_sheet = src_wb["Trips"]
dest_sheet = dest_wb["Mileage"]


#Importing Date
for i in range(1,trips+1):
    dest_sheet.cell(row=i+7, column=1).value = src_sheet.cell(row=i+23, column=5).value
#Importing Start
for i in range(1,trips+1):
    dest_sheet.cell(row=i+7, column=2).value = src_sheet.cell(row=i+23, column=3).value
#Importing End
for i in range(1,trips+1):
    dest_sheet.cell(row=i+7, column=4).value = src_sheet.cell(row=i+23, column=4).value
#Importing Notes
for i in range(1,trips+1):
    dest_sheet.cell(row=i+7, column=5).value = src_sheet.cell(row=i+23, column=9).value
#Importing Miles
for i in range(1,trips+1):
    dest_sheet.cell(row=i+7, column=10).value = src_sheet.cell(row=i+23, column=2).value


src_wb.save('Source.xlsx')
dest_wb.save('Destination.xlsx')
~~~

标签： pythonexcelopenpyxlvalueerror