Continue to Site

Welcome to MCAD Central

Join our MCAD Central community forums, the largest resource for MCAD (Mechanical Computer-Aided Design) professionals, including files, forums, jobs, articles, calendar, and more.

Importing Excel into pro/e table

Garry Amm

New member
Does anyone know if it is possible to take information from an excel file and


reproduce it as a table on a drawing?


If so, please let me know...it would be a great time saver!!!
 
Not exactly as a table but this will make a note that looks like a table.

In the existing MS Excel spreadsheet, add the following columns:
1) Add a column to the left of the existing columns, and enter @[ preceded by a single quote.
2) Between each column of text, enter @]@[ preceded by a single quote.
3) Add an extra column to the right of the existing columns, and enter @] preceded by a single quote.

Save the file as a space delimited (*.prn) file, and then modify the file name to have a (*.txt) extension.
This text file can then be used in a drawing note, by selecting #detail; #create; #note; using the #file option.
 
Garry Amm, did you get any other feedback on this topic?

I have the same problem, and I can't seem to find an answer I'm happy with.
 

Sponsor

Articles From 3DCAD World

Back
Top