{"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":"import-af-aktuel-valutakurs-til-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/da\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Importer den aktuelle valutakurs til Excel"},"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\">Indholdsfortegnelse<\/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\/da\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Casestudie<\/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\/da\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integration i din egen fil<\/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\/da\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Opdatering af indholdet<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">L\u00e6setid<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minutter<\/span><\/span>\n<p>Excel, som b\u00e5de Windows- og Mac-brugere kender, har l\u00e6nge givet mulighed for at overf\u00f8re webindhold til dine egne tabeller.<br>Men data p\u00e5 hjemmesider, der kun kan tilg\u00e5s efter login, kan ikke hentes.<\/p>\n\n\n\n<p>Fremgangsm\u00e5den i Windows og Mac OS er lidt forskellig. Excel 2016 til Mac OS er beskrevet her.<\/p>\n\n\n\n<p>Under installationen af Excel indeholder brugermappen (f.eks. xyz) <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/Queries<\/kbd> to eksempler p\u00e5 filer, der slutter med <em>.iqy <\/em>hver med en s\u00f8geforesp\u00f8rgsel.<\/p>\n\n\n\n<p>Filerne kan redigeres med teksteditoren <em>Rediger tekst<\/em> blive behandlet.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Casestudie<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Lad os antage, at du vil tjekke dollarkursen p\u00e5 hjemmesiden finanzen.net, som du blandt andet kan finde her <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">Hjemmeside<\/a> er at finde.<\/p>\n\n\n\n<p>Efter at have kopieret webadressen og \u00e5bnet pr\u00f8vefilen <em>Eksempel p\u00e5 WebQuery01.iqy<\/em> Slet indholdet og erstat det med<\/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>Filen kan f.eks. downloades under <kbd>dollarkurs.iqy<\/kbd> kan reddes.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integration i din egen fil<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u00c5bn din egen Excel-fil, og opret et nyt regneark i den. Placer mark\u00f8ren i celle A1 i det nye regneark, og klik p\u00e5 posten <em>data<\/em>l\u00e6ngere nede p\u00e5 <em>Hent eksterne data<\/em>efterfulgt af <em>Udf\u00f8r webforesp\u00f8rgsel<\/em> klik. I Finder-vinduet, der \u00e5bnes, skal du v\u00e6lge den fil, du lige har oprettet. <em>dollarkurs.iqy<\/em> med et dobbeltklik.<\/p>\n\n\n\n<p>Dataene hentes derefter fra den URL, de indeholder. Efter et par sekunder vises indholdet i tabellen.<\/p>\n\n\n\n<p>Det er bem\u00e6rkelsesv\u00e6rdigt, at kursen vises som en tekststreng, f.eks. \"1,0857 USD\", og ikke som et rigtigt tal. Det er heller ikke tilstr\u00e6kkeligt at definere denne celle som et \"tal\" via celleformateringen. Strengen skal f\u00f8rst reduceres til numeriske tegn og derefter konverteres til et reelt tal.<\/p>\n\n\n\n<p>Strengen reduceres ved at indtaste formlen <\/p>\n\n\n\n<p>                    <code><kbd>=LINKS(B9;8)<\/kbd>.<\/code><\/p>\n\n\n\n<p>Det f\u00e5r otte tegn til at blive overf\u00f8rt fra VENSTRE og resten til at blive slettet.<\/p>\n\n\n\n<p>Konverteringen til et reelt tal medf\u00f8rer en multiplikation med <kbd>1,0<\/kbd>hvilket er hele formlen:<\/p>\n\n\n\n<p>                    <kbd>=LEFT(B9;8)*1.0<\/kbd><\/p>\n\n\n\n<p>Skift nu til din egen tabel, v\u00e6lg det felt, hvor dollarkursen skal vises, og klik p\u00e5 knappen <em>Sum-tegn<\/em> klik. N\u00e5r du har skiftet til det nye regneark, skal du v\u00e6lge den \u00f8nskede celle med den - nu rene - dollarkurs og trykke p\u00e5 <kbd>Enter\/Return-knap<\/kbd> for at afslutte. Dollarkursen st\u00e5r nu i det \u00f8nskede felt. Glem ikke at gemme!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Opdatering af indholdet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>N\u00e6ste gang filen \u00e5bnes, vises et vindue, hvor indholdet kan opdateres, s\u00e5 det aktuelle forl\u00f8b ogs\u00e5 vises, n\u00e5r filen \u00e5bnes.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">L\u00e6setid<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minutter<\/span><\/span>Excel, som b\u00e5de Windows- og Mac-brugere kender, har l\u00e6nge givet mulighed for at overf\u00f8re webindhold til dine egne tabeller, selv om data p\u00e5 websteder, der kun kan tilg\u00e5s efter login, ikke kan hentes. Fremgangsm\u00e5den i Windows og Mac OS er lidt forskellig. Excel 2016 til Mac OS er beskrevet her. N\u00e5r Excel installeres, oprettes der filer i brugermappen...&nbsp;<a href=\"https:\/\/csiag.eu\/da\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">L\u00e6s mere \"<span class=\"screen-reader-text\">Importer den aktuelle valutakurs til Excel<\/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\/da\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/da\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}