{"id":12036,"date":"2024-01-29T06:37:17","date_gmt":"2024-01-29T05:37:17","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12036"},"modified":"2023-11-18T18:45:09","modified_gmt":"2023-11-18T17:45:09","slug":"excel-recuperer-un-tableau-de-donnees-a-partir-dune-photo-ou-dun-document-scanne","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12036","title":{"rendered":"Excel : R\u00e9cup\u00e9rer un tableau de donn\u00e9es \u00e0 partir d\u2019une photo ou d&#8217;un document scann\u00e9"},"content":{"rendered":"<p style=\"text-align: justify;\">Vous avez <strong>photographi\u00e9 un tableau de donn\u00e9es<\/strong> dans un magazine ? Vous avez r\u00e9cup\u00e9r\u00e9 un <strong>tableau de donn\u00e9es dans une image<\/strong> (jpeg, png&#8230;) ? Et vous souhaitez transf\u00e9rer ces donn\u00e9es dans un tableau Excel sans les saisir manuellement ?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12042\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-avec-OCR.jpg\" alt=\"Lecture-donnees-photo-Excel avec OCR\" width=\"930\" height=\"573\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-avec-OCR.jpg 930w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-avec-OCR-300x185.jpg 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-avec-OCR-768x473.jpg 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-avec-OCR-730x450.jpg 730w\" sizes=\"auto, (max-width: 930px) 100vw, 930px\" \/><\/p>\n<p style=\"text-align: justify;\">La conversion du support photographique vers des donn\u00e9es texte s\u2019appuie sur un syst\u00e8me de <strong>reconnaissance de caract\u00e8res (OCR)<\/strong>. La qualit\u00e9 de la reconnaissance de caract\u00e8res d\u00e9pend pour beaucoup de la qualit\u00e9 de la prise de vue (ou du scan).<\/p>\n<p style=\"text-align: justify;\">La d\u00e9marche d\u2019importation des donn\u00e9es est tr\u00e8s simple et est totalement prise en charge par&nbsp;Excel.<\/p>\n<p style=\"text-align: justify;\">Ouvrir Excel, un nouveau classeur puis se rendre dans le <strong>menu Donn\u00e9es<\/strong> \/ A partir d&#8217;autres sources \/ A partir de l&#8217;image :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12037\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Excel-Donnees-Image.png\" alt=\"Excel Donn\u00e9es Image\" width=\"773\" height=\"826\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Excel-Donnees-Image.png 773w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Excel-Donnees-Image-281x300.png 281w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Excel-Donnees-Image-768x821.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Excel-Donnees-Image-730x780.png 730w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/p>\n<p style=\"text-align: justify;\">Puis :<\/p>\n<ul>\n<li>Image \u00e0 partir d&#8217;un fichier&#8230; : s\u00e9lectionner le fichier puis Ins\u00e9rer ;<\/li>\n<li>Image \u00e0 partir du Presse-papiers (copie une image dans le presse-papiers au pr\u00e9alable).<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">L&#8217;exemple ci-apr\u00e8s s&#8217;appuie sur l&#8217;image suivante (<a href=\"https:\/\/www.auditsi.eu\/?page_id=2119\">prix de diff\u00e9rents mat\u00e9riels dans les ann\u00e9es 80<\/a>) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12046\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel.jpg\" alt=\"Lecture-donnees-photo-Excel\" width=\"721\" height=\"402\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel.jpg 721w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Lecture-donnees-photo-Excel-300x167.jpg 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/p>\n<p style=\"text-align: justify;\">Excel proc\u00e8de \u00e0 la <strong>reconnaissance de caract\u00e8res<\/strong> :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12038\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage.png\" alt=\"Donn\u00e9es de l'image\" width=\"333\" height=\"707\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage.png 333w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage-141x300.png 141w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\" \/><\/p>\n<p style=\"text-align: justify;\">La phase de reconnaissance termin\u00e9e, Excel affiche une <strong>pr\u00e9visualisation du r\u00e9sultat<\/strong> :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12039\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage-2.png\" alt=\"Donn\u00e9es de l'image 2\" width=\"339\" height=\"787\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage-2.png 339w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-de-limage-2-129x300.png 129w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/p>\n<p style=\"text-align: justify;\">Cliquer sur <strong>Examiner pour passer en revue<\/strong>, au besoin, l&#8217;image et <strong>la retranscription texte des donn\u00e9es<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Enfin cliquer sur <strong>Ins\u00e9rer des donn\u00e9es<\/strong> pour importer les donn\u00e9es dans le classeur Excel. Si Excel n&#8217;est pas s\u00fbr des donn\u00e9es reconnues par l&#8217;OCR, il propose \u00e0 l&#8217;utilisateur de les examiner au pr\u00e9alable :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12040\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-revision-image.png\" alt=\"Donn\u00e9es r\u00e9vision image\" width=\"320\" height=\"213\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-revision-image.png 320w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Donnees-revision-image-300x200.png 300w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es une fois ins\u00e9r\u00e9es dans la feuille de calcul :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12041\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Image-importee.png\" alt=\"Image import\u00e9e\" width=\"609\" height=\"415\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Image-importee.png 609w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Image-importee-300x204.png 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/p>\n<p style=\"text-align: justify;\">Quel gain de temps, non ?<\/p>\n<p>L&#8217;image qui a servi d&#8217;illustration \u00e0 cet article est propos\u00e9e en libre t\u00e9l\u00e9chargement ci-apr\u00e8s afin de permettre au lecteur de s&#8217;exercer.<\/p>\n<p style=\"text-align: justify;\">L&#8217;importation de donn\u00e9es \u00e0 partir d&#8217;une photo peut \u00e9galement \u00eatre <a href=\"https:\/\/www.auditsi.eu\/?p=9737\">r\u00e9alis\u00e9e avec un <em>smartphone<\/em><\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=9139\">Importer le contenu d\u2019un document PDF dans un classeur Excel<\/a>&nbsp;\/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=1732\">Importer un fichier texte dans EXCEL<\/a>&nbsp;\/ <a href=\"https:\/\/www.auditsi.eu\/?page_id=11012\">Formation \u00e0 l&#8217;analyse de donn\u00e9es et \u00e0 l&#8217;automatisation<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12045\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Formation-Analyse-donnees-PDF.png\" alt=\"Formation Analyse donn\u00e9es PDF\" width=\"977\" height=\"750\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Formation-Analyse-donnees-PDF.png 977w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Formation-Analyse-donnees-PDF-300x230.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Formation-Analyse-donnees-PDF-768x590.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/11\/Formation-Analyse-donnees-PDF-730x560.png 730w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20R%C3%A9cup%C3%A9rer%20un%20tableau%20de%20donn%C3%A9es%20%C3%A0%20partir%20d%E2%80%99une%20photo%20ou%20d%27un%20document%20scann%C3%A9\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Vous avez photographi\u00e9 un tableau de donn\u00e9es dans un magazine ? Vous avez r\u00e9cup\u00e9r\u00e9 un tableau de donn\u00e9es dans une image (jpeg, png&#8230;) ? Et vous souhaitez transf\u00e9rer ces donn\u00e9es dans un tableau Excel sans les saisir manuellement ? La conversion du support photographique vers des donn\u00e9es texte s\u2019appuie sur un syst\u00e8me de reconnaissance de &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12036\" class=\"more-link\">Continue reading &lsquo;Excel : R\u00e9cup\u00e9rer un tableau de donn\u00e9es \u00e0 partir d\u2019une photo ou d&#8217;un document scann\u00e9&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20R%C3%A9cup%C3%A9rer%20un%20tableau%20de%20donn%C3%A9es%20%C3%A0%20partir%20d%E2%80%99une%20photo%20ou%20d%27un%20document%20scann%C3%A9\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,8,1326],"tags":[166,105,22,2882,3084,2268,1092,3083,3085,723,787,3086,2703],"class_list":["post-12036","post","type-post","status-publish","format-standard","hentry","category-excel","category-extractions-de-donnees","category-maitriser-excel","tag-analyse-de-donnees","tag-conversion-de-donnees","tag-extraction-de-donnees","tag-image","tag-jpeg","tag-menu-donnees","tag-ocr","tag-photo","tag-png","tag-productivite","tag-reconnaissance-optique-de-caracteres","tag-scan","tag-tableau-de-donnees"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12036"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12036\/revisions"}],"predecessor-version":[{"id":12049,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12036\/revisions\/12049"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}