print("Det valgte nummer eksisterer ikke!")
report_name = reports[int(report_index)]
draft_name = drafts[int(draft_index)]
print("\nValgt rapport:", reports[int(report_index)])
print("Valgt kladde:", drafts[int(draft_index)])
print("\nRapport udfyldes...")
report = load_workbook(
'C:\\Users\\Fredrik\\PycharmProjects\\ReportFiller\\Files\\' + report_name)
file = "C:\\Users\\Fredrik\\PycharmProjects\\ReportFiller\\Files\\" + draft_name
newReport = Report(report)
newReport.get_rownumbers_for_page_two()
print("...")
stylesheet_1 = newReport.get_stylesheet_1()
stylesheet_3 = newReport.get_stylesheet_3()
stylesheet_2 = newReport.get_stylesheet_2()
print("...")
page_one_writer = PageOneWriter(stylesheet_1, file)
page_one_writer.add_data_to_page_one()
page_two_writer = PageTwoWriter(stylesheet_2, file)
page_two_writer.add_data()
print("...")
page_three_writer = PageThreeWriter(stylesheet_3, file)
page_three_writer.add_data_to_page_three()
newReport.report.save('færdig.xlsx')
print("Rapport er udfyldt!")
os.system('start færdig.xlsx')
