用python完成以下需求：try path = rCUserssDesktop username oschdirpath dircontent = oslistdirpath for i in dircontent if BenchmarkAutomation in i Z = ospathjoinpath i Result

import os import pandas as pd from openpyxl import load_workbook

try: path = r"C:\Users%s\Desktop" % username os.chdir(path) dircontent = os.listdir(path) for i in dircontent: if 'BenchmarkAutomation' in i: Z = os.path.join(path, i, 'Result') os.chdir(Z) dircontent = os.listdir(Z) for file_name in dircontent: if '[SystemInformation]' in file_name and '.csv' in file_name: # 读取CSV文件 csv_path = os.path.join(Z, file_name) df = pd.read_csv(csv_path) value11 = df.iat[9, 2] value12 = df.iat[10, 2] value13 = df.iat[11, 2] value14 = df.iat[12, 2] value15 = df.iat[13, 2] value16 = df.iat[14, 2] value20 = df.iat[18, 2] value24 = df.iat[22, 2] value50 = df.iat[48, 2] value51 = df.iat[49, 2] value54 = df.iat[52, 2] value55 = df.iat[53, 2] value56 = df.iat[54, 2] value57 = df.iat[55, 2] value60 = df.iat[58, 2] value61 = df.iat[59, 2] value62 = df.iat[60, 2] value63 = df.iat[61, 2] value66 = df.iat[64, 2] value67 = df.iat[65, 2] value100 = df.iat[98, 2] value101 = df.iat[99, 2] value102 = df.iat[100, 2] value107 = df.iat[105, 2] value108 = df.iat[106, 2] value112 = df.iat[110, 2] value113 = df.iat[111, 2] value114 = df.iat[112, 2] value116 = df.iat[114, 2] value117 = df.iat[115, 2] value121 = df.iat[119, 2] value122 = df.iat[120, 2] value123 = df.iat[121, 2] value124 = df.iat[122, 2] value125 = df.iat[123, 2] excel_file = os.path.join(path,r'Ignis_ADH(IH70A) VGA regression Phase Battery life and Performance Test Report.xlsx') workbook = load_workbook(excel_file) sheet = workbook['Result'] column = 'G' while sheet[column+'1'].value is not None: column = chr(ord(column) + 1) sheet[column+'1'] = value11 sheet[column+'2'] = value12 sheet[column+'5'] = value13 sheet[column+'3'] = value14 sheet[column+'19'] = value15 sheet[column+'20'] = value16 sheet[column+'34'] = value20 sheet[column+'35'] = value24 sheet[column+'7'] = value50 sheet[column+'8'] = value51 sheet[column+'9'] = value54 sheet[column+'10'] = value55 sheet[column+'11'] = value56 sheet[column+'12'] = value57 sheet[column+'13'] = value60 sheet[column+'14'] = value61 sheet[column+'15'] = value62 sheet[column+'16'] = value63 sheet[column+'17'] = value66 sheet[column+'18'] = value67 sheet[column+'21'] = value100 sheet[column+'22'] = value101 sheet[column+'23'] = value102 sheet[column+'24'] = value107 sheet[column+'27'] = value108 sheet[column+'25'] = value112 sheet[column+'28'] = value113 sheet[column+'36'] = value114 sheet[column+'37'] = value116 sheet[column+'38'] = value117 sheet[column+'45'] = value121 sheet[column+'46'] = value122 sheet[column+'47'] = value123 sheet[column+'48'] = value124 sheet[column+'49'] = value125 workbook.save(excel_file) time.sleep(30) break except Exception as e: print(e)