×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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

Jobs

Importing Expressions from Excel?

Importing Expressions from Excel?

Importing Expressions from Excel?

(OP)
Is it possible to import expressions from Excel and update existing expressions?

For example, lets say we had a model of tire rim already in use but now we want to import pilot, bolt circle, bolt hole dia, number of bolt holes, width, etc.

Thanks all!

 

RE: Importing Expressions from Excel?

Not directly, but there are two approaches that you could take.

First you can export the 'Expressions' from your spreadsheet into a text file which could then be imported into the NX Expression dialog of a Part file.  See the attached file for a simple example of the text file format showing a couple of options, such as how you indicate the units of the expression and how one would add comments.

Or you could use the Spreadsheet edit function in the Expression dialog to open a spreadsheet into which you could copy & paste the 'expressions' from your spreadsheet as long as you made sure the format was correct (you could experiment with how the system expects to see the expressions by taking some of your existing parts and opening the Expression dialog and selecting the Spreadsheet Edit button at the top of the dialog and then examining how the expressions were display in the spreadsheet.  As long as you are able to match up the formatting scheme you should be good to go.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
UG/NX Museum:   http://www.plmworld.org/p/cm/ld/fid=209

To an Engineer, the glass is twice as big as it needs to be.
 

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!


Resources