Excel import into ProE Wildfire
Excel import into ProE Wildfire
(OP)
ok I am asking a question I assume has been discussed before but I cannot find an archive on it.
I want to know how to import an excel table text into a Pro-E drawing.
I want to know how to import an excel table text into a Pro-E drawing.





RE: Excel import into ProE Wildfire
Best Regards,
Heckler
Sr. Mechanical Engineer
SW2005 SP 5.0 & Pro/E 2001
Dell Precision 370
P4 3.6 GHz, 1GB RAM
XP Pro SP2.0
NVIDIA Quadro FX 1400
o
_`\(,_
(_)/ (_)
"Coming together is a beginning, staying together is progress, and working together is success." - Henry Ford
RE: Excel import into ProE Wildfire
In the existing MS Excel spreadsheet, add the following columns:
Add a column to the left of the existing columns, and enter @[ preceded by a single quote.
Between each column of text, enter @]@[ preceded by a single quote.
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 pads the cells with enought spaces to make everything line up correctly.
Import the resulting text file as a note in Pro/E
- - - - - -
Unfortunately the general concensus seems to be that there is no good way to populate a table with external data; i.e. from a spreadsheet, csv, etc.
RE: Excel import into ProE Wildfire
Your way worked correctly but it is a real task of labor to get there.
The first suggested way does not work in product view.
Thanks guys.