Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

assembly strukture to excel

4 REPLIES 4
Reply
Message 1 of 5
krewlir
264 Views, 4 Replies

assembly strukture to excel

Is it possible to export an assembly structure to excel and keep the structure? Get subassembleys and so on in different columns?
4 REPLIES 4
Message 2 of 5
harco
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
Message 3 of 5
Anonymous
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
Message 4 of 5
krewlir
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?
Message 5 of 5
robmatthews
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.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report