{"id":766,"date":"2016-12-29T10:00:00","date_gmt":"2016-12-29T08:00:00","guid":{"rendered":"https:\/\/blogs.autodesk.com\/villagebim\/2016\/12\/exemple-dynamo-creation-automatique-de-feuilles-a-partir-d-un-fichier-excel.html"},"modified":"2016-12-29T10:00:00","modified_gmt":"2016-12-29T08:00:00","slug":"exemple-dynamo-creation-automatique-de-feuilles-a-partir-d-un-fichier-excel","status":"publish","type":"post","link":"https:\/\/blogs.autodesk.com\/villagebim\/2016\/12\/exemple-dynamo-creation-automatique-de-feuilles-a-partir-d-un-fichier-excel.html","title":{"rendered":"Exemple Dynamo : cr\u00e9ation automatique de feuilles \u00e0 partir d\u2019un fichier Excel"},"content":{"rendered":"<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba8601970b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"135\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba8605970b-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;<\/p>\n<p style=\"text-align: justify\">Cet article est n\u00e9 de la rencontre d\u2019un utilisateur qui voulait cr\u00e9er automatiquement des feuilles de pr\u00e9sentation Revit \u00e0 partir d\u2019un fichier Excel. M\u00eame si ce script n\u2019est pas compliqu\u00e9, je me suis engag\u00e9 \u00e0 le faire et donc engagement tenu. De plus, j\u2019en ai profit\u00e9 pour vous montrer l\u2019utilisation de Dynamo Player dans la vid\u00e9o en bas de l&#039;article.<\/p>\n<p style=\"text-align: justify\">Apr\u00e8s la cr\u00e9ation d\u2019un fichier Excel avec une liste de noms de plans en colonne, nous allons d\u00e9marrer une nouvelle session de Dynamo For Revit.<\/p>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba860a970b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"240\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b8d244416b970c-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;<\/p>\n<p style=\"text-align: justify\">Nous commen\u00e7ons \u00e0 utiliser un n\u0153ud appel\u00e9 \u201c<em>Excel.ReadFromFile<\/em>\u201d qui permet comme son nom l\u2019indique de lire un fichier Excel.<\/p>\n<p style=\"text-align: justify\">En amont de ce n\u0153ud, nous allons ajouter :<\/p>\n<ul>\n<li>\u201c<em>File Path<\/em>\u201d : permet de pointer sur le fichier Excel,<\/li>\n<li>\u201c<em>File.FromPath<\/em>\u201d : rend accessible le fichier Excel \u00e0 Dynamo,<\/li>\n<li>\u201c<em>String<\/em>\u201d : en stipulant le nom de l\u2019onglet (dans notre cas \u201c&quot;<em>Noms<\/em>\u201d).<\/li>\n<\/ul>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba860e970b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"148\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba8612970b-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;<\/p>\n<p style=\"text-align: justify\">Nous allons utiliser le n\u0153ud bien connu \u201c<em>Flatten<\/em>\u201d, qui transforme une liste compos\u00e9e de sous-listes en une seule liste.<\/p>\n<p style=\"text-align: justify\">Le n\u0153ud \u201c<em>Sheet.ByNameNumberTitleBlockAndViews<\/em>\u201d va cr\u00e9er des feuilles Revit avec les entr\u00e9es suivantes :<\/p>\n<ul>\n<li>\u201c<em>sheetName<\/em>\u201d : noms des feuilles (String),<\/li>\n<li>\u201c<em>sheetNumber<\/em>\u201d : num\u00e9ros des feuilles (String),<\/li>\n<li>\u201c<em>titleBlockFamilyType<\/em>\u201d : la famille de cartouche qui va \u00eatre utilis\u00e9e,<\/li>\n<li>\u201cviews\u201d : les vues qui doivent \u00eatre incorpor\u00e9es aux feuilles .<\/li>\n<\/ul>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01bb095d832e970d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"176\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b8d244416f970c-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"304\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;<\/p>\n<p style=\"text-align: justify\">Concernant \u201c<em>sheetNumber<\/em>\u201d, nous allons :<\/p>\n<ul>\n<li>extraire le nombre de champs trouv\u00e9s dans le fichier Excel (\u201c<em>List.count<\/em>\u201d),<\/li>\n<li>cr\u00e9er un codeblock pour cr\u00e9er une liste de chiffre de 1 au nombre de champs trouv\u00e9s dans Excel,<\/li>\n<li>transformer cette liste en texte car l\u2019entr\u00e9e \u201c<em>sheetNumber<\/em>\u201d doit entre un string,<\/li>\n<\/ul>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01bb095d8333970d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"107\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01bb095d8337970d-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;<\/p>\n<p style=\"text-align: justify\">Enfin, nous allons utiliser :<\/p>\n<ul>\n<li>le n\u0153ud \u201c<em>Family Types<\/em>\u201d et s\u00e9lectionner le cartouche du gabarit utilis\u00e9,<\/li>\n<li>le n\u0153ud \u201c<em>Views<\/em>\u201d&#160; et s\u00e9lectionner une vue de votre gabarit,<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Soit les connections suivantes :<\/p>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b8d2444182970c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"195\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba8618970b-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;<\/p>\n<p style=\"text-align: justify\"><strong><u>R\u00e9sultat<\/u><\/strong><strong><u>&#160;dans Revit :<\/u><\/strong><\/p>\n<p><a href=\"http:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01b7c8ba861c970b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"225\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b01bb095d8340970d-pi\" style=\"background-image: none;padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px;margin-left: auto;margin-right: auto\" title=\"image\" width=\"304\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;<\/p>\n<p style=\"text-align: justify\">Dans la vid\u00e9o ci-dessous, vous trouvez toutes les manipulations mais aussi l\u2019utilisation de Dynamo Player avec la r\u00e9solution d\u2019une erreur \u00e0 cause de l&#039;utilisation d\u2019un Revit en langue Fran\u00e7aise.<\/p>\n<p style=\"text-align: center\">\n<p style=\"text-align: justify\">&#160;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#160;&#160;&#160;&#160; Cet article est n\u00e9 de la rencontre d\u2019un utilisateur qui voulait cr\u00e9er automatiquement des feuilles de pr\u00e9sentation Revit \u00e0 partir d\u2019un fichier Excel. M\u00eame si ce script n\u2019est pas compliqu\u00e9, je me suis engag\u00e9 \u00e0 le faire et donc engagement tenu. De plus, j\u2019en ai profit\u00e9 pour vous montrer l\u2019utilisation de Dynamo Player dans [&hellip;]<\/p>\n","protected":false},"author":13092,"featured_media":2472,"menu_order":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[15,17,6],"tags":[20,403,1094,1095,1096],"class_list":["post-766","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-autodesk-revit","category-nouveautes","category-trucs-et-astuces","tag-autodesk","tag-excel","tag-exemple-dynamo-player","tag-feuilles","tag-nom-plan","dhig-theme--light"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/users\/13092"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/comments?post=766"}],"version-history":[{"count":0,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/766\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media\/2472"}],"wp:attachment":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media?parent=766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/categories?post=766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/tags?post=766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}