import pyvisaimport timefrom openpyxl import Workbookimport datetimerm = pyvisa.ResourceManager()Wave_addr = 'TCPIP0::xx.xxx.xxx.xx::inst0::INSTR'Power_addr = 'TCPIP0::xx.xxx.xxx.xx::inst0::INSTR'Wave_name = rm.open_resource(Wave_addr)Power_name = rm.open_resource(Power_addr)wb = Workbook()ws = wb.activews.title = "-30数据"ws.append(["占空比", "电流", "状态"])for i in range(10, 100): Wave_name.write("FUNCtion:SQUare:DCYCle " + str(i)) for j in range(0, 80): time.sleep(0.5) Current = Power_name.query("MEAS:CURR? (@1)") if float(Current) <= 0.02: status = "报警" else: status = "正常" print("占空比:" + str(i) + ",电流为" + Current + status) ws.append([str(i), float(Current), status]) Wave_name.write("FUNCtion:SQUare:DCYCle 1") now = datetime.datetime.now() timestamp = now.strftime("%Y%m%d_%H%M%S") wb.save("test" + str(i) + " " + timestamp + ".xlsx") print("停止") time.sleep(30)