{"id":9737,"date":"2021-11-21T18:49:20","date_gmt":"2021-11-21T17:49:20","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=9737"},"modified":"2021-11-21T18:49:20","modified_gmt":"2021-11-21T17:49:20","slug":"un-tableau-de-donnees-imprime-a-analyser-sur-excel-il-nest-pas-necessaire-de-le-recopier-a-la-main-excel-2019-pour-smartphones-android-permet-dimporter-des-donnees-a-partir-dune-photographie","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=9737","title":{"rendered":"Excel : R\u00e9cup\u00e9rer un tableau de donn\u00e9es \u00e0 partir d&#8217;une photo"},"content":{"rendered":"<p style=\"text-align: justify;\">Un tableau de donn\u00e9es imprim\u00e9 sur papier \u00e0 analyser sur Excel ? Il n&#8217;est pas n\u00e9cessaire de le recopier \u00e0 la main. Excel 2019 pour smartphones Android permet d&#8217;importer des donn\u00e9es \u00e0 partir d&#8217;une photographie.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9750\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel.jpg\" alt=\"Lecture donn\u00e9es photo Excel\" width=\"745\" height=\"1073\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel.jpg 745w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-208x300.jpg 208w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-711x1024.jpg 711w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-730x1051.jpg 730w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><\/p>\n<p style=\"text-align: justify;\">La conversion du support photographique vers des donn\u00e9es informatiques s&#8217;appuie sur un syst\u00e8me de reconnaissance de caract\u00e8res (OCR). La qualit\u00e9 de la reconnaissance de caract\u00e8res d\u00e9pend pour beaucoup de la qualit\u00e9 de la prise de vue.<\/p>\n<p style=\"text-align: justify;\">La d\u00e9marche d&#8217;importation des donn\u00e9es est tr\u00e8s simple et est totalement prise en charge par Excel.<\/p>\n<p style=\"text-align: justify;\">Tout d&#8217;abord, ouvrir un nouveau Classeur Excel puis appuyer sur l&#8217;ic\u00f4ne Onglets en bas \u00e0 gauche de l&#8217;\u00e9cran :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9753\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-1.jpg\" alt=\"Lecture donn\u00e9es photo Excel 1\" width=\"720\" height=\"1280\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-1.jpg 720w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-1-169x300.jpg 169w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-1-576x1024.jpg 576w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/p>\n<p style=\"text-align: justify;\">La barre de menus se pr\u00e9sente maintenant ainsi :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9752\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-2.jpg\" alt=\"Lecture donn\u00e9es photo Excel 2\" width=\"716\" height=\"161\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-2.jpg 716w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-2-300x67.jpg 300w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/p>\n<p style=\"text-align: justify;\">Pointer sur l&#8217;ic\u00f4ne repr\u00e9sentant un appareil photo. Puis prendre en photo le tableau \u00e0 convertir sous Excel (exemple ici avec un <a href=\"https:\/\/www.auditsi.eu\/?page_id=2119\">comparatif de prix de mat\u00e9riel informatique et logiciels de 1987<\/a>) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9751\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-3.jpg\" alt=\"Lecture donn\u00e9es photo Excel 3\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-3.jpg 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-3-300x169.jpg 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-3-768x432.jpg 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-3-730x411.jpg 730w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify;\">Une fois la photo prise, ajuster les poign\u00e9es sur le contour du tableau \u00e0 analyser :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9749\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-4.jpg\" alt=\"Lecture donn\u00e9es photo Excel 4\" width=\"697\" height=\"549\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-4.jpg 697w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-4-300x236.jpg 300w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/p>\n<p style=\"text-align: justify;\">Puis, appuyer sur &#8220;Continuer&#8221; pour lancer la lecture OCR des donn\u00e9es (ou &#8220;Reprendre&#8221; pour recommencer la prise de la photographie) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9748\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-5.jpg\" alt=\"Lecture donn\u00e9es photo Excel 5\" width=\"712\" height=\"406\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-5.jpg 712w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-5-300x171.jpg 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><\/p>\n<p style=\"text-align: justify;\">Une fois le traitement OCR termin\u00e9, Excel propose sur un m\u00eame \u00e9cran la photo et le r\u00e9sultat de l&#8217;OCR aux fins de comparaison :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9747\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-6.jpg\" alt=\"Lecture donn\u00e9es photo Excel 6\" width=\"576\" height=\"1024\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-6.jpg 576w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-6-169x300.jpg 169w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es dont la reconnaissance de caract\u00e8res est identifi\u00e9e comme incertaine par Excel apparaissent dans un fond de couleur diff\u00e9rente. Cliquer sur &#8220;Ouvrir&#8221;. Excel propose alors de r\u00e9viser chaque \u00e9l\u00e9ment de donn\u00e9e (bouton &#8220;R\u00e9viser tout&#8221;) ou de transf\u00e9rer le r\u00e9sultat de l&#8217;OCR dans la feuille de travail tel quel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9746\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-7.jpg\" alt=\"Lecture donn\u00e9es photo Excel 7\" width=\"576\" height=\"1024\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-7.jpg 576w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-7-169x300.jpg 169w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p style=\"text-align: justify;\">Le r\u00e9sultat final appara\u00eet dans une feuille de travail Excel :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9745\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-8.jpg\" alt=\"Lecture donn\u00e9es photo Excel 8\" width=\"576\" height=\"1024\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-8.jpg 576w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2021\/11\/Lecture-donnees-photo-Excel-8-169x300.jpg 169w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p style=\"text-align: justify;\">Il ne reste plus qu&#8217;\u00e0 amender les donn\u00e9es et \u00e0 enregistrer le classeur.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?p=9139\">Importer le contenu d\u2019un document PDF dans un classeur Excel<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?p=1732\">Importer un fichier texte dans EXCEL<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">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 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 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%27une%20photo\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Un tableau de donn\u00e9es imprim\u00e9 sur papier \u00e0 analyser sur Excel ? Il n&#8217;est pas n\u00e9cessaire de le recopier \u00e0 la main. Excel 2019 pour smartphones Android permet d&#8217;importer des donn\u00e9es \u00e0 partir d&#8217;une photographie. La conversion du support photographique vers des donn\u00e9es informatiques s&#8217;appuie sur un syst\u00e8me de reconnaissance de caract\u00e8res (OCR). La qualit\u00e9 &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=9737\" class=\"more-link\">Continue reading &lsquo;Excel : R\u00e9cup\u00e9rer un tableau de donn\u00e9es \u00e0 partir d&#8217;une photo&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%27une%20photo\";<\/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,628,105,2013,22,1092,787,497],"class_list":["post-9737","post","type-post","status-publish","format-standard","hentry","category-excel","category-extractions-de-donnees","category-maitriser-excel","tag-analyse-de-donnees","tag-android","tag-conversion-de-donnees","tag-excel-2019","tag-extraction-de-donnees","tag-ocr","tag-reconnaissance-optique-de-caracteres","tag-smartphones"],"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\/9737","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=9737"}],"version-history":[{"count":10,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/9737\/revisions"}],"predecessor-version":[{"id":9760,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/9737\/revisions\/9760"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}