CAD tip # 13531:

Question

CAD
% platform category

Thumbnails have incorrect size after exporting the BOM to Excel.

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.

Inventor2023Inventor2022Inventor2021

* CAD

9.11.2022 2936×

Comments Tell a friend

Prices - CAD eShop:

Inventor

Product Design Collection

applies to: Inventor 2023 · Inventor 2022 · Inventor 2021 ·

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.

Selected tip: Which variable controls the grouping of Zoom operations for Undo?

Back All CAD Tips

iLogic: How to find if a document is a sheet metal part and if it contains holes? « | » How to redefine the behavior of a standard AutoCAD command?

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: OS: Categ:
Text:	FAQ glossary

Featuring:
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.

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2023 \| Advertise with us \| Online privacy

CZ \| EN \| DE
Login or
registration
	Visitors: 8101