Блог

Итак, я наткнулся на стену. Я пытаюсь использовать Openpyxl для переноса даты с одного листа Excel на другой и получаю его ошибку. Ни за что на свете я не могу понять, что я делаю не так, или как это исправить. Похоже, это проблема с целевой рабочей книгой, которую я загружаю. Когда я использую новый пустой файл, он работает нормально. Любая помощь будет оценена.

   File "C:UsersronDocumentsPythonAndreaMilage2.py", line 43, in <module>
    dest_wb = load_workbook('Destination.xlsx')
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 315, in load_workbook
    reader.read()
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 280, in read
    self.read_worksheets()
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 255, in read_worksheets
    charts, images = find_images(self.archive, rel.target)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderdrawings.py", line 27, in find_images
    drawing = SpreadsheetDrawing.from_tree(tree)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsserialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsserialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsserialisable.py", line 87, in from_tree
    obj = desc.expected_type.from_tree(el)
  [Previous line repeated 4 more times]
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsserialisable.py", line 103, in from_tree
    return cls(**attrib)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldrawingtext.py", line 115, in __init__
    self.pitchFamily = pitchFamily
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsbase.py", line 108, in __set__
    super(Min, self).__set__(instance, value)
  File "C:UsersronAppDataLocalProgramsPythonPython39libsite-packagesopenpyxldescriptorsbase.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')
~~~