Tabular Data indexing when importing load data from an external file

Question

Hello,

I was trying to use a script that was posted here in order to load Force data from an external excel file.
https://discuss.ansys.com/discussion/comment/6186?tab=all#Comment_6186

The error I'm getting is:

"Index was out of range. Must be non-negative and less than the size of the collection."

It seems that in order for this script to work I need to manually change the table value so that they do not have a "=" sign automatically placed in the cells.

My question is: how to automatically populate a Tabular Data with "1" (cause 0s wont work) using Mechanical / ACT API?

JaydenDagostin · Accepted Answer

Hi @Dominique_Cracovia, you need to set the inputs field to contain multiple time values. I've made a slight edit to Erik's script at https://discuss.ansys.com/discussion/comment/6186?tab=all#Comment_6186 to show this.

import clr

clr.AddReference("Microsoft.Office.Interop.Excel")

import Microsoft.Office.Interop.Excel as Excel

excel = Excel.ApplicationClass()

## Create Windows explorer pop-up

filename = r'D:\myload.xlsx' # open this file

workbook = excel.Workbooks.Open(filename)

inputdata=workbook.Worksheets("ForceMoment").Select()# Select Worksheet by Name 

ws1 = workbook.Worksheets("ForceMoment")

rf=ExtAPI.DataModel.GetObjectsByName('Remote Force')[0] # get force

rm=ExtAPI.DataModel.GetObjectsByName('Moment')[0] # get moment

unF=ExtAPI.DataModel.CurrentConsistentUnitFromQuantityName('Force')

unM=ExtAPI.DataModel.CurrentConsistentUnitFromQuantityName('Moment')

maxTime = 3

timeUnit = '[sec]'

timesteps = []

for t in range(1,maxTime+1):

    timesteps.append(str(t) + timeUnit)

time_input = [Quantity(time) for time in timesteps]

rf.XComponent.Inputs[0].DiscreteValues = time_input

rf.YComponent.Inputs[0].DiscreteValues = time_input

rf.ZComponent.Inputs[0].DiscreteValues = time_input

rm.XComponent.Inputs[0].DiscreteValues = time_input

rm.YComponent.Inputs[0].DiscreteValues = time_input

rm.ZComponent.Inputs[0].DiscreteValues = time_input

for t in range(1,maxTime+1):

    Fx=((ws1.Cells(t,1).Value2)) # read first row and first column

    Fy=((ws1.Cells(t,2).Value2)) # etc

    Fz=((ws1.Cells(t,3).Value2))

Mx=((ws1.Cells(t,4).Value2))

    My=((ws1.Cells(t,5).Value2))

    Mz=((ws1.Cells(t,6).Value2))

rf.XComponent.Output.SetDiscreteValue(t-1, Quantity(Fx, unF)) # assign loads

    rf.YComponent.Output.SetDiscreteValue(t-1, Quantity(Fy, unF))

    rf.ZComponent.Output.SetDiscreteValue(t-1, Quantity(Fz, unF))

rm.XComponent.Output.SetDiscreteValue(t-1, Quantity(Mx, unM))

    rm.YComponent.Output.SetDiscreteValue(t-1, Quantity(My, unM))

    rm.ZComponent.Output.SetDiscreteValue(t-1, Quantity(Mz, unM))

excel.Application.Quit()

excel.Quit()