Ask and answer engineering questions

Learn from millions of experts

Feed

how to use spreadsheet in automation of model in nx

By anbu on 23 Mar 02:41 2 answers 5970 views 0 comments

how?

2 answers

  • Samu Suojanen
    Samu Suojanen over 3 years ago

    Basically you have to link a specific expression to an Excel spreadsheet's cell. You can get started by adding an expression and clicking "Extended text entry" next to Formula field. Choose "Insert Function".

    Here are all the functions you can use in NX expressions. Select category called "spreadsheet" and you get the functions to work with Excel spreadsheet. Simplest function is "ug_excel_read" where you define the spreadsheet and specific cell in that spreadsheet to be read to NX. "ug_cell_read" is similar but it can read text too which is handy in creating complex parametric models. Remember to give name to the expression you created.

    Then you can use this expression in sketch for example to call a value from Excel cell.

    This method is good for example for sketching and updating curves that have accurate dimensions given.

  • siva
    siva over 3 years ago

    Excel is widely used for many types of automation in NX. You may need to define your design intention clearly. Where do you want to automate? Standard Assembly componets, similar parts with difference in dimensions (family parts), Just modeling a standalone component and making it as template?

Add your answer to: "how to use spreadsheet in automation of model in nx"

Save Cancel