Populating Point Masses From Excel

[Jeff Gibson]

Hello all​

First post, long-time visitor. I am trying to find a way to populate point masses at coordinates (based on a picked CSYS) from an Excel sheet, and I'm doing this all from within ANSYS Mechanical. My problem is I have not found a way to count rows or directly call data from an Excel sheet. Should I just be using each coordinate as a parameter with the Excel import? That seems tedious.

I am not expecting a complete solution, but any pointers would be hugely helpful. I have experience with NASTRAN, FEMAP, and Abaqus, but ANSYS is totally new to me.

Thank you,

Jeff

 

[L_K]

Can you post a picture what your source excel file looks like?
You can read a range from Excel file as an array. Here's a tutorial to
get you started:

http://www.ironpython.info/index.php?title=Interacting_with_Excel

 

[nodalDOF]

Save the required worksheet as a comma-separated or Tab-delimited text file and use *VREAD or *TREAD to read in the data. I found *TREAD typically more useful as it doesn't require data format specifier.