×
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


    Resources

    Low-Volume Rapid Injection Molding With 3D Printed Molds
    Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
    Design for Additive Manufacturing (DfAM)
    Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
    Taking Control of Engineering Documents
    This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. 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