Using Microsoft Excel with Pro/ENGINEER

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:[li]PART_TABLE_EDITOR to "EXCEL"[/li][li]BM_GRAPH_TOOL to "EXCEL_LINKED"[/li]

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:[li]Drive Your Pro/ENGINEER Model with a Spreadsheet by Edwin Muirhead. From the Winter 2002 issue of Profiles Magazine.[/li][li]Using Microsoft Excel to Sort Global Interference Check Information from Pro/ENGINEER .(video tutorial)[/li][li]Introduction to Optimization Excel to Pro/ENGINEER through Pro/PROGRAM[/li][li]Integrating Pro/E & MS-Excel with the p-Shell API By David H. Bigelow[/li]