{"id":2033,"date":"2022-06-27T12:06:58","date_gmt":"2022-06-27T12:06:58","guid":{"rendered":"https:\/\/csiag.eu\/?p=2033"},"modified":"2024-01-31T17:49:18","modified_gmt":"2024-01-31T17:49:18","slug":"voer-huidige-wisselkoers-in-excel-in","status":"publish","type":"post","link":"https:\/\/csiag.eu\/af\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Voer huidige wisselkoers in Excel in"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Inhoudsopgawe<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/csiag.eu\/af\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Gevallestudie<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/csiag.eu\/af\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integrasie in jou eie l\u00eaer<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/csiag.eu\/af\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Opdatering van die inhoud<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Leestyd<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minute<\/span><\/span>\n<p>Excel, bekend aan beide Windows- en Mac-gebruikers, bied lank reeds die vermo\u00eb om webinhoud in jou eie sigblaaie in te sluit.<br>Data op webwerwe wat slegs na aanmelding toeganklik is, kan egter nie herwin word nie.<\/p>\n\n\n\n<p>Die prosedure verskil effens in Windows en Mac OS. Hierdie afdeling beskryf Excel 2016 vir Mac OS.<\/p>\n\n\n\n<p>Wanneer Excel ge\u00efnstalleer word, die gebruikersmap (bv. xyz) <kbd>\/Gebruikers\/xyz\/Biblioteek\/Groephouers\/UBF8T346G9.Office\/Gebruikersinhoud.lokaal gemaak\/Navrae<\/kbd> twee voorbeeldl\u00eaers wat eindig met <em>.iqy <\/em>elk met &#039;n soeknavraag.<\/p>\n\n\n\n<p>Die l\u00eaers kan met die teksredigeerder oopgemaak word <em>Teksredigering<\/em> verwerk word.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Gevallestudie<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Gestel jy wil die dollarwisselkoers op die webwerf van finanzen.net nagaan, wat hier beskikbaar is. <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">webwerf<\/a> kan gevind word.<\/p>\n\n\n\n<p>Nadat die webadres gekopieer is en die voorbeeldl\u00eaer oopgemaak is <em>VoorbeeldWebnavraag01.iqy<\/em> verwyder hul inhoud en vervang dit met<\/p>\n\n\n\n<p>                    <kbd>WEB<br>         1<\/kbd><br>                    https:\/\/www.boerse.de\/devisen\/Euro-Dollar\/EU0009652759<\/p>\n\n\n\n<p>Die l\u00eaer kan byvoorbeeld gevind word by <kbd>dollarkurs.iqy<\/kbd> gered word.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integrasie in jou eie l\u00eaer<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Maak jou Excel-l\u00eaer oop en skep &#039;n nuwe werkblad daarin. Plaas die wyser in sel A1 van die nuwe werkblad en klik op die inskrywing in die program se kopbalk (nie in die werkbladvensterbalk nie). <em>Data<\/em>, verder af op <em>Herwin eksterne data<\/em>, gevolg deur <em>Voer webnavraag uit<\/em> In die Finder-venster wat oopmaak, kies die l\u00eaer wat jy so pas geskep het <em>dollarkurs.iqy<\/em> kies deur dubbel te klik.<\/p>\n\n\n\n<p>Die data word dan verkry vanaf die URL wat daarin vervat is. Na &#039;n paar sekondes verskyn die inhoud in die tabel.<\/p>\n\n\n\n<p>Dit is opmerklik dat die prys, byvoorbeeld &quot;1.0857 USD,&quot; as &#039;n teksstring vertoon word, nie as &#039;n re\u00eble getal nie. Dit is ook nie voldoende om hierdie sel as &#039;n &quot;getal&quot; te definieer deur selformatering te gebruik nie. In hierdie geval moet die string eers tot numeriese karakters verminder word en dan na &#039;n re\u00eble getal omgeskakel word.<\/p>\n\n\n\n<p>Die verkleining van die string word gedoen deur die formule in te voer <\/p>\n\n\n\n<p>                    <code><kbd>=LINKS(B9;8)<\/kbd><\/code><\/p>\n\n\n\n<p>Dit veroorsaak dat agt karakters van LINKS gekopieer word en die res uitgevee word.<\/p>\n\n\n\n<p>Die omskakeling na &#039;n re\u00eble getal lei tot &#039;n vermenigvuldiging met <kbd>1,0<\/kbd>, dus is die hele formule:<\/p>\n\n\n\n<p>                    <kbd>=LINKS(B9;8)*1.0<\/kbd><\/p>\n\n\n\n<p>Skakel nou oor na jou eie tabel, kies die veld waarin die dollarkoers vertoon moet word en klik op die <em>Somteken<\/em> Nadat u na die nuwe werkblad oorgeskakel het, kies die verlangde sel met die \u2013 nou suiwer \u2013 dollarkoers en druk <kbd>Enter\/Return-sleutel<\/kbd> Voltooi. Die dollarkoers word nou in die verlangde veld vertoon. Moenie vergeet om te stoor nie!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Opdatering van die inhoud<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Die volgende keer wat jy die l\u00eaer oopmaak, sal &#039;n venster verskyn wat jou die opsie gee om die inhoud op te dateer sodat die huidige kursus vertoon word wanneer jy die l\u00eaer oopmaak.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Leestyd<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minute<\/span><\/span>Excel, Windows- und Mac-Usern gleicherma\u00dfen bekannt, bietet schon l\u00e4nger die M\u00f6glichkeit, Webinhalte in eigene Tabellen zu \u00fcbernehmen.Allerdings, Daten auf Webseiten, die erst nach Login zug\u00e4nglich sind, sind nicht abrufbar. Die Vorgehensweise in Windows und Mac OS ist etwas unterschiedlich. Hier wird Excel 2016 f\u00fcr Mac OS beschrieben. Bei der Installation von Excel werden im Benutzerordner&hellip;&nbsp;<a href=\"https:\/\/csiag.eu\/af\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">Lees Meer \u00bb<span class=\"screen-reader-text\">Voer huidige wisselkoers in Excel in<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[368,367],"tags":[999,997,998,991,993,995,996,992,994],"class_list":["post-2033","post","type-post","status-publish","format-standard","hentry","category-aktuellen-waehrungskurs-in-excel-importieren","category-excel","tag-aktualisieren","tag-arbeitsblatt","tag-datenabruf","tag-excel","tag-importieren","tag-kurs","tag-samplewebquery01","tag-waehrungskurs","tag-webseite"],"modified_by":"Achim Goerner","_links":{"self":[{"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/af\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}