{"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":"importovat-aktualny-vymenny-kurz-do-programu-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/sk\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Import aktu\u00e1lneho v\u00fdmenn\u00e9ho kurzu do programu Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 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\">Obsah<\/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\/sk\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Pr\u00edpadov\u00e1 \u0161t\u00fadia<\/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\/sk\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integr\u00e1cia do vlastn\u00e9ho s\u00faboru<\/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\/sk\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Aktualiz\u00e1cia obsahu<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u010cas \u010d\u00edtania<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">z\u00e1pisnice<\/span><\/span>\n<p class=\"wp-block-paragraph\">Excel, ktor\u00fd poznaj\u00fa pou\u017e\u00edvatelia syst\u00e9mu Windows aj Mac, u\u017e dlho pon\u00faka mo\u017enos\u0165 prenosu webov\u00e9ho obsahu do vlastn\u00fdch tabuliek.<br>\u00dadaje na webov\u00fdch str\u00e1nkach, ktor\u00e9 s\u00fa pr\u00edstupn\u00e9 len po prihl\u00e1sen\u00ed, v\u0161ak nie je mo\u017en\u00e9 z\u00edska\u0165.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Postup v syst\u00e9moch Windows a Mac OS sa mierne l\u00ed\u0161i. Excel 2016 pre Mac OS je op\u00edsan\u00fd tu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Po\u010das in\u0161tal\u00e1cie programu Excel obsahuje pou\u017e\u00edvate\u013esk\u00fd prie\u010dinok (napr. xyz) <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/Queries<\/kbd> dva vzorov\u00e9 s\u00fabory, ktor\u00e9 kon\u010dia <em>.iqy <\/em>ka\u017ed\u00fd s vyh\u013ead\u00e1vac\u00edm dotazom.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00fabory m\u00f4\u017eete upravova\u0165 pomocou textov\u00e9ho editora <em>\u00daprava textu<\/em> spracova\u0165.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Pr\u00edpadov\u00e1 \u0161t\u00fadia<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Predpokladajme, \u017ee si chcete overi\u0165 v\u00fdmenn\u00fd kurz dol\u00e1ra na webovej str\u00e1nke finanzen.net, ktor\u00fa n\u00e1jdete okrem in\u00e9ho na tejto adrese <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">Webov\u00e1 lokalita<\/a> sa nach\u00e1dza.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Po skop\u00edrovan\u00ed webovej adresy a otvoren\u00ed vzorov\u00e9ho s\u00faboru <em>SampleWebQuery01.iqy<\/em> vymaza\u0165 jeho obsah a nahradi\u0165 ho textom<\/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\">S\u00fabor si m\u00f4\u017eete stiahnu\u0165 napr. v \u010dasti <kbd>dollarkurs.iqy<\/kbd> mo\u017eno ulo\u017ei\u0165.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integr\u00e1cia do vlastn\u00e9ho s\u00faboru<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Otvorte vlastn\u00fd s\u00fabor programu Excel a vytvorte v \u0148om nov\u00fd pracovn\u00fd h\u00e1rok. Umiestnite kurzor do bunky A1 nov\u00e9ho pracovn\u00e9ho h\u00e1rka a kliknite na polo\u017eku <em>\u00fadaje<\/em>\u010falej na <em>Z\u00edskavanie extern\u00fdch \u00fadajov<\/em>po ktorom nasleduje <em>Vykonanie webov\u00e9ho dotazu<\/em> klikn\u00fa\u0165. V otvorenom okne Finderu vyberte pr\u00e1ve vytvoren\u00fd s\u00fabor. <em>dollarkurs.iqy<\/em> dvojit\u00fdm kliknut\u00edm.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00dadaje sa potom na\u010d\u00edtaj\u00fa z adresy URL, ktor\u00fa obsahuje. Po nieko\u013ek\u00fdch sekund\u00e1ch sa obsah zobraz\u00ed v tabu\u013eke.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Je n\u00e1padn\u00e9, \u017ee kurz sa zobrazuje ako textov\u00fd re\u0165azec, napr. \"1,0857 USD\", a nie ako skuto\u010dn\u00e9 \u010d\u00edslo. Taktie\u017e nesta\u010d\u00ed definova\u0165 t\u00fato bunku ako \"\u010d\u00edslo\" prostredn\u00edctvom form\u00e1tovania bunky. Re\u0165azec sa mus\u00ed najprv zredukova\u0165 na \u010d\u00edseln\u00e9 znaky a potom previes\u0165 na re\u00e1lne \u010d\u00edslo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Re\u0165azec sa zmen\u0161\u00ed zadan\u00edm vzorca <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                    <code><kbd>=LINKS(B9;8)<\/kbd><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To sp\u00f4sob\u00ed, \u017ee sa z LEFT prenesie osem znakov a zvy\u0161ok sa vyma\u017ee.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prevod na re\u00e1lne \u010d\u00edslo sp\u00f4sob\u00ed n\u00e1sobenie <kbd>1,0<\/kbd>\u010do je cel\u00fd vzorec:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                    <kbd>=LEFT(B9;8)*1.0<\/kbd><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teraz sa prepnite do vlastnej tabu\u013eky, vyberte pole, v ktorom sa m\u00e1 zobrazi\u0165 kurz dol\u00e1ra, a kliknite na tla\u010didlo <em>Zna\u010dka s\u00fa\u010dtu<\/em> klikn\u00fa\u0165. Po prepnut\u00ed na nov\u00fd pracovn\u00fd h\u00e1rok vyberte po\u017eadovan\u00fa bunku s - teraz u\u017e \u010dist\u00fdm - kurzom dol\u00e1ra a stla\u010dte tla\u010didlo <kbd>Tla\u010didlo Enter\/Return<\/kbd> dokon\u010di\u0165. Kurz dol\u00e1ra je teraz v po\u017eadovanom poli. Nezabudnite ulo\u017ei\u0165!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Aktualiz\u00e1cia obsahu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pri \u010fal\u0161om otvoren\u00ed s\u00faboru sa zobraz\u00ed okno, v ktorom je mo\u017en\u00e9 aktualizova\u0165 obsah tak, aby sa pri otvoren\u00ed s\u00faboru zobrazil aj aktu\u00e1lny kurz.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u010cas \u010d\u00edtania<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">z\u00e1pisnice<\/span><\/span>Excel, zn\u00e1my pou\u017e\u00edvate\u013eom Windows aj Mac, u\u017e dlho pon\u00faka mo\u017enos\u0165 prenosu webov\u00e9ho obsahu do vlastn\u00fdch tabuliek, hoci \u00fadaje na webov\u00fdch str\u00e1nkach, ku ktor\u00fdm je mo\u017en\u00e9 pristupova\u0165 len po prihl\u00e1sen\u00ed, nie je mo\u017en\u00e9 na\u010d\u00edta\u0165. Postup v syst\u00e9moch Windows a Mac OS sa mierne l\u00ed\u0161i. Program Excel 2016 pre syst\u00e9m Mac OS je op\u00edsan\u00fd tu. Po in\u0161tal\u00e1cii programu Excel sa v pou\u017e\u00edvate\u013eskom prie\u010dinku vytvoria s\u00fabory...&nbsp;<a href=\"https:\/\/csiag.eu\/sk\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">\u010c\u00edta\u0165 viac \"<span class=\"screen-reader-text\">Import aktu\u00e1lneho v\u00fdmenn\u00e9ho kurzu do programu 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\/sk\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/sk\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}