Π Π°Π·ΡΠ°Π±ΠΎΡΠΊΠ° ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠΉ Π΄Π»Ρ ΠΠ. ΠΠΎΡΠ°Π±ΠΎΡΠΊΠ° ΡΡΡΠ΅ΡΡΠ²ΡΡΡΠ΅Π³ΠΎ ΠΏΡΠΎΠ΄ΡΠΊΡΠ°. ΠΠ· Π΄Π²ΡΡ
ΠΌΠΎΠ΄ΡΠ»Π΅ΠΉ Π½Π°Π΄ΠΎ ΠΎΠ΄Π½ΠΎΠ²ΡΠ΅ΠΌΠ΅Π½ΠΎ ΡΠΈΡΠ°ΡΡ ΠΈΠ· ΡΡΠ΅ΠΉΠΊΠΈ ΡΠΊΡΠ΅Π»Ρ , Π²ΡΠ΄Π°Π΅ΡΡΡ ΠΎΡΠΈΠ±ΠΊΠ° file is not zip ΡΠ΅ΡΠ΅Π· ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΠΎΠ΅ Π²ΡΠ΅ΠΌΡ ΡΠ°Π±ΠΎΡΡ ΠΊΠΎΠ΄Π° , Lock ΡΡΠΎΠΈΡ Π½ΠΎ Π½Π΅ ΠΏΠΎΠΌΠΎΠ³Π°Π΅Ρ while True: a = GetAvailableDate() print(a) while True: b = GetAvailableDate() print(b) def GetAvailableDate(): while True: try: CurrentDate = read_cell(file_path, 3, 2) return CurrentDate except zipfile.BadZipFile: print(“CooΠ±ΡΠ΅Π½ΠΈΠ΅ ΠΈΠ· except - ΠΡΠΈΠ±ΠΊΠ° ΡΡΠ΅Π½ΠΈΡ ΡΠ°ΠΉΠ»Π°: ΡΠ°ΠΉΠ» Π½Π΅ ΡΠ²Π»ΡΠ΅ΡΡΡ zip-Π°ΡΡ
ΠΈΠ²ΠΎΠΌ“) input(“Π‘Π΄Π΅Π»Π°ΠΉ, ΡΡΠΎ-Π½ΠΈΠ±ΡΠ΄Ρ ΠΈ Π½Π°ΠΆΠΌΠΈ Enter Π΄Π»Ρ ΠΏΡΠΎΠ΄ΠΎΠ»ΠΆΠ΅Π½ΠΈΡ...“) time.sleep(15) def initialize_workbook(file_path): lock.acquire() workbook = load_workbook(file_path) #workbook = load_workbook(file_path, read_only=False, keep_links=False) sheet = workbook['Clients'] return workbook, sheet def read_cell(file_path, row, column): workbook, sheet = initialize_workbook(file_path) value = sheet.cell(row=row, column=column).value lock.release() return value def write_cell(file_path, row, column, value): workbook, sheet = initialize_workbook(file_path) sheet.cell(row=row, column=column).value = value workbook.save(file_path) lock.release().