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: 

Bill of Materials Export Not Working Properly

6 REPLIES 6
SOLVED
Reply
Message 1 of 7
Anonymous
2399 Views, 6 Replies

Bill of Materials Export Not Working Properly

After trying to export my bill of materials, I have found that it is not properly exporting into Excel. It opens as a bunch of code instead of giving me the table that I am trying to acquire.Screen Shot 2018-01-09 at 12.13.49 PM.png

6 REPLIES 6
Message 2 of 7
johnsonshiue
in reply to: Anonymous

Hi Henry,

 

The information you provided so far is enough for me to comment further. Could you attach an example of the assembly (iam and ipt files) and describe the exact workflow you used to export the BOM?

Many thanks!



Johnson Shiue (johnson.shiue@autodesk.com)
Software Test Engineer
Message 3 of 7
Frederick_Law
in reply to: Anonymous

Looks like you exported to xml file instead of xls file.

Message 4 of 7
MechMachineMan
in reply to: Anonymous

It looks like you are actually clicking the export for the Inventor BOM SETTINGS.

 

Note that there are 2 "Export" buttons in the Bill of Materials window.

 

The one you want to be using is in the top left corner of the window.


--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type
Message 5 of 7
Anonymous
in reply to: MechMachineMan

The export function from the top left is greyed out. I am unable to click it. Is there some place that I can go to turn that on?

Message 6 of 7
Anonymous
in reply to: Frederick_Law

XML was my only option.

Message 7 of 7
kelly.young
in reply to: Anonymous

Hello @Anonymous when you are trying to export the BOM have you enabled either Structured or Parts Only?

 

ExportBOM.png

 

Once you do this it will become highlighted and you can export to multiple different formats.

 

ExportBOM2.png

 

Hope that helps!

 

Please select the Accept as Solution button if a post solves your issue or answers your question.

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

Post to forums  

Autodesk Design & Make Report