print("Starting....") filesRead = 0 # Machine Menu and Select File to read--------------------------------------------------- choice = (input( "Chose a device to log readings from: \n1. CT Analyzer.\n2. Votano.\n")) if (int(choice == "exit") | (int(choice) != 1 | int(choice) != 2 | int(choice) != 3)): print("Incorect selection, please try again!") sys.exit() filePath = input("Enter file Prefix: ") if (filePath == "exit"): sys.exit() for time in ["M", "L", "A"]: for mes in range(1, 4): dfr = Mf.FiletoRead(Mf.switch(int(choice)), filePath, time, mes, filesRead) filePath = dfr[1] if (dfr[0].empty): print("No " + time + str(mes) + " file") else: # Select Values to be read and import them----------------------------------------------- DataVals = Mf.ValuestoWrite(int(choice), dfr[0]) df2w = pd.DataFrame(DataVals[0]) # Load document to write to and calculate current row number book = load_workbook(DataVals[1]) count = Mf.filelLength(book) # Write values to new document writer = pd.ExcelWriter(DataVals[1], engine='openpyxl') writer.book = book