{"id":6202,"date":"2020-07-30T08:55:41","date_gmt":"2020-07-30T06:55:41","guid":{"rendered":"https:\/\/www.mydral.com\/?p=6202"},"modified":"2026-08-24T16:49:39","modified_gmt":"2026-08-24T14:49:39","slug":"les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/","title":{"rendered":"Les 3 Minutes Analytics : Comment exporter vos donn\u00e9es vers un fichier Excel dans KNIME"},"content":{"rendered":"<p>Bravo ! Vous \u00eates sur le point de devenir un <strong>KNIME Rookie<\/strong> \u00e0 l&rsquo;issue de ce tutoriel mais patience encore quelques \u00e9tapes et quelques clics avec un article d\u00e9di\u00e9 \u00e0 l&rsquo;export en XLS avec KNIME.<\/p>\n<p>Pour rappel, vous suivez le parcours 2 de notre s\u00e9rie de modules<strong> Les 3 Minutes Analytic<\/strong>s. Les diff\u00e9rents modules du<strong> parcours 1<\/strong> vous ont permis de devenir un KNIME beginner<em>\u00a0<\/em>avec les fonctionnalit\u00e9s de base. Place au <strong>parcours 2<\/strong> pour devenir un KNIME Rookie pour aller plus loin dans l\u2019analyse de vos donn\u00e9es ! Next stop : KNIME Jedi, et c&rsquo;est l\u00e0 que les choses deviennent s\u00e9rieuses.<\/p>\n<p>Nous l\u2019avons vu les fonctionnalit\u00e9s dans KNIME sont nombreuses. Nous vous proposons aujourd\u2019hui de d\u00e9couvrir comment exporter vos donn\u00e9es vers un fichier Excel.<\/p>\n<p><img decoding=\"async\" class=\"emoji\" role=\"img\" draggable=\"false\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/12.0.0-1\/svg\/1f39e.svg\" alt=\"&#x1f39e;\" \/> <strong>Mydral vous propose \u00e9galement de d\u00e9couvrir en vid\u00e9o ce tutoriel export XLS dans KNIME :<\/strong><\/p>\n<div class=\"embed-responsive embed-responsive-16by9\"><iframe loading=\"lazy\" title=\"KN020 - Export en XLS\" src=\"https:\/\/player.vimeo.com\/video\/442755074?h=b773b00334&amp;dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<div id=\"model-response-message-contentr_84d4ab5c23dc202f\" class=\"markdown markdown-main-panel md-content enable-luminous-fast-follows enable-updated-hr-color\" dir=\"ltr\" aria-busy=\"false\" aria-live=\"polite\">\n<div><span style=\"font-family: 'Work Sans';\">Ce tutoriel vous explique comment exporter vos donn\u00e9es vers un fichier Excel gr\u00e2ce au n\u0153ud <b data-path-to-node=\"0\" data-index-in-node=\"91\">Excel Writer (XLS)<\/b> dans KNIME.<\/span><\/div>\n<\/div>\n<p>Dans cet exemple, j\u2019utilise un fichier CSV qui concerne les commandes de l\u2019entreprise Sport Up, et qui a d\u00e9j\u00e0 subi une op\u00e9ration d\u2019agr\u00e9gation avec le node <strong>Group By : <\/strong>d\u00e9j\u00e0 vu dans ce parcours \ud83d\ude09<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6204 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/001.png\" alt=\"Export en XLS KNIME\" width=\"726\" height=\"496\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/001.png 726w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/001-300x205.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>L\u2019objectif c\u2019est de pouvoir r\u00e9cup\u00e9rer ces donn\u00e9es agr\u00e9g\u00e9es dans un fichier Excel.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6215 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/011.png\" alt=\"Export en XLS KNIME\" width=\"345\" height=\"199\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/011.png 345w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/011-300x173.png 300w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Pour ce faire, j\u2019utilise le node <strong>Excel Writer (XLS)<\/strong>, que vous pouvez trouver dans la fen\u00eatre <strong>Node Repository\u00a0<\/strong>; qui est le r\u00e9pertoire de nodes KNIME.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6206 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/002.png\" alt=\"Export en XLS KNIME\" width=\"569\" height=\"191\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/002.png 569w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/002-300x101.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Une fois le node s\u00e9lectionn\u00e9, glissez-le dans la zone de travail et reliez-le avec le reste du workflow.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6207 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/003.png\" alt=\"Export en XLS KNIME\" width=\"735\" height=\"501\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/003.png 735w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/003-300x204.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Un clic droit sur le node puis sur configurer nous permet de commencer la configuration \u00e0 l\u2019aide de la bo\u00eete de dialogue qui appara\u00eet.<\/p>\n<h2><span style=\"color: #ff6600;\">Propri\u00e9t\u00e9s de configuration<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>Vous devez savoir que ce node supporte deux formats de fichier Excel:<\/p>\n<ul>\n<li><strong>Format .xls : <\/strong>Excel utilise ce format par d\u00e9faut jusqu&rsquo;\u00e0 la version 2003. Une feuille de calcul de ce format contient au maximum 256 colonnes (l&rsquo;outil tronque toutes les colonnes suppl\u00e9mentaires du tableau de donn\u00e9es). Si le tableau des donn\u00e9es d&rsquo;entr\u00e9e comporte plus de 65 536 lignes, le syst\u00e8me le divise en plusieurs feuilles de calcul (le classeur cr\u00e9\u00e9 stocke alors l&rsquo;ensemble de ces feuilles).<\/li>\n<li><strong>Format .xlsx :<\/strong> C\u2019est le format de fichier utilis\u00e9 par d\u00e9faut \u00e0 partir d&rsquo;Excel 2007.<\/li>\n<\/ul>\n<p>Cependant, \u00e0 l\u2019heure de l\u2019\u00e9criture de ce tutoriel, le format \u00ab\u00a0xlsm\u00a0\u00bb n\u2019est pas pris en charge par ce node. Cela \u00e9tant dit, on peut commencer \u00e0 configurer notre node.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\"><strong>Output location\u00a0<\/strong><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>La premi\u00e8re chose \u00e0 faire est de sp\u00e9cifier l\u2019endroit o\u00f9 vous voulez publier vos donn\u00e9es ainsi que le chemin vers celui-ci.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6208 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/004.png\" alt=\"Export XLS KNIME\" width=\"738\" height=\"184\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/004.png 738w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/004-300x75.png 300w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\"><em>Write to\u00a0:<\/em><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>Il existe trois options de syst\u00e8me de fichiers par d\u00e9faut parmi lesquelles vous pouvez choisir :<\/p>\n<ul>\n<li>Syst\u00e8me de fichiers local : Vous permet de s\u00e9lectionner un fichier\/dossier de votre syst\u00e8me local.<\/li>\n<li>Mountpoint : Vous permet de choisir un point de montage. Une fois s\u00e9lectionn\u00e9, un nouveau menu d\u00e9roulant appara\u00eet pour choisir le point de montage.<\/li>\n<li>URL personnalis\u00e9e : Permet de sp\u00e9cifier une URL (par exemple, file:\/\/, http:\/\/ ou le protocole knime:\/\/).<\/li>\n<\/ul>\n<p>Dans mon cas, j\u2019ai choisi de faire l\u2019export sur mon syst\u00e8me de fichiers local.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\"><em>File or URL\u00a0:<\/em><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>J\u2019ai choisi comme nom du fichier \u00ab mon_export.xlsx \u00bb et je l\u2019ai mis dans mon dossier DOCUMENTS. En fonction de ce que vous avez choisi d\u2019entrer dans la premi\u00e8re option, entrez une URL lorsque vous \u00e9crivez dans le syst\u00e8me de fichiers Custom URL. Dans le cas contraire,\u00a0 entrez un chemin d&rsquo;acc\u00e8s \u00e0 un fichier. La syntaxe requise d&rsquo;un chemin d\u00e9pend du syst\u00e8me de fichiers choisi, comme \u00ab\u00a0C:\\path\\to\\file\u00a0\u00bb (Syst\u00e8me de fichiers local sur Windows) ou \u00ab\u00a0\/path\/to\/file\u00a0\u00bb (Syst\u00e8me de fichiers local sur Linux\/MacOS et Mountpoint). Notez que pour les syst\u00e8mes de fichiers connect\u00e9s par le port d&rsquo;entr\u00e9e, la description du n\u0153ud de connexion respectif d\u00e9crit le format de chemin d&rsquo;acc\u00e8s requis. Vous pouvez \u00e9galement choisir un fichier pr\u00e9c\u00e9demment s\u00e9lectionn\u00e9 dans la liste d\u00e9roulante, ou s\u00e9lectionner une destination dans la bo\u00eete de dialogue \u00ab\u00a0Parcourir&#8230;\u00a0\u00bb (Cependant, la navigation n&rsquo;est pas disponible pour le syst\u00e8me de fichiers Custom URL).<\/p>\n<h3><\/h3>\n<h3><span style=\"color: #ff6600;\"><em>Overwrite existing file\u00a0:<\/em><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>Les fichiers existants seront \u00e9cras\u00e9s si cette option est activ\u00e9e. En effet, le node \u00e9chouera pendant l&rsquo;ex\u00e9cution pour conserver le fichier original et \u00e9viter un \u00e9crasement involontaire. Les emplacements distants seront toujours \u00e9cras\u00e9s.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\"><em>Open file after execution\u00a0:<\/em><\/span><\/h3>\n<p>Ouvre le fichier apr\u00e8s sa cr\u00e9ation. Le fichier sera ouvert dans l&rsquo;application par d\u00e9faut du syst\u00e8me. Il se peut que tous les syst\u00e8mes ne prennent pas en charge cette fonction, qui n&rsquo;est pas disponible pour les sites distants.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\"><em>Sheet name\u00a0:<\/em><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6217 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/012.png\" alt=\"Export en XLS KNIME\" width=\"721\" height=\"59\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/012.png 721w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/012-300x25.png 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/p>\n<p>Nom de la fiche qui sera cr\u00e9\u00e9e. Si elle est laiss\u00e9e vide, le nom de la table de saisie sera utilis\u00e9.<\/p>\n<h3><\/h3>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\">Add names and Ids\u00a0:<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6210 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/006.png\" alt=\"Export XLS KNIME\" width=\"720\" height=\"65\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/006.png 720w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/006-300x27.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/p>\n<h3><\/h3>\n<h3><span style=\"color: #ff6600;\"><em>Add column headers\u00a0:<\/em><\/span><\/h3>\n<div id=\"model-response-message-contentr_35f06d98039e1f84\" class=\"markdown markdown-main-panel md-content enable-luminous-fast-follows enable-updated-hr-color\" dir=\"ltr\" aria-busy=\"false\" aria-live=\"polite\">\n<div><span style=\"font-family: 'Work Sans';\">Si vous cochez cette case, l&rsquo;outil inscrit les noms des colonnes dans la premi\u00e8re ligne de la feuille de calcul.<\/span><\/div>\n<\/div>\n<h3><\/h3>\n<h3><span style=\"color: #ff6600;\"><em>Add row ids\u00a0:<\/em><\/span><\/h3>\n<div id=\"model-response-message-contentr_2f3512863678956e\" class=\"markdown markdown-main-panel md-content enable-luminous-fast-follows enable-updated-hr-color\" dir=\"ltr\" aria-busy=\"false\" aria-live=\"polite\">\n<div><span style=\"font-family: 'Work Sans';\">Si vous cochez cette case, l&rsquo;outil ajoute les ID de ligne \u00e0 la sortie, dans la premi\u00e8re colonne du tableur.<\/span><\/div>\n<\/div>\n<h3><\/h3>\n<h3><span style=\"color: #ff6600;\">Missing value pattern\u00a0:<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6211 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/007.png\" alt=\"Excel KNIME\" width=\"724\" height=\"50\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/007.png 724w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/007-300x21.png 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/p>\n<div id=\"model-response-message-contentr_d7f1ae7145957d22\" class=\"markdown markdown-main-panel md-content enable-luminous-fast-follows enable-updated-hr-color\" dir=\"ltr\" aria-busy=\"false\" aria-live=\"polite\">\n<div><span style=\"font-family: 'Work Sans';\">Saisissez un mod\u00e8le que l&rsquo;outil appliquera aux valeurs de donn\u00e9es manquantes. Si vous ne le sp\u00e9cifiez pas, l&rsquo;application laissera vide la cellule correspondante du tableur.<\/span><\/div>\n<\/div>\n<h3><span style=\"color: #ff6600;\">Layout\u00a0:<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6212 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/008.png\" alt=\"Export en XLS KNIME\" width=\"720\" height=\"89\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/008.png 720w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/008-300x37.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><em>Autosize columns<\/em><strong>\u00a0: <\/strong>Adapte la largeur de chaque colonne \u00e0 son contenu.<\/li>\n<li><em>Portrait\/Landscape\u00a0:<\/em> D\u00e9finit le format d&rsquo;impression en portrait ou en paysage.<\/li>\n<li><em>Paper size\u00a0<\/em>: R\u00e8gle la taille du papier dans la configuration d&rsquo;impression.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff6600;\">Exclude\/Include columns\u00a0:<\/span><\/h3>\n<p>Ici vous s\u00e9lectionnez les colonnes que vous voulez \u00e9ventuellement inclure ou exclure du fichier. J\u2019ai choisi de tout inclure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6213 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/009.png\" alt=\"Export en XLS KNIME\" width=\"729\" height=\"279\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/009.png 729w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/009-300x115.png 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Maintenant que nous avons configurer notre node, nous pouvons cliquer sur OK puis l\u2019ex\u00e9cuter. Nous pouvons v\u00e9rifier que le fichier \u00ab\u00a0mon_export.xls\u00a0\u00bb a bel et bien \u00e9t\u00e9 cr\u00e9er dans l\u2019endroit sp\u00e9cifi\u00e9.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6216 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/013.png\" alt=\"Excel KNIME\" width=\"1440\" height=\"761\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/013.png 1440w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/013-300x159.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/013-1024x541.png 1024w, https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/013-768x406.png 768w\" sizes=\"auto, (max-width: 1440px) 100vw, 1440px\" \/><\/p>\n<p>Vous savez maintenant comment effectuer un Export XLS de vos donn\u00e9es dans KNIME.<\/p>\n<p>Mon article s\u2019ach\u00e8ve ici ! \u00c7a vous a plus ? Pour suivre nos autres modules et d\u00e9buter votre parcours <strong>KNIME Beginner,<\/strong> RDV dans notre rubrique<span style=\"color: #ff6600;\"> <a style=\"color: #ff6600;\" href=\"https:\/\/www.mydral.com\/en\/category\/les-3-minutes-analytics\/\">Les 3 Minutes Analytiques.<\/a><\/span><\/p>\n<p>Et bonne nouvelle, vous avez termin\u00e9 votre parcours<strong> KNIME Rookie<\/strong>. Vous avez acquis toutes les comp\u00e9tences de ce parcours pour d\u00e9buter votre parcours<span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.mydral.com\/en\/category\/les-3-minutes-analytics\/\"> KNIME Jedi<\/a> <\/span>avant KNIME Expert !<\/p>\n<p>Votre parcours nous int\u00e9resse ! Parlez-nous de votre retour d\u2019exp\u00e9rience en commentaires !<\/p>\n<p>Suivez-nous sur les r\u00e9seaux sociaux :<span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.linkedin.com\/company\/mydral\/\"> LinkedIn<\/a><\/span> &amp; <span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/twitter.com\/MYDRAL_COM\">Twitter<\/a> <\/span>!<\/p>","protected":false},"excerpt":{"rendered":"Exporter vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.","protected":false},"author":123,"featured_media":7331,"comment_status":"open","ping_status":"open","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":[1],"tags":[353,89],"class_list":["post-6202","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-la-minute-analytics","tag-excel","tag-knime"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Les 3 Minutes Analytics : effectuer un export XLS dans KNIME<\/title>\n<meta name=\"description\" content=\"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.\" \/>\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\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les 3 Minutes Analytics : effectuer un export XLS dans KNIME\" \/>\n<meta property=\"og:description\" content=\"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-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=\"2020-07-30T06:55:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-24T14:49:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1279\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mouad QARCHLI\" \/>\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=\"Mouad QARCHLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/\"},\"author\":{\"name\":\"Mouad QARCHLI\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/7213b892aa0796b530b5d0fafd4048ca\"},\"headline\":\"Les 3 Minutes Analytics : Comment exporter vos donn\u00e9es vers un fichier Excel dans KNIME\",\"datePublished\":\"2020-07-30T06:55:41+00:00\",\"dateModified\":\"2026-08-24T14:49:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/\"},\"wordCount\":1177,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN020.png\",\"keywords\":[\"Excel\",\"Knime\"],\"articleSection\":[\"La minute Analytics\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/\",\"name\":\"Les 3 Minutes Analytics : effectuer un export XLS dans KNIME\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN020.png\",\"datePublished\":\"2020-07-30T06:55:41+00:00\",\"dateModified\":\"2026-08-24T14:49:39+00:00\",\"description\":\"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN020.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN020.png\",\"width\":1279,\"height\":720,\"caption\":\"#KN020 Export XLS KNIME\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.mydral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les 3 Minutes Analytics : Comment exporter vos donn\u00e9es vers un fichier Excel dans 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\\\/7213b892aa0796b530b5d0fafd4048ca\",\"name\":\"Mouad QARCHLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g\",\"caption\":\"Mouad QARCHLI\"},\"url\":\"https:\\\/\\\/www.mydral.com\\\/en\\\/author\\\/mouad-qarchli\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les 3 Minutes Analytics : effectuer un export XLS dans KNIME","description":"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.","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\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/","og_locale":"en_GB","og_type":"article","og_title":"Les 3 Minutes Analytics : effectuer un export XLS dans KNIME","og_description":"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.","og_url":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2020-07-30T06:55:41+00:00","article_modified_time":"2026-08-24T14:49:39+00:00","og_image":[{"width":1279,"height":720,"url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","type":"image\/png"}],"author":"Mouad QARCHLI","twitter_card":"summary_large_image","twitter_creator":"@MYDRAL_COM","twitter_site":"@MYDRAL_COM","twitter_misc":{"Written by":"Mouad QARCHLI","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/"},"author":{"name":"Mouad QARCHLI","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/7213b892aa0796b530b5d0fafd4048ca"},"headline":"Les 3 Minutes Analytics : Comment exporter vos donn\u00e9es vers un fichier Excel dans KNIME","datePublished":"2020-07-30T06:55:41+00:00","dateModified":"2026-08-24T14:49:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/"},"wordCount":1177,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","keywords":["Excel","Knime"],"articleSection":["La minute Analytics"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/","url":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/","name":"Les 3 Minutes Analytics : effectuer un export XLS dans KNIME","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#primaryimage"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","datePublished":"2020-07-30T06:55:41+00:00","dateModified":"2026-08-24T14:49:39+00:00","description":"Comment faire un export de vos donn\u00e9es dans un fichier XLS dans KNIME ? Rien de plus simple ! Suivez ce tutoriel \u00e9tape par \u00e9tape en quelques clics.","breadcrumb":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#primaryimage","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","width":1279,"height":720,"caption":"#KN020 Export XLS KNIME"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-exporter-vos-donnees-vers-un-fichier-excel-dans-knime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.mydral.com\/"},{"@type":"ListItem","position":2,"name":"Les 3 Minutes Analytics : Comment exporter vos donn\u00e9es vers un fichier Excel dans 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\/7213b892aa0796b530b5d0fafd4048ca","name":"Mouad QARCHLI","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e905e422d89bead6ce885448d02bf12d3acbe5dec397c6c3fd31daf3fa1a66f?s=96&d=retro&r=g","caption":"Mouad QARCHLI"},"url":"https:\/\/www.mydral.com\/en\/author\/mouad-qarchli\/"}]}},"views":1926,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN020.png","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6202","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\/123"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/comments?post=6202"}],"version-history":[{"count":7,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6202\/revisions"}],"predecessor-version":[{"id":33679,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6202\/revisions\/33679"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media\/7331"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=6202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=6202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=6202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}