×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

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!

*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

Modeling Strategies

Using Microsoft Excel with Pro/ENGINEER by mloew
Posted: 24 Feb 04 (Edited 3 May 06)

Many users have complained that Pro/E has limited interfacing capabilities with MS Excel. While the integration with Excel might not be  as uniform as with some other MCAD products, there are many useful ways to integrate spreadsheets within Pro/E. Here are some descriptions and links I have come up with:

You can use MS Excel as the table editor and for graphing in BMX by setting the environment variables as follows:
  • PART_TABLE_EDITOR to "EXCEL"
  • BM_GRAPH_TOOL to "EXCEL_LINKED"


  • Use the following menu picks to import an Excel spread sheet into a Pro-E drawing:
    Insert --> Object --> Microsoft Excel Worksheet
    This was discussed in thread554-63195 and thread554-147845

    Check the PTC Knowledge Base under the Support Tools heading with the keyword "Excel". Specifically, see About the Excel Analysis and Excel Analysis Feature functionality in Behavioral Modeling . Note: You need to be a maintenance paying customer to access this information.


    Here are some other tutorials or articles I have found:
  • Drive Your Pro/ENGINEER Model with a Spreadsheet by Edwin Muirhead. From the Winter 2002 issue of Profiles Magazine.
  • Using Microsoft Excel to Sort Global Interference Check Information from Pro/ENGINEER .(video tutorial)
  • Introduction to Optimization Excel to Pro/ENGINEER through Pro/PROGRAM
  • Integrating Pro/E & MS-Excel with the p-Shell API By David H. Bigelow

  • Back to PTC: Creo Parametric (Pro/ENGINEER) FAQ Index
    Back to PTC: Creo Parametric (Pro/ENGINEER) Forum


    My Archive


    News


    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