{"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":"importera-aktuell-valutakurs-till-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/sv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Importera aktuell valutakurs till Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">Inneh\u00e5llsf\u00f6rteckning<\/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\/sv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Fallstudie<\/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\/sv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integrering 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\/sv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Uppdatering av inneh\u00e5ll<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">L\u00e4stid<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minuter<\/span><\/span>\n<p class=\"wp-block-paragraph\">Excel, k\u00e4nt f\u00f6r b\u00e5de Windows- och Mac-anv\u00e4ndare, har l\u00e4nge erbjudit m\u00f6jligheten att kopiera webbinneh\u00e5ll till dina egna tabeller.<br>Data p\u00e5 webbplatser som endast \u00e4r tillg\u00e4ngliga efter inloggning kan dock inte n\u00e5s.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Proceduren i Windows och Mac OS \u00e4r n\u00e5got annorlunda. Excel 2016 f\u00f6r Mac OS beskrivs h\u00e4r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e4r du installerar Excel, i anv\u00e4ndarmappen (t.ex. xyz) <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localized\/Queries<\/kbd> tv\u00e5 exempelfiler som slutar med <em>.iqy <\/em>var och en lagras med en s\u00f6kfr\u00e5ga.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Filerna kan redigeras med hj\u00e4lp av textredigeraren <em>Textredigering<\/em> bearbetas.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Fallstudie<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Anta att du vill fr\u00e5ga dollarkursen p\u00e5 webbplatsen finanzen.net, som bland annat finns tillg\u00e4nglig p\u00e5 denna webbplats <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">webbplats<\/a> kan hittas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Efter att ha kopierat webbadressen och \u00f6ppnat exempelfilen <em>SampleWebQuery01.iqy<\/em> du tar bort deras inneh\u00e5ll och ers\u00e4tter det med<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                    <kbd>WEB<br>         1<\/kbd><br>                    https:\/\/www.boerse.de\/devisen\/Euro-Dollar\/EU0009652759<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Filen finns p\u00e5 t.ex <kbd>dollarkurs.iqy<\/kbd> bli r\u00e4ddad.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integrering i din egen fil<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6ppna din egen Excel-fil och skapa ett nytt kalkylblad i den. Placera mark\u00f6ren i cell A1 i det nya kalkylbladet och klicka p\u00e5 posten \u00f6verst i programrubrikraden (inte i kalkylbladets f\u00f6nsterf\u00e4lt). <em>Data<\/em>, d\u00e4r l\u00e4ngre ner <em>H\u00e4mta extern data<\/em>, f\u00f6ljt av <em>Utf\u00f6r webbfr\u00e5ga<\/em> klick. I Finder-f\u00f6nstret som \u00f6ppnas, filen du just skapade <em>dollarkurs.iqy<\/em> v\u00e4lj genom att dubbelklicka.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Detta f\u00f6ljs av datah\u00e4mtning fr\u00e5n URL:en som finns d\u00e4ri. Efter n\u00e5gra sekunder visas inneh\u00e5llet i tabellen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Det som m\u00e4rks \u00e4r att priset visas som till exempel &quot;1.0857 USD&quot;, det vill s\u00e4ga som en textstr\u00e4ng, inte som ett reellt tal. Det r\u00e4cker inte heller att definiera denna cell som ett &quot;nummer&quot; med cellformatering. H\u00e4r m\u00e5ste str\u00e4ngen f\u00f6rst reduceras till de numeriska tecknen och sedan omvandlas till ett reellt tal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Str\u00e4ngen reduceras genom att ange formeln <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                    <code><kbd>=V\u00c4NSTER(B9;8)<\/kbd><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Det g\u00f6r att \u00e5tta tecken tas fr\u00e5n V\u00c4NSTER och resten raderas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Omvandlingen till ett reellt tal orsakar en multiplikation med <kbd>1,0<\/kbd>, vilket betyder att hela formeln \u00e4r:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                    <kbd>=V\u00c4NSTER(B9;8)*1,0<\/kbd><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">G\u00e5 nu till din egen tabell, v\u00e4lj f\u00e4ltet d\u00e4r dollarkursen ska visas och klicka p\u00e5 det l\u00e4ngst upp i startmenyn <em>Summan tecken<\/em> klick. Efter att ha bytt till det nya kalkylbladet, v\u00e4lj \u00f6nskad cell med den - nu rena - dollarkursen och tryck p\u00e5 <kbd>Enter\/Retur-knapp<\/kbd> komplett. Dollarkursen \u00e4r nu i det \u00f6nskade f\u00e4ltet. Gl\u00f6m inte att spara!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Uppdatering av inneh\u00e5ll<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e4sta g\u00e5ng du \u00f6ppnar filen kommer ett f\u00f6nster upp d\u00e4r du kan uppdatera inneh\u00e5llet s\u00e5 att den aktuella kursen visas efter att filen har \u00f6ppnats.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">L\u00e4stid<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minuter<\/span><\/span>Excel, som \u00e4r k\u00e4nt av b\u00e5de Windows- och Mac-anv\u00e4ndare, har l\u00e4nge erbjudit m\u00f6jligheten att \u00f6verf\u00f6ra webbinneh\u00e5ll till dina egna tabeller, \u00e4ven om data p\u00e5 webbplatser som endast kan n\u00e5s efter inloggning inte kan h\u00e4mtas. F\u00f6rfarandet i Windows och Mac OS \u00e4r n\u00e5got annorlunda. Excel 2016 f\u00f6r Mac OS beskrivs h\u00e4r. N\u00e4r Excel installeras skapas filer i anv\u00e4ndarmappen...&nbsp;<a href=\"https:\/\/csiag.eu\/sv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">L\u00e4s mer \"<span class=\"screen-reader-text\">Importera aktuell valutakurs till 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\/sv\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/sv\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}