EXCEL FILE HELP!!

[Anonymous]

I have a assembly that requires a bill of materials is there a way to import an excel file to use as the bom.

[Anonymous]

You can export a BOM from IV into Excel

--
Dell 670 dual Xeon - 3.2
3gb memory, SCSI320-15k
XP-Pro, sp2
Quadro FX3400: Driver: 162.65 Direct3D
IV2008-pro sp2,
SpacePilot Rel V: 3.5.4 Dvr V: 6.4.4 Firmware 3.12

<311fan0604> wrote in message news:5829379@discussion.autodesk.com...
I have a assembly that requires a bill of materials is there a way to import
an excel file to use as the bom.

[Anonymous]

No that is not what i am asking i am asking to IMPORT from excel to inventor.

[Anonymous]

If you are asking: Is there a way to populate an empty Inventor assembly
with components by importing an Excel file which represents the assembly
BOM?

The answer would be: No, that functionality is not currently directly
supported by Inventor.

You should be able to create a macro that would read an Excel file that
contained a listing of parts and that would subsequently place those parts
into an empty assembly however unless your Excel file has absolute position
data, you would simply get a bunch of parts placed (presumably) at the
assembly origin. This would assume that the component parts existed as
Inventor files (or as files that could be imported into Inventor).

If the above was not what you had in mind, be more specific with your
follow-up explanation.

--
Gary R. Smith
Autodesk Inventor Team
Portland, OR
2.33GHz 2GB IBM ThinkPad T60p; XP pro SP2
ATI Mobility FireGL V5250 driver: 8.293.1.0

[Anonymous]

Inventor creates BOM in the .iam file from all parts that it contains (real and virtual components). That is actually the point - BOM always reflects what the model is. Importing excel file into .iam makes no sense. If you want to display some table in the .idw file along with the view of your model you can go INSERT menu - OBJECT - Microsoft Excel Worksheet - than paste your table in excel and chose return in the excel file menu.

Hope it helps

Igor

[Anonymous]

You can import an excel spreadsheet into a Table in IDW.

--
Dennis Jeffrey, Autodesk Inventor Certified Expert
Autodesk Manufacturing Implementation Certified Expert.
260-399-6615
Instructor/Author/Sr. App Engr.
AIP 11SP3, AIP 2008 SP2, PcCillin AV
HP zv5000 AMD64 ( modified)
Geforce Go 440, Driver: .8185, 2GB RAM
XP Pro SP2, Windows XP Silver Theme
http://teknigroup.com

[Anonymous]

Second try on re-reading original posting:

> I have a assembly...

Presumably of Inventor parts?

> that requires a bill of materials

That differs from the parts you would see if you were to use the Inventor
BOM capability?

> is there a way to import an excel file to use as the bom.

You can not import your Excel spreadsheet into the Inventor Assembly BOM
functionality.
You can place your Excel spreadsheet in an assembly drawing and not use any
of the BOM capabilities built into Inventor.

[Anonymous]

Thats OK Gary, I'm confused also.... It's nice to meet another person who
cannot fill in the blanks left by a poster....

I PRESUMED he was talking about an IDW/DWF file.... 🙂

--
Dennis Jeffrey, Autodesk Inventor Certified Expert
Autodesk Manufacturing Implementation Certified Expert.
260-399-6615
Instructor/Author/Sr. App Engr.
AIP 11SP3, AIP 2008 SP2, PcCillin AV
HP zv5000 AMD64 ( modified)
Geforce Go 440, Driver: .8185, 2GB RAM
XP Pro SP2, Windows XP Silver Theme
http://teknigroup.com

[Anonymous]

After re-reading, I am thinking an IAM and trying to create the assembly via
an Excel spread sheet. Possibly a iAssembly to have a table driven assembly.

--
Dell 670 dual Xeon - 3.2
3gb memory, SCSI320-15k
XP-Pro, sp2
Quadro FX3400: Driver: 162.65 Direct3D
IV2008-pro sp2,
SpacePilot Rel V: 3.5.4 Dvr V: 6.4.4 Firmware 3.12

"Dennis Jeffrey" wrote in message
news:5829570@discussion.autodesk.com...
Thats OK Gary, I'm confused also.... It's nice to meet another person who
cannot fill in the blanks left by a poster....

I PRESUMED he was talking about an IDW/DWF file.... 🙂

--
Dennis Jeffrey, Autodesk Inventor Certified Expert
Autodesk Manufacturing Implementation Certified Expert.
260-399-6615
Instructor/Author/Sr. App Engr.
AIP 11SP3, AIP 2008 SP2, PcCillin AV
HP zv5000 AMD64 ( modified)
Geforce Go 440, Driver: .8185, 2GB RAM
XP Pro SP2, Windows XP Silver Theme
http://teknigroup.com

[Anonymous]

thanks everyone for the input this will differently help me.

[Anonymous]

So, who was right?
What helped you?

Mike

<311fan0604> wrote in message news:5829582@discussion.autodesk.com...
thanks everyone for the input this will differently help me.