{"id":1644,"date":"2016-07-07T22:04:33","date_gmt":"2016-07-07T20:04:33","guid":{"rendered":"http:\/\/www.office-guru.com\/wordpress\/?p=1644"},"modified":"2017-09-28T00:09:31","modified_gmt":"2017-09-27T22:09:31","slug":"extract-data-from-an-image-or-a-pdf","status":"publish","type":"post","link":"https:\/\/www.office-guru.com\/wordpress\/2016\/07\/extract-data-from-an-image-or-a-pdf\/","title":{"rendered":"Extract data from an image or a PDF"},"content":{"rendered":"<div style=text-align:right;><a class=\"wpptopdfenh\" target=\"_blank\" rel=\"noindex,nofollow\" href=\"https:\/\/www.office-guru.com\/wordpress\/2016\/07\/extract-data-from-an-image-or-a-pdf\/?format=pdf\" title=\"Download PDF\"><img alt=\"Download PDF\" src=\"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/plugins\/wp-post-to-pdf-enhanced\/asset\/images\/pdf.png?w=584\" data-recalc-dims=\"1\"><\/a><\/div><p>It may happen to access a PDF file over the internet with a graph and no data available in numeric format..<\/p>\n<p>this is an example from the European Parliamentary Research Service Blog:<\/p>\n<p><img class=\"aligncenter\" src=\"https:\/\/libraryeuroparl.files.wordpress.com\/2015\/03\/edu_fig5.png?w=584\" alt=\"Annual public expenditure on tertiary education as a % of GDP, 2008\" data-recalc-dims=\"1\" \/><\/p>\n<p><!--more-->source:<\/p>\n<ul>\n<li><a href=\"https:\/\/epthinktank.eu\/2015\/04\/03\/higher-education-in-the-eu-approaches-issues-and-trends\/edu_fig5\/\" target=\"_blank\" rel=\"noopener\">\u00a0https:\/\/epthinktank.eu\/2015\/04\/03\/higher-education-in-the-eu-approaches-issues-and-trends\/edu_fig5\/<\/a><\/li>\n<li><a href=\"https:\/\/epthinktank.eu\/2015\/04\/03\/higher-education-in-the-eu-approaches-issues-and-trends\/\" target=\"_blank\" rel=\"noopener\">https:\/\/epthinktank.eu\/2015\/04\/03\/higher-education-in-the-eu-approaches-issues-and-trends\/<\/a><\/li>\n<\/ul>\n<p>The problem is that it is impossible to use the depicted data: you have to print the image, use a ruler, do the math and get some approximate value&#8230;. unless&#8230;<\/p>\n<p><a href=\"http:\/\/arohatgi.info\/\" target=\"_blank\" rel=\"noopener\">Mr.\u00a0Ankit Rohatgi<\/a>\u00a0has developed a fantastic tool to capture data out of an image:\u00a0<a href=\"http:\/\/arohatgi.info\/WebPlotDigitizer\/app\/?\" target=\"_blank\" rel=\"noopener\">http:\/\/arohatgi.info\/WebPlotDigitizer\/app\/?<\/a><\/p>\n<p><img class=\"aligncenter\" src=\"https:\/\/i2.wp.com\/arohatgi.info\/WebPlotDigitizer\/images\/wpd-scaled.png?w=584\" data-recalc-dims=\"1\" \/><\/p>\n<p>It works quite well and it is easy to use<\/p>\n<p>Here some snapshot of the process to acquire data out of the proposed graph:<\/p>\n<p><a href=\"http:\/\/www.office-guru.com\/wordpress\/2016\/07\/extract-data-form-an-image-or-a-pdf\/capture1\/\" rel=\"attachment wp-att-1649\"><img loading=\"lazy\" class=\"wp-image-1649 size-large aligncenter\" src=\"https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?resize=584%2C412\" alt=\"Capture1\" width=\"584\" height=\"412\" srcset=\"https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?resize=1024%2C723&amp;ssl=1 1024w, https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?resize=300%2C212&amp;ssl=1 300w, https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?resize=768%2C542&amp;ssl=1 768w, https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?resize=624%2C440&amp;ssl=1 624w, https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?w=1250&amp;ssl=1 1250w, https:\/\/i1.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture1.png?w=1168 1168w\" sizes=\"(max-width: 584px) 100vw, 584px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>You have to define the type of graph and provide the axis so that the tool is able to do the math alone&#8230;<\/p>\n<p><a href=\"http:\/\/www.office-guru.com\/wordpress\/2016\/07\/extract-data-form-an-image-or-a-pdf\/capture2\/\" rel=\"attachment wp-att-1651\"><img loading=\"lazy\" class=\"wp-image-1651 size-large aligncenter\" src=\"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?resize=584%2C397\" alt=\"Capture2\" width=\"584\" height=\"397\" srcset=\"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?resize=1024%2C697&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?resize=300%2C204&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?resize=768%2C523&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?resize=624%2C425&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?w=1244&amp;ssl=1 1244w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?w=1168 1168w\" sizes=\"(max-width: 584px) 100vw, 584px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>you highlight the point you want to capture&#8230;<\/p>\n<p>and press the button to obtain..<\/p>\n<p><a href=\"http:\/\/www.office-guru.com\/wordpress\/2016\/07\/extract-data-form-an-image-or-a-pdf\/capture3\/\" rel=\"attachment wp-att-1652\"><img loading=\"lazy\" class=\"wp-image-1652 size-full aligncenter\" src=\"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture3.png?resize=584%2C358\" alt=\"Capture3\" width=\"584\" height=\"358\" srcset=\"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture3.png?w=818&amp;ssl=1 818w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture3.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture3.png?resize=768%2C471&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture3.png?resize=624%2C383&amp;ssl=1 624w\" sizes=\"(max-width: 584px) 100vw, 584px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>and you can export data: It is now simple to assign the correct labels to the Bars, you can even do it directly in the tool<\/p>\n<p>Now data is available for use it in your models, documents etc.<\/p>\n<p>Bar0, 2.406811582426196<br \/>\nBar1, 1.8897990839305203<br \/>\nBar2, 1.8656743437801189<br \/>\nBar3, 1.820263794272149<br \/>\nBar4, 1.5101476346872085<br \/>\nBar5, 1.4981932674139093<br \/>\nBar6, 1.4831993927156741<br \/>\nBar7, 1.3678184565473874<br \/>\nBar8, 1.322410992833757<br \/>\nBar9, 1.2526627833659236<br \/>\nBar10, 1.2255077931736058<br \/>\nBar11, 1.2196447839275366<br \/>\nBar12, 1.2168243679007436<br \/>\nBar13, 1.1227323268843656<br \/>\nBar14, 1.1047112879385552<br \/>\nBar15, 1.0714556823359878<br \/>\nBar16, 1.0351636551028254<br \/>\nBar17, 1.0323679254307496<br \/>\nBar18, 1.026495658801663<br \/>\nBar19, 1.0206326495555942<br \/>\nBar20, 0.9995566742131481<br \/>\nBar21, 0.951112788868922<br \/>\nBar22, 0.9452497796228547<br \/>\nBar23, 0.927216397499683<br \/>\nBar24, 0.8635502886760615<br \/>\nBar25, 0.8394378917030194<br \/>\nBar26, 0.839650811512483<br \/>\nBar27, 0.7820853180991101<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It may happen to access a PDF file over the internet with a graph and no data available in numeric format.. this is an example from the European Parliamentary Research Service Blog:<\/p>\n","protected":false},"author":4,"featured_media":1651,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"_links_to":"","_links_to_target":""},"categories":[5,15,17,14],"tags":[57,55,56,50],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2016\/07\/Capture2.png?fit=1244%2C847&ssl=1","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p39IU1-qw","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1763,"url":"https:\/\/www.office-guru.com\/wordpress\/2017\/09\/069-aggiungere-intervalli-ad-una-data-date-add-in-excel\/","url_meta":{"origin":1644,"position":0},"title":"069. Aggiungere intervalli ad una data: Date Add in Excel","date":"21 Settembre 2017","format":false,"excerpt":"Domanda: sto cercando di avere scadenze semestrali in successione su una riga in K5 inserisco data iniziale quindi poi in N5 inserisco =SE(VAL.VUOTO(K5);\"\";SOMMA(K5+180)) tutto ok quando vado ad inserire in P5 =SE(VAL.VUOTO(N5);\"\";SOMMA(N5+180)) mi restituisce #valore praticamente ho capito che il problema sta nel fatto che N5 no risulta vuota ma\u2026","rel":"","context":"In &quot;Domande Lettori&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":820,"url":"https:\/\/www.office-guru.com\/wordpress\/2014\/01\/data-parametrizzata\/","url_meta":{"origin":1644,"position":1},"title":"028. Data parametrizzata","date":"13 Gennaio 2014","format":false,"excerpt":"Domanda: Avrei bisogno di una macro, che inserendo in una cella definita, il nome del mese o il giorno della settimana, mi aggiorni i numeri del mese e i giorni della settimana. Risposta: E' possibile risolvere il problema sia con delle formule che con una macro. In allegato un file\u2026","rel":"","context":"In &quot;Senza categoria&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1686,"url":"https:\/\/www.office-guru.com\/wordpress\/2016\/09\/training-for-excel-and-vba-in-lynda\/","url_meta":{"origin":1644,"position":2},"title":"Training for Excel and VBA in Lynda","date":"9 Settembre 2016","format":false,"excerpt":"Here a nice training course in Lynda for Excel and VBA\u00a0to learn how to manage and data: Excel VBA: Managing Files and Data by Curt Frye You can learn how to filter data, open and closing files, use built-in worksheets functions in VBA, create charts and forms. It is pretty\u2026","rel":"","context":"In &quot;Excel&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":401,"url":"https:\/\/www.office-guru.com\/wordpress\/2013\/03\/come-sfruttare-le-funzioni-di-excel\/","url_meta":{"origin":1644,"position":3},"title":"011. Come sfruttare le funzioni di Excel","date":"21 Marzo 2013","format":false,"excerpt":"Spesso la soluzione dei problemi \u00e8 sotto i nostri occhi ma nessuno ci aiuta a vederla. Excel offre nativamente una vasta disponibilit\u00e0 di funzioni e spiegazioni sul loro funzionamento. Aspettano solo di essere utilizzate da noi. Supponiamo ad esempio di voler sapere\u00a0i\u00a0ricavi sui\u00a0contratti che vengono sottoscritti di luned\u00ec da ciascuno\u2026","rel":"","context":"In &quot;Tips&amp;Tricks&quot;","img":{"alt_text":"Help1","src":"https:\/\/i2.wp.com\/www.office-guru.com\/wordpress\/wp-content\/uploads\/2013\/03\/Help1-300x183.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":347,"url":"https:\/\/www.office-guru.com\/wordpress\/2013\/03\/estrarre-una-data-da-una-cella-di-testo\/","url_meta":{"origin":1644,"position":4},"title":"Estrarre una data da una cella di testo","date":"10 Marzo 2013","format":false,"excerpt":"Un lettore ci chiede: Buongiorno Vorrei se possibile estrarre le date dalle seguenti stringhe esempio DESENZANO DEL GARDA (BS) 10.04.1986 N.186 SALO' (BS) 15.02.1946 N.115 EXCEL 2007Risposta: La questione \u00a0\u00e8 abbastanza complicata utilizzando solo le formule Excel perch\u00e9 bisgna ricercare il pattern xx.xx.xxxx con \"x\" una cifra. Ho quindi preparato\u2026","rel":"","context":"In &quot;Domande Lettori&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1113,"url":"https:\/\/www.office-guru.com\/wordpress\/2014\/04\/analisi-variazioni-settimanali\/","url_meta":{"origin":1644,"position":5},"title":"045. Analisi variazioni settimanali","date":"2 Aprile 2014","format":false,"excerpt":"Domanda: devo analizzare degli indicatori, per esempio la produzione settimanale di un prodotto, e ottenere automaticamente la variazione, in positivo oppure in negativo, rispetto la settimana precedente. Il risultato che deve restituirmi la formula dev\\'essere un numero con segno positivo o negativo. La stessa analisi devo farla e ottenere la\u2026","rel":"","context":"In &quot;Domande Lettori&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/posts\/1644"}],"collection":[{"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1644"}],"version-history":[{"count":16,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/posts\/1644\/revisions"}],"predecessor-version":[{"id":1803,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/posts\/1644\/revisions\/1803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/media\/1651"}],"wp:attachment":[{"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.office-guru.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}