{"id":335,"date":"2020-05-11T10:24:43","date_gmt":"2020-05-11T10:24:43","guid":{"rendered":"http:\/\/support.unit4venice.be\/fr\/?p=335"},"modified":"2021-11-29T12:35:52","modified_gmt":"2021-11-29T10:35:52","slug":"exporter-une-liste-vers-excel","status":"publish","type":"post","link":"https:\/\/support.venice.be\/fr\/index.php\/exporter-une-liste-vers-excel\/","title":{"rendered":"Exporter une liste vers Excel"},"content":{"rendered":"\n<p>Dans presque tous les modules de Venice, il est possible de faire un export vers Excel.  Si vous ouvrez par exemple le module Clients&nbsp; et vous choisissez <em>Adapter<\/em> &#8211; <em>Exporter &#8211; Feuille de calcul externe<\/em>, &nbsp;vous pouvez faire un export vers une feuille de calcul comme Excel par exemple.  Eventuellement vous pouvez d&rsquo;abord ajouter des colonnes via les options <em>Adapter<\/em>&#8211; <em>Colonnes<\/em> &#8211; <em>G\u00e9rer<\/em>.<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"198\" class=\"wp-image-337\" style=\"width: 300px;\" alt=\"\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export.png\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export.png 446w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export-300x198.png 300w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n\n\n\n<p>Ceci est aussi possible par exemple dans C<em>onsultation &#8211; Comptabilit\u00e9 &#8211; Ecritures<\/em> pour&nbsp;obtenir un export de vos \u00e9critures&nbsp;comptables en d\u00e9tail<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"76\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/exportBH-300x76.png\" alt=\"exportBH\" class=\"wp-image-336\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/exportBH-300x76.png 300w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/exportBH.png 752w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Une autre mani\u00e8re d&rsquo;exporter des donn\u00e9es dans un fichier de texte et de passer par une impression&nbsp; \u00e0 l&rsquo;aide d&rsquo;une liste existante. Il est important de savoir que pas toutes les listes donnent un beau r\u00e9sultat en Excel si par exemple il y des totalisations dans la liste.&nbsp; Dans ce cas, une adaptation de la liste s&rsquo;imposera de sorte&nbsp;que les&nbsp;\u00e9l\u00e9ments superflus ne soient pas imprim\u00e9s.<\/p>\n\n\n\n<p> <img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"149\" class=\"wp-image-343\" style=\"width: 500px;\" alt=\"\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export1.png\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export1.png 682w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export1-300x89.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n\n\n\n<p>Ouvrez la liste que vous voulez exporter et appuyez sur <em>Imprimer<\/em> &#8211; <em>Imprimer vers fichier<\/em>.  <\/p>\n\n\n\n<p>Via le bouton <em>Rechercher<\/em> vous pouvez s\u00e9lectionner le chemin d&rsquo;acc\u00e8s o\u00f9 le fichier doit \u00eatre cr\u00e9\u00e9 ainsi que le type de fichier. Choisissez .txt.<\/p>\n\n\n\n<p>Via le bouton <em>Options<\/em> vous d\u00e9terminez quel devra \u00eatre le signe d\u00e9cimal, le s\u00e9parateur des milliers, etc.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"271\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export2-300x271.png\" alt=\"\" class=\"wp-image-342\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export2-300x271.png 300w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export2.png 560w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Il suffit d&rsquo;imprimer la liste vers un fichier et d&rsquo;ouvrir le&nbsp;txt (dans notre exemple) avec Excel ou un autre programme de calcul<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"179\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export3-300x179.png\" alt=\"\" class=\"wp-image-341\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export3-300x179.png 300w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export3.png 585w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Choisissez dans Excel Data &#8211; convert text to colums<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"261\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export4-300x261.png\" alt=\"\" class=\"wp-image-340\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export4-300x261.png 300w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export4.png 402w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Cliquez sur delimited et  <strong>;<\/strong> ou semicolon (si vous avez choisi ; dans les options dans Venice) afin de finir l&rsquo;export vers Excel<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"86\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export5-300x86.png\" alt=\"\" class=\"wp-image-339\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export5-300x86.png 300w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export5.png 521w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export6-150x150.png\" alt=\"\" class=\"wp-image-338\" srcset=\"https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export6-150x150.png 150w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export6-50x50.png 50w, https:\/\/support.venice.be\/fr\/wp-content\/uploads\/2020\/05\/export6-110x110.png 110w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans presque tous les modules de Venice, il est possible de faire un export vers Excel. Si vous ouvrez par exemple le module Clients&nbsp; et vous choisissez Adapter &#8211; Exporter &#8211; Feuille de calcul externe, &nbsp;vous pouvez faire un export &hellip; <a href=\"https:\/\/support.venice.be\/fr\/index.php\/exporter-une-liste-vers-excel\/\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[16,12,13,38],"tags":[65,69],"acf":[],"_links":{"self":[{"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/posts\/335"}],"collection":[{"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":9,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions\/503"}],"wp:attachment":[{"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.venice.be\/fr\/index.php\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}