Using Excel for NREAD

[bfillery]

Hi all,

I was wondering if anybody knows how to use excel to generate a file that can be used as avnode file for NREAD in Ansys V11. All formats I have tried (.csv etc) either fail or do not read the data correctly.

bfillery

 

[Struct71]

You could use the =concatenate(text1,text2) function in excel to create a text column with the format

N,[node],[x],[y],[z]

Now copy the column to an ascii file and use "read input from" in ansys.


Cheers,