Using excel in drawing

Forum|Forum|10 years ago
August 18, 2016
4 replies
5935 views

I have an excel (.xlsx) file with a BOM of an assembly. I wanted to know if it was possible to import that into a drawing directly from excel without having to make the individual cells or having to type all the information in.

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

Assembly Design

Best answer by RonSt.Pierre

Layout tab > select object

select the object type

begs to be asked....

why not use a table with a repeat region?

this will generate a BOM of the assembly.

R

RonSt.Pierre

Answer

12-Amethyst

Layout tab > select object

select the object type

begs to be asked....

why not use a table with a repeat region?

this will generate a BOM of the assembly.

J

jcolon

Author

1-Visitor

The problem is that the BOM is being exported from another program into excel, but we need it in Creo as a drawing. We don't have an assembly of it with models and such therefor a parametric table cannot be made, and we were trying to minimize the work so that we didn't have to type it all in.

But your answer is exactly what we needed. I knew there was an easy way, I just didn't know where it was. Thanks!