Excel import into ProE Wildfire

[ProEDesigner00]

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.

 

[Heckler]

Check this thread thread554-63195

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

 

[jeff4136]

As that thread is archived hope no one minds my tacking on a tip given by Brian Adkins in another forum if an alternative to OLE objects is desired:

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.

 

[ProEDesigner00]

Jeff

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.