{"id":3821,"date":"2009-11-27T20:30:20","date_gmt":"2009-11-27T19:30:20","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=3821"},"modified":"2009-12-12T16:57:52","modified_gmt":"2009-12-12T15:57:52","slug":"gegevens-van-webpagina-of-pdf-in-excel-overbrengen","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/gegevens-van-webpagina-of-pdf-in-excel-overbrengen\/","title":{"rendered":"Gegevens van webpagina of PDF in Excel overbrengen?"},"content":{"rendered":"<p>V. Kan ik gegevens uit een webpagina of een PDF overnemen en in Excel plakken? Als ik probeer, staat alles per rij in \u00e9\u00e9n cel, of ik krijg vreemde randen.<\/p>\n<p>A. Jazeker, dat kan. Via Data, From web kan je een web query uitvoeren, en je kan de tabel aanduiden die je wil opnemen in Excel.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-webquery.png\"><img loading=\"lazy\" decoding=\"async\" title=\"XL-webquery\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-webquery-300x226.png\" alt=\"XL-webquery\" width=\"300\" height=\"226\" \/><\/a><\/p>\n<p>Als de gegevens gescheiden zijn door spaties en niet in een tabel staan kan je via Data, Sort &amp; Filter, \u00c2\u00a0Advanced splitsingen aanbrengen.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-converttxt2columns.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3823\" title=\"XL-converttxt2columns\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-converttxt2columns-300x228.png\" alt=\"XL-converttxt2columns\" width=\"300\" height=\"228\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-converttxt2columns-300x228.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2009\/11\/XL-converttxt2columns.png 521w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik gegevens uit een webpagina of een PDF overnemen en in Excel plakken? Als ik probeer, staat alles per rij in \u00e9\u00e9n cel, of ik krijg vreemde randen. A. Jazeker, dat kan. Via Data, From web kan je een web query uitvoeren, en je kan de tabel aanduiden<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[79,10],"tags":[],"class_list":["post-3821","post","type-post","status-publish","format-standard","hentry","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 01:06:13","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/3821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=3821"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/3821\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=3821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=3821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=3821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}