CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 8101

CAD tip CAD tip # 13531:

Question CAD 
 %  platform  category 
Q - question

Thumbnails have incorrect size after exporting the BOM to Excel.

A - answer Using the Customize option, I added the thumbnails column with 3D thumbnails of the components to my BOM in Autodesk Inventor. After exporting this bill of material to Excel, the thumbnail images are wider than the dedicated table column and overlap in height as well.

The option to export thumbnails from a BOM is available in Inventor since release 2018.1. In versions earlier than 2023, the exported thumbnail size may be incorrect, but is usually fixed in a subsequent Inventor update. For example, in Inventor 2022, use Update 2022.1 or higher to fix it, in Inventor 2021, use Update 2021.3.2 or higher.

By adjusting the column width in Excel, you can fine-tune the correct aspect ratio of the preview thumbnails.

100% *  CAD 
9.11.2022    2936×  
Prices - CAD eShop:

See also:
Tip 13611:BOM with multi-line items in Inventor.
Tip 12451:How to fill a material or appearance name into part's iProperties?
Tip 11732:How to sort BOM or parts list by part number in Inventor? (iLogic)
Tip 10033:How to export BOM with all assembly levels from Inventor?
Tip 10006:Inventor BOM items are not sorted in the right numerical order.

Back   All CAD Tips

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

DwgTextTranslator translates a series of drawings from one language to another using MS Access.
Download a fully functional trial version.

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.