ANSYS AUTOMATION
How can I automate copy pasting values from excel to remote forces tabular data for x,y,z components?
Thanks in advance!
Answers
-
This is a general example of how to interact with Microsoft Excel in mechanical scripting, which is iron python.
https://discuss.ansys.com/discussion/2195/how-to-interact-with-excel-from-mechanical-or-other-applicationsFor PyMechanical, you should be in a typical python environment, and there are a number of general purpose examples/tutorials for how to interact with Excel.
Once you have the data from Excel in a python variable, assigning the values Is the same as any tabular data for an object component field.0 -
-
RL= DataModel.GetObjectsByType(DataModelObjectCategory.RemoteForce)
RL1 = RL[0]
RL1.DefineBy = LoadDefineBy.Components
RL1.IndependentVariable = LoadVariableVariationType.Step
import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel
excel = Excel.ApplicationClass()
filename = r"C:\FUN\PREPROCESSING_AUTOMATION\ALL_LOADS_H1.xlsx"
workbook = excel.Workbooks.Open(filename)
ws=workbook.worksheets("Sheet1")
time = []
load1 = []
load2 = []
load3 = []
for i in range(1, 73):
cell_value1 = ws.Range["A" + str(i)].Value2
cell_value2= ws.Range["B" + str(i)].Value2
cell_value3= ws.Range["C" + str(i)].Value2
ip_quantity = Quantity(i, "sec")
time.append(ip_quantity)
op_quantity1 = Quantity(cell_value1, "N")
op_quantity2 = Quantity(cell_value2, "N")
op_quantity3 = Quantity(cell_value3, "N")
load1.append(op_quantity1)
load2.append(op_quantity2)
load3.append(op_quantity3)
RL1.XComponent.Inputs[0].DiscreteValues = time
RL1.XComponent.Output.DiscreteValues = load1
RL1.YComponent.Output.DiscreteValues = load2
RL1.ZComponent.Output.DiscreteValues = load3Iam able to get the solution with the above code it works good. Thanks for all the comments
1