{"id":14777,"date":"2022-05-05T14:37:38","date_gmt":"2022-05-05T12:37:38","guid":{"rendered":"https:\/\/www.mydral.com\/?p=14777"},"modified":"2026-08-20T15:41:25","modified_gmt":"2026-08-20T13:41:25","slug":"how-tocombiner-plusieurs-feuilles-excel-sur-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/","title":{"rendered":"Combiner plusieurs feuilles Excel sur Knime"},"content":{"rendered":"<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n\r\n\r\n\r\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size\"><strong><span style=\"font-size: 27px; font-family: 'Work Sans'; color: #ff5135;\">Introduction :<\/span><\/strong><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Aujourd&rsquo;hui, nous allons aborder un sc\u00e9nario particulier qui peut sembler ennuyeux mais qui devient facile \u00e0 r\u00e9soudre une fois que nous avons mis en place notre logique.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Supposons que vous devez analyser l&rsquo;\u00e9volution des ventes d&rsquo;une entreprise sur les trois derni\u00e8res ann\u00e9es.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">L&rsquo;historique de ces ventes se trouve sur un fichier Excel, regroupant au total 36 feuilles ( chaque feuille contient les ventes d&rsquo;un mois donn\u00e9 pour une ann\u00e9e donn\u00e9e).<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Afin de d\u00e9marrer l&rsquo;analyse, il faut donc regrouper nos diff\u00e9rentes feuilles en une seule.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Le faire manuellement est une option mais lorsque le nombre de feuilles est \u00e9lev\u00e9 comme dans notre cas, il est plus judicieux de recourir aux fonctionnalit\u00e9s de Knime. Continuons !<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n\r\n\r\n\r\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size\"><span style=\"font-family: 'Work Sans'; color: #ff5135;\"><span style=\"font-size: 27px;\">Inputs :<\/span><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Vous recevez ce fichier Excel afin de proc\u00e9der \u00e0 votre analyse.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Il comporte 36 feuilles regroupant les ventes du 01-2020 au 12-2022.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14778\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-1024x577.png\" alt=\"\" width=\"622\" height=\"350\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-1024x577.png 1024w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-300x169.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-768x433.png 768w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image.png 1114w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size wp-block-paragraph\">Comment proc\u00e9der ?<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Afin de combiner nos diff\u00e9rentes feuilles, <strong>4 \u00e9tapes<\/strong> sont n\u00e9cessaires :<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Fournir un fichier Excel contenant les feuilles\/onglets que nous voulons combiner.<\/li>\r\n<li>Convertir les noms des feuilles Excel en variables et cr\u00e9ation d&rsquo;une boucle.<\/li>\r\n<li>Lire la feuille correspondante \u00e0 la variable actuelle.<\/li>\r\n<li>Conserver les donn\u00e9es de la feuille qui vient d&rsquo;\u00eatre lue et passer \u00e0 la variable suivante.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14780\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-2.png\" alt=\"\" width=\"595\" height=\"193\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-2.png 737w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-2-300x97.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/>\r\n<figcaption>La boucle arrive \u00e0 sa fin lorsque toutes les variables ont \u00e9t\u00e9 parcourues.<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size wp-block-paragraph\">Pas \u00e0 pas :<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Maintenant que nous ayons incorpor\u00e9 la logique derri\u00e8re notre m\u00e9thode, il est temps de construire notre workflow :<\/p>\r\n\r\n\r\n\r\n<h2><span style=\"font-family: 'Work Sans'; color: #ff5135;\"><strong><span style=\"font-size: 22px;\">Etape 1 :<\/span> <\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Double-cliquez sur le n\u0153ud<em> Read Excel Sheet Names <\/em>pour renseigner l&#8217;emplacement et le fichier avec lequel nous travaillons. Ce n\u0153ud aura 2 colonnes en sortie : <em>Path <\/em>( emplacement de la feuille ) et <em>Sheet <\/em>( noms de la feuille ).<br \/>C&rsquo;est la colonne <em>Sheet <\/em>qui est importante car elle sera convertie en variable \u00e0 l&rsquo;\u00e9tape suivante.<\/p>\r\n\r\n\r\n\r\n<h2><span style=\"font-size: 22px; font-family: 'Work Sans'; color: #ff5135;\"><strong>Etape 2 :<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Configuration du n\u0153ud <em>Table row to va<\/em>riable loop start :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"765\" class=\"wp-image-14781\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-3.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-3.png 753w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-3-295x300.png 295w\" sizes=\"auto, (max-width: 753px) 100vw, 753px\" \/>\r\n<figcaption>La bo\u00eete verte est l&rsquo;endroit o\u00f9 vous mettez les colonnes que vous voulez convertir en variable.<br \/><br \/>Dans notre cas, nous voulons extraire les donn\u00e9es pour chaque nom de feuille dans le fichier. Nous avons donc besoin du nom de la feuille, ici <em>Sheet,<\/em> d&rsquo;\u00eatre dans la boite verte pour \u00eatre la variable qui conduit la boucle. Maintenant que nous sommes configur\u00e9s, nous pouvons ex\u00e9cuter ce n\u0153ud.<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<h2><span style=\"font-size: 22px; font-family: 'Work Sans'; color: #ff5135;\"><strong>Etape 3 :<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\" data-path-to-node=\"0\">Maintenant, nous allons configurer le n\u0153ud <em>Excel Reader.<\/em><\/p>\r\n<p data-path-to-node=\"1\">Nous fournissons tout d&rsquo;abord le fichier dont nous voulons extraire les donn\u00e9es. Ensuite, nous renseignons la variable qui contient les noms des feuilles \u00e0 combiner. Pour ce faire, nous cliquons sur l&rsquo;onglet<em> Flow Variables.<\/em><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Cliquez sur Settings puis s\u00e9lectionnez <em>sheet <\/em>dans <em>sheet_name <\/em>comme ci-dessous :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14783\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-4.png\" alt=\"\" width=\"564\" height=\"649\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-4.png 619w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-4-261x300.png 261w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/>\r\n<figcaption>Ici, l&rsquo;option de nom de feuille du n\u0153ud est d\u00e9finie sur la variable que nous avons cr\u00e9\u00e9 \u00e0 l&rsquo;\u00e9tape pr\u00e9c\u00e9dente !<br \/>Nous r\u00e9cup\u00e9rons les donn\u00e9es du fichier X pour la feuille qui est actuellement d\u00e9finie dans la boucle.<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<h2><span style=\"font-size: 22px; font-family: 'Work Sans'; color: #ff5135;\"><strong>Etape 4 :<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Derni\u00e8re, et plus simple \u00e9tape, il s&rsquo;agit ici de configurer le n\u0153ud<em> Loop End<\/em> selon vos pr\u00e9f\u00e9rences.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"417\" class=\"wp-image-14784\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-5.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-5.png 482w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-5-300x260.png 300w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/>\r\n<figcaption>Pour ma part, je souhaite avoir de nouveaux num\u00e9ros de ligne et je n&rsquo;ai pas besoin de la colonne it\u00e9ration.<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size\"><span style=\"font-size: 27px; font-family: 'Work Sans'; color: #ff5135;\">R\u00e9sultat :<\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Maintenant que tous nos n\u0153uds sont configur\u00e9s, nous pouvons ex\u00e9cuter notre workflow.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Une fois la boucle finie, la table finale devrait \u00eatre semblable \u00e0 celle-ci:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"302\" class=\"wp-image-14785\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-6.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-6.png 588w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/image-6-300x154.png 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/>\r\n<figcaption>Comme vous pouvez le voir, nous avons r\u00e9ussi \u00e0 combiner toutes les donn\u00e9es des diff\u00e9rentes feuilles de notre fichier Excel !<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-medium-font-size\"><span style=\"font-size: 27px; font-family: 'Work Sans'; color: #ff5135;\">Conclusion :<\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">La transformation du nom des feuilles en variable et la cr\u00e9ation d&rsquo;une boucle sont la solution lorsque vous vous retrouvez \u00e0 travailler avec des donn\u00e9es de la sorte, votre temps est trop pr\u00e9cieux pour le passer sur des t\u00e2ches r\u00e9p\u00e9titives et fastidieuses lorsque les fonctionnalit\u00e9s pr\u00e9sentes sur Knime nous permettent de les automatiser!<\/p>\r\n\r\n\r\n<div class=\"\"><div class='_form_193'><\/div><script type='text\/javascript' src='https:\/\/analyticslm.activehosted.com\/f\/embed.php?static=0&id=193&6B00D297099F1&nostyles=0&preview=0'><\/script><\/div>","protected":false},"excerpt":{"rendered":"Aujourd&rsquo;hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.","protected":false},"author":172,"featured_media":14865,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"pad_hide_post_author":"","_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[79],"tags":[566,89],"class_list":["post-14777","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guide","tag-how-to","tag-knime"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER<\/title>\n<meta name=\"description\" content=\"Aujourd&#039;hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mydral.com\/en\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER\" \/>\n<meta property=\"og:description\" content=\"Aujourd&#039;hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/\" \/>\n<meta property=\"og:site_name\" content=\"MYDRAL - DATA IS POWER\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/mydral\/?fref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-05T12:37:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-20T13:41:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"813\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yousri Baccari\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MYDRAL_COM\" \/>\n<meta name=\"twitter:site\" content=\"@MYDRAL_COM\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yousri Baccari\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/\"},\"author\":{\"name\":\"Yousri Baccari\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/e6dad5b2b64f498940d2a6088d05da58\"},\"headline\":\"Combiner plusieurs feuilles Excel sur Knime\",\"datePublished\":\"2022-05-05T12:37:38+00:00\",\"dateModified\":\"2026-08-20T13:41:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/\"},\"wordCount\":656,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Update-banniere-combiner-feuilles-excel.png\",\"keywords\":[\"How to\",\"Knime\"],\"articleSection\":[\"Guide\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/\",\"name\":\"Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Update-banniere-combiner-feuilles-excel.png\",\"datePublished\":\"2022-05-05T12:37:38+00:00\",\"dateModified\":\"2026-08-20T13:41:25+00:00\",\"description\":\"Aujourd'hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Update-banniere-combiner-feuilles-excel.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Update-banniere-combiner-feuilles-excel.png\",\"width\":813,\"height\":538,\"caption\":\"combiner feuilles excel sur KNIM\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.mydral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combiner plusieurs feuilles Excel sur Knime\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"name\":\"MYDRAL - DATA IS POWER\",\"description\":\"DATA IS POWER\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mydral.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\",\"name\":\"Mydral\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"width\":1718,\"height\":1394,\"caption\":\"Mydral\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mydral\\\/?fref=ts\",\"https:\\\/\\\/x.com\\\/MYDRAL_COM\",\"https:\\\/\\\/www.instagram.com\\\/mydral_com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/10898136\\\/admin\\\/\",\"https:\\\/\\\/www.pinterest.fr\\\/mydral_com\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCpJqoSrQX5b0PRf0H6VRhdg\\\/videos?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/e6dad5b2b64f498940d2a6088d05da58\",\"name\":\"Yousri Baccari\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g\",\"caption\":\"Yousri Baccari\"},\"url\":\"https:\\\/\\\/www.mydral.com\\\/en\\\/author\\\/yousri\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER","description":"Aujourd'hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mydral.com\/en\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/","og_locale":"en_GB","og_type":"article","og_title":"Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER","og_description":"Aujourd'hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.","og_url":"https:\/\/www.mydral.com\/en\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2022-05-05T12:37:38+00:00","article_modified_time":"2026-08-20T13:41:25+00:00","og_image":[{"width":813,"height":538,"url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","type":"image\/png"}],"author":"Yousri Baccari","twitter_card":"summary_large_image","twitter_creator":"@MYDRAL_COM","twitter_site":"@MYDRAL_COM","twitter_misc":{"Written by":"Yousri Baccari","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/"},"author":{"name":"Yousri Baccari","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/e6dad5b2b64f498940d2a6088d05da58"},"headline":"Combiner plusieurs feuilles Excel sur Knime","datePublished":"2022-05-05T12:37:38+00:00","dateModified":"2026-08-20T13:41:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/"},"wordCount":656,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"image":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","keywords":["How to","Knime"],"articleSection":["Guide"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/","url":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/","name":"Combiner plusieurs feuilles Excel sur Knime - MYDRAL - DATA IS POWER","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#primaryimage"},"image":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","datePublished":"2022-05-05T12:37:38+00:00","dateModified":"2026-08-20T13:41:25+00:00","description":"Aujourd'hui, nous allons aborder un sc\u00e9nario sur KNIME afin de combiner, gr\u00e2ce aux fonctionnalit\u00e9s du logiciel, nos 36 feuilles en une seule.","breadcrumb":{"@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#primaryimage","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","width":813,"height":538,"caption":"combiner feuilles excel sur KNIM"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/how-tocombiner-plusieurs-feuilles-excel-sur-knime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.mydral.com\/"},{"@type":"ListItem","position":2,"name":"Combiner plusieurs feuilles Excel sur Knime"}]},{"@type":"WebSite","@id":"https:\/\/www.mydral.com\/#website","url":"https:\/\/www.mydral.com\/","name":"MYDRAL - DATA IS POWER","description":"DATA IS POWER","publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mydral.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.mydral.com\/#organization","name":"Mydral","url":"https:\/\/www.mydral.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","width":1718,"height":1394,"caption":"Mydral"},"image":{"@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/mydral\/?fref=ts","https:\/\/x.com\/MYDRAL_COM","https:\/\/www.instagram.com\/mydral_com\/","https:\/\/www.linkedin.com\/company\/10898136\/admin\/","https:\/\/www.pinterest.fr\/mydral_com\/","https:\/\/www.youtube.com\/channel\/UCpJqoSrQX5b0PRf0H6VRhdg\/videos?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/e6dad5b2b64f498940d2a6088d05da58","name":"Yousri Baccari","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7e33f462fec223ffba51a844391e08f96df163628db52e369a386eacd4c5f00?s=96&d=retro&r=g","caption":"Yousri Baccari"},"url":"https:\/\/www.mydral.com\/en\/author\/yousri\/"}]}},"views":2403,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/05\/Update-banniere-combiner-feuilles-excel.png","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/users\/172"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/comments?post=14777"}],"version-history":[{"count":5,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14777\/revisions"}],"predecessor-version":[{"id":33472,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14777\/revisions\/33472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media\/14865"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=14777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=14777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=14777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}