Inventor General Discussion

Inventor General Discussion

Reply
Member
krewlir
Posts: 5
Registered: ‎01-28-2010
Message 1 of 5 (155 Views)

assembly strukture to excel

155 Views, 4 Replies
01-28-2010 05:26 AM
Is it possible to export an assembly structure to excel and keep the structure? Get subassembleys and so on in different columns?
*Expert Elite*
harco
Posts: 879
Registered: ‎02-16-2006
Message 2 of 5 (155 Views)

Re: assembly strukture to excel

01-28-2010 11:26 AM in reply to: krewlir
You won't get an indented BOM into excel, but if you export the structured all levels BOM with the item column included, the item column will give a good structure for sorting and manipulating data.
I would advise you to set the number of figures in the item number to the maximum number of parts.
For example if you have over 10 parts set the item values to 00, <100 parts set 000, <1000 parts 0000 .... this will make it easier in excel.
HTH
*Brian Ekins \(Autodesk\)
Message 3 of 5 (155 Views)

Re: assembly strukture to excel

01-28-2010 12:00 PM in reply to: krewlir
Here's approach described here:
http://modthemachine.typepad.com/my_weblog/2010/01/exporting-assembly-structure-to-excel.html
--
Brian Ekins
Inventor API Product Designer
http://blogs.autodesk.com/modthemachine
Member
krewlir
Posts: 5
Registered: ‎01-28-2010
Message 4 of 5 (155 Views)

Re: assembly strukture to excel

01-29-2010 09:48 AM in reply to: krewlir
Brian: its just the way I want it in: http://modthemachine.typepad.com/.a/6a00e553fcbfc688340128772191fb970c-pi

when I do as you say i get all information in the first column in excel? What am i doing wrong?
Distinguished Contributor
robmatthews
Posts: 370
Registered: ‎07-12-2007
Message 5 of 5 (155 Views)

Re: assembly strukture to excel

01-31-2010 05:18 PM in reply to: krewlir
I wrote some code to do essentially the "opposite", that is, import the structure into excel of the current Inventor assy.

Some code tweaking will be necessary to suit your filing structure, and iProps that you wish to import (we have several custom ones). (Plus no doubt you will find more efficient ways of doing some things. This is not documented/commented as fully as it could/should be..)

Place this code into an Excel code module, and run RetrieveInvAssyDetails()

This will overwrite any cell content, so the best be is to use a new sheet.

Have fun.

Edit: you should start by modifying line 38. All our file names should start with 700... hence this line.
=============================================
This is my signature, not part of my post.
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.