{"id":1765,"date":"2024-09-27T21:27:10","date_gmt":"2024-09-27T19:27:10","guid":{"rendered":"https:\/\/matprop.com\/?p=1765"},"modified":"2026-05-28T10:43:40","modified_gmt":"2026-05-28T08:43:40","slug":"create-parts-lists-in-excel","status":"publish","type":"post","link":"https:\/\/matprop.com\/nl\/create-parts-lists-in-excel\/","title":{"rendered":"Stuklijsten maken in Excel"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"1765\" class=\"elementor elementor-1765\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d924192 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d924192\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-95df066\" data-id=\"95df066\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2be54f4 elementor-widget elementor-widget-heading\" data-id=\"2be54f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Sjablonen kopi\u00ebren<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0ee579 elementor-widget elementor-widget-text-editor\" data-id=\"c0ee579\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Het maken van stuklijsten in Inventor is vaak een tijdrovende klus. Gelukkig heeft de Publish Tool een functie om BOM-lijsten te exporteren naar Excel. Hiervoor gebruiken we een sjabloon dat helemaal naar eigen smaak kan worden aangepast. U kunt zoveel templates maken als u wilt.\u00a0<\/p><p>De publicatietool bevat een aantal sjablonen. U vindt deze in:\u00a0<\/p><p><b>\u2018<\/b><span style=\"font-weight: bold;\">C:\\Gebruikersnaam<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\AutodeskApplicatiePlugins<br \/><\/span><b>Matprop Publish Tool\\Contents\\net48\\Sample Files&#8217;<\/b><br \/>or for Inventor 2025 and higher:<br \/><span style=\"font-weight: bold;\">\u2018<\/span><span style=\"font-weight: bold;\">C:\\Gebruikersnaam<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\AutodeskApplicatiePlugins<br \/><\/span><span style=\"font-weight: bold;\">Matprop Publish Tool\\Contents\\<\/span><b>net8.0-windows<\/b><span style=\"font-weight: bold; font-size: 1rem;\">\\Sample Files&#8217;<\/span><\/p><ul><li>Verplaats de Excel-bestanden naar de map: '<strong>....\/Ontwerpgegevens\/Matprop\/'<\/strong><\/li><li>Hernoem de sjabloon die je wilt bewerken.<\/li><li>Je kunt de lay-out op de eerste pagina aanpassen.\u00a0<\/li><li>Op het tabblad 'config' kun je de iProperties koppelen aan de velden uit de Publish Tool.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-c1ce9df\" data-id=\"c1ce9df\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5aa1574 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"5aa1574\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Partslist excel1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTc5NCwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvUGFydHNsaXN0LWV4Y2VsMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"648\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-1024x830.png\" class=\"attachment-large size-large wp-image-1794\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-1024x830.png 1024w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-300x243.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-768x623.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-600x487.png 600w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1.png 1137w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d83003 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d83003\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-667af45\" data-id=\"667af45\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c5b14e8 elementor-widget elementor-widget-heading\" data-id=\"c5b14e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Maak je eigen sjablonen<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-143e2d5 elementor-widget elementor-widget-text-editor\" data-id=\"143e2d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Het is belangrijk om in de eerste kolom het juiste type te kiezen. Kies 'Cel' om een specifieke iProperty aan een cel te koppelen. Je kunt gewoon Cusom iProperties met de naam invoeren en ze worden automatisch herkend.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-8db2d55\" data-id=\"8db2d55\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b28ef0 elementor-widget elementor-widget-image\" data-id=\"3b28ef0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Part list to excel mapping\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTg0NSwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvUGFydC1saXN0LXRvLWV4Y2VsLW1hcHBpbmcucG5nIn0%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"643\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png\" class=\"attachment-large size-large wp-image-1845\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png 881w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-300x241.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-768x617.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-600x482.png 600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-36a6574 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36a6574\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-9a56695\" data-id=\"9a56695\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c3aafe elementor-widget elementor-widget-heading\" data-id=\"2c3aafe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Onderdelenlijst in Excel<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-721f6b6 elementor-widget elementor-widget-text-editor\" data-id=\"721f6b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Open een assemblage en start de publicatietool. De Excel-sjablonen verschijnen automatisch:<\/p><p><strong> Gereedschap -&gt; Stuklijsten Excel.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-f4faab2\" data-id=\"f4faab2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a2e8e2 elementor-widget elementor-widget-image\" data-id=\"9a2e8e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Schermafbeelding 2024-09-27 213432\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTgxNywidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvU2NoZXJtYWZiZWVsZGluZy0yMDI0LTA5LTI3LTIxMzQzMi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"734\" height=\"382\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png\" class=\"attachment-large size-large wp-image-1817\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png 734w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432-300x156.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432-600x312.png 600w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-941b8da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"941b8da\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-c9819d9\" data-id=\"c9819d9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a65773d elementor-widget elementor-widget-heading\" data-id=\"a65773d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Resultaat<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e55ee2 elementor-widget elementor-widget-text-editor\" data-id=\"4e55ee2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Klik op het gewenste sjabloon en wacht tot de BOM-lijst klaar is!\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-f62b5c6\" data-id=\"f62b5c6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d11c7f3 elementor-widget elementor-widget-image\" data-id=\"d11c7f3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Parts List Excel\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTI4NCwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOFwvUGFydHMtTGlzdC1FeGNlbC5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"620\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-1024x793.png\" class=\"attachment-large size-large wp-image-1284\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-1024x793.png 1024w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-300x232.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-768x595.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-600x465.png 600w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel.png 1257w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Copy templates Creating Parts lists in Inventor is often a time-consuming job. Fortunately, the Publish Tool has a function to export BOM lists to Excel. For this we use a template that can be completely customized to your own taste. You can create as many templates as you want.\u00a0 A number of templates are included [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1284,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,30],"tags":[],"class_list":["post-1765","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-publish-tool","category-tutorials"],"_links":{"self":[{"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/posts\/1765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/comments?post=1765"}],"version-history":[{"count":11,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":3948,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/posts\/1765\/revisions\/3948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/media\/1284"}],"wp:attachment":[{"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matprop.com\/nl\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}