×
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

Outputing dimensions to Excel File?

Outputing dimensions to Excel File?

Outputing dimensions to Excel File?

(OP)
I was asked to try to get all my feature dimensions outputed to an excel file automatically (to try to catch changes/movements/errors).

I am not sure it can be done.  Input is welcome???

I think ideally it would maybe come from the model, but drawing is ok as well.  (I have a fully dimensioned drawing)

RE: Outputing dimensions to Excel File?

Did you have a look at the dimension tracker in draft environment? It may be usefull to track changes to your draft.

Patrick

RE: Outputing dimensions to Excel File?

You can copy and paste from the variable table into an excel file, but if you add or replace dimensions in the model or draft they will get new variable names.
You should be able to do conditional sorting on the excel data to see if variables have been added or modified.

bc

RE: Outputing dimensions to Excel File?

In the variable table in the part enviroment.  Select expose variable on the dimensions you want to track.  Then in the assembly enviroment select tools-reports-bom.  You can customize this reports file for pretty much anything, it will even pick up the exposed dimension on your parts and it will update as well.  Then you can copy the report in to excel.  You might want to name the dimension.  An easy way to do that is to double-click on the dimension and for example if it is the length of the part you simply type L or Length.  I do the same thing with all my parts I have Length, Width, Thickness defined in the variable tables.  I hope this will help.

Scobb

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