26-03 使用Excel实现ANSYS参数化快速计算让计算产生质的飞跃!

# IronPython imports to enable Excel interopimport clrimport osclr.AddReference("Microsoft.office.Interop.Excel")import Microsoft.Office.Interop.Excel as Excel# Define working directory workingDir=AbsUserPathName("E:\\2026\\ddd\\aaaaaaaaa\\ANSYS.WORKBENCH\\ex18")def updateHandler():# Update can take long, so disable the Excel warning -# "Excel is waiting for another application to complete an OLE action"	ex.Application.DisplayAlerts=False# Define key ranges in the Workbook	lengthcell = worksheet,Range["B3"]	loadCell =worksheet.Range["C3"]	defCell = worksheet.Range["D3"]# Get the Workbench Parameters	lengthParam =Parameters.GetParameter (Name="p3")	loadParam=Parameters.GetParameter(Name="p1")	defParam = Parameters.GetParameter(Name="P2")# Assign values to the input parameters	lengthParam.Expression =lengthCeli.Value2.Tostring()+"[mm]"	loadParam.Expression=loadCell.Value2.Tostring()+"[N]"# Mark the deformation parameter as updating in the workbook	defCell.Value2="Updating..."# Run the project update	Update()# Update the workbook value from the WB parameter	defCell.Value2 = defParam.Value# restore alert setting	ex.Application.DisplayAlerts = True# Open the Workbench Project	Open(FilePath=os.path.join(workingDir,"EX18.0.wbpj"))# Open Excel and the workbook	ex = Excel.ApplicationClass()	ex.Visible=True	workbook=ex.Workbooks.Open(os.path.join(workingDir,"EX18.0.xlsx"))	worksheet=workbook.ActiveSheet#Apply the update handler to the workbook button	OLEbutton=worksheet.OLEObjects("CommandButton1")	commandButton=OLEbutton.Object	commandButton.CLICK += updateHandler