Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Populating Point Masses From Excel

Populating Point Masses From Excel

Populating Point Masses From Excel

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,


RE: Populating Point Masses From Excel

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


White Paper - PLM and ERP: Their Respective Roles in Modern Manufacturing
Leading manufacturers are aligning their people, processes, and tools from initial product ideation through to field service. They do so by providing access to product and enterprise data in the context of each person’s domain expertise. However, it can be complicated and costly to unite engineering with the factory and supply chain. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close