How to import some data file into ansys 2

[ansyiq]

Hi everyone,

I have got some data file in the form of excel as well as word. It consists of load at various elements of the model. I need to import the data files and apply the loads at varous nodes. As the number of loads as well as elements are quite high around 222000 elements i need to know how can i apply the loads in this situation.

Thanks in advance

 

[ansyiq]

Correction for above post
**elements in place of nodes**

 

[skjoex]

check the *DIM and *TREAD command in ansys manual. Adjust your excel table to format for *TREAD use and "save as" txt-file. Dont forget to specify correct number of rows in *DIM command:

NX = ... !!! number of rows
NY = ... !!! number of columns

*DIM,ex_table,TABLE,NX,NY,1
*TREAD,ex_table,ex_table,txt

then use the do-loop to aply load

*DO,T0,1,NX
...
*ENDDO