{"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\/fr\/create-parts-lists-in-excel\/","title":{"rendered":"Cr\u00e9er des listes de pi\u00e8ces dans 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\">Mod\u00e8les de copie<\/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>La cr\u00e9ation de nomenclatures dans Inventor est souvent un travail fastidieux. Heureusement, l'outil de publication dispose d'une fonction permettant d'exporter les listes de nomenclatures vers Excel. Pour ce faire, nous utilisons un mod\u00e8le qui peut \u00eatre enti\u00e8rement personnalis\u00e9 \u00e0 votre guise. Vous pouvez cr\u00e9er autant de mod\u00e8les que vous le souhaitez.\u00a0<\/p><p>Un certain nombre de mod\u00e8les sont inclus dans l'outil de publication. Vous les trouverez dans :\u00a0<\/p><p><b>\u2018<\/b><span style=\"font-weight: bold;\">C:\\NUsers\\N\\NAppData\\NRoaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk\\ApplicationPlugins\\<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:\\NUsers\\N\\NAppData\\NRoaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk\\ApplicationPlugins\\<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>D\u00e9placer les fichiers Excel dans le dossier : '<strong>....\/Design Data\/Matprop\/'<\/strong><\/li><li>Renommez le mod\u00e8le que vous souhaitez modifier.<\/li><li>Vous pouvez ajuster la mise en page sur la premi\u00e8re page.\u00a0<\/li><li>Dans l'onglet \"config\", vous pouvez lier les iPropri\u00e9t\u00e9s et les champs de l'outil de publication.<\/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\">Cr\u00e9ez vos propres mod\u00e8les<\/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>Il est important de choisir le bon type dans la premi\u00e8re colonne. Choisissez \"Cellule\" pour lier une iPropri\u00e9t\u00e9 sp\u00e9cifique \u00e0 une cellule. Vous pouvez simplement saisir les iPropri\u00e9t\u00e9s Cusom avec le nom et elles seront automatiquement reconnues.<\/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\">Liste de pi\u00e8ces en 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>Ouvrez un assemblage et lancez l'outil de publication. Les mod\u00e8les Excel apparaissent automatiquement :<\/p><p><strong> Outils -&gt; Listes de pi\u00e8ces 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\">R\u00e9sultat<\/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>Cliquez sur le mod\u00e8le souhait\u00e9 et attendez que la liste des nomenclatures soit pr\u00eate !\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\/fr\/wp-json\/wp\/v2\/posts\/1765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/comments?post=1765"}],"version-history":[{"count":11,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":3948,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/posts\/1765\/revisions\/3948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/media\/1284"}],"wp:attachment":[{"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matprop.com\/fr\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}