Inventor General

Posts: 5
Registered: ‎01-28-2010
Message 1 of 5 (150 Views)

assembly strukture to excel

150 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*
Posts: 873
Registered: ‎02-16-2006
Message 2 of 5 (150 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.
*Brian Ekins \(Autodesk\)
Message 3 of 5 (150 Views)

Re: assembly strukture to excel

01-28-2010 12:00 PM in reply to: krewlir
Here's approach described here:
Brian Ekins
Inventor API Product Designer
Posts: 5
Registered: ‎01-28-2010
Message 4 of 5 (150 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:

when I do as you say i get all information in the first column in excel? What am i doing wrong?
Distinguished Contributor
Posts: 370
Registered: ‎07-12-2007
Message 5 of 5 (150 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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community

Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor