{"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-aktualni-smenny-kurz-do-aplikace-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/cs\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Import aktu\u00e1ln\u00edho sm\u011bnn\u00e9ho kurzu do aplikace 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\">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\/cs\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >P\u0159\u00edpadov\u00e1 studie<\/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\/cs\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integrace do vlastn\u00edho souboru<\/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\/cs\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Aktualizace obsahu<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Doba \u010dten\u00ed<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minuty<\/span><\/span>\n<p>Aplikace Excel, kterou znaj\u00ed u\u017eivatel\u00e9 syst\u00e9mu Windows i Mac, ji\u017e dlouho nab\u00edz\u00ed mo\u017enost p\u0159en\u00e1\u0161et webov\u00fd obsah do vlastn\u00edch tabulek.<br>\u00dadaje na webov\u00fdch str\u00e1nk\u00e1ch, kter\u00e9 jsou p\u0159\u00edstupn\u00e9 pouze po p\u0159ihl\u00e1\u0161en\u00ed, v\u0161ak nelze na\u010d\u00edst.<\/p>\n\n\n\n<p>Postup v syst\u00e9mech Windows a Mac OS se m\u00edrn\u011b li\u0161\u00ed. Excel 2016 pro Mac OS je pops\u00e1n zde.<\/p>\n\n\n\n<p>P\u0159i instalaci aplikace Excel obsahuje slo\u017eka u\u017eivatele (nap\u0159. xyz). <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/Queries<\/kbd> dva uk\u00e1zkov\u00e9 soubory, kter\u00e9 kon\u010d\u00ed <em>.iqy <\/em>ka\u017ed\u00fd s vyhled\u00e1vac\u00edm dotazem.<\/p>\n\n\n\n<p>Soubory lze upravovat pomoc\u00ed textov\u00e9ho editoru <em>\u00daprava textu<\/em> zpracov\u00e1v\u00e1ny.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>P\u0159\u00edpadov\u00e1 studie<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>P\u0159edpokl\u00e1dejme, \u017ee si chcete ov\u011b\u0159it kurz dolaru na webov\u00e9 str\u00e1nce finanzen.net, kterou najdete mimo jin\u00e9 na t\u00e9to adrese. <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">Webov\u00e9 str\u00e1nky<\/a> se nach\u00e1z\u00ed.<\/p>\n\n\n\n<p>Po zkop\u00edrov\u00e1n\u00ed webov\u00e9 adresy a otev\u0159en\u00ed uk\u00e1zkov\u00e9ho souboru <em>SampleWebQuery01.iqy<\/em> odstranit jeho obsah a nahradit ho textem<\/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>Soubor si m\u016f\u017eete st\u00e1hnout nap\u0159. pod odkazem <kbd>dollarkurs.iqy<\/kbd> lze ulo\u017eit.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integrace do vlastn\u00edho souboru<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Otev\u0159ete vlastn\u00ed soubor aplikace Excel a vytvo\u0159te v n\u011bm nov\u00fd pracovn\u00ed list. Um\u00edst\u011bte kurzor do bu\u0148ky A1 nov\u00e9ho pracovn\u00edho listu a klikn\u011bte na polo\u017eku <em>data<\/em>d\u00e1le na <em>Z\u00edsk\u00e1n\u00ed extern\u00edch dat<\/em>po kter\u00e9m n\u00e1sleduje <em>Spustit webov\u00fd dotaz<\/em> klikn\u011bte. V otev\u0159en\u00e9m okn\u011b Finderu vyberte pr\u00e1v\u011b vytvo\u0159en\u00fd soubor. <em>dollarkurs.iqy<\/em> dvojit\u00fdm kliknut\u00edm.<\/p>\n\n\n\n<p>Data se pak na\u010dtou z adresy URL, kterou obsahuje. Po n\u011bkolika sekund\u00e1ch se obsah zobraz\u00ed v tabulce.<\/p>\n\n\n\n<p>Je patrn\u00e9, \u017ee kurz se zobrazuje jako textov\u00fd \u0159et\u011bzec, nap\u0159. \"1,0857 USD\", a nikoli jako skute\u010dn\u00e9 \u010d\u00edslo. Rovn\u011b\u017e nesta\u010d\u00ed definovat tuto bu\u0148ku jako \"\u010d\u00edslo\" prost\u0159ednictv\u00edm form\u00e1tov\u00e1n\u00ed bu\u0148ky. \u0158et\u011bzec mus\u00ed b\u00fdt nejprve redukov\u00e1n na \u010d\u00edseln\u00e9 znaky a pot\u00e9 p\u0159eveden na re\u00e1ln\u00e9 \u010d\u00edslo.<\/p>\n\n\n\n<p>\u0158et\u011bzec se zmen\u0161\u00ed zad\u00e1n\u00edm vzorce <\/p>\n\n\n\n<p>                    <code><kbd>=LINKS(B9;8)<\/kbd><\/code><\/p>\n\n\n\n<p>To zp\u016fsob\u00ed, \u017ee se osm znak\u016f p\u0159enese z LEV\u00c9 strany a zbytek se odstran\u00ed.<\/p>\n\n\n\n<p>P\u0159evod na re\u00e1ln\u00e9 \u010d\u00edslo zp\u016fsob\u00ed n\u00e1soben\u00ed \u010d\u00edslem <kbd>1,0<\/kbd>co\u017e je cel\u00fd vzorec:<\/p>\n\n\n\n<p>                    <kbd>=LEFT(B9;8)*1.0<\/kbd><\/p>\n\n\n\n<p>Nyn\u00ed se p\u0159epn\u011bte do vlastn\u00ed tabulky, vyberte pole, ve kter\u00e9m se m\u00e1 zobrazit kurz dolaru, a klikn\u011bte na tla\u010d\u00edtko <em>Sou\u010dtov\u00fd znak<\/em> klikn\u011bte. Po p\u0159epnut\u00ed do nov\u00e9ho pracovn\u00edho listu vyberte po\u017eadovanou bu\u0148ku s - nyn\u00ed \u010dist\u00fdm - kurzem dolaru a stiskn\u011bte tla\u010d\u00edtko . <kbd>Tla\u010d\u00edtko Enter\/Return<\/kbd> dokon\u010dit. Kurz dolaru je nyn\u00ed v po\u017eadovan\u00e9m poli. Nezapome\u0148te ulo\u017eit!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Aktualizace obsahu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>P\u0159i p\u0159\u00ed\u0161t\u00edm otev\u0159en\u00ed souboru se zobraz\u00ed okno, ve kter\u00e9m lze aktualizovat obsah tak, aby se p\u0159i otev\u0159en\u00ed souboru zobrazil tak\u00e9 aktu\u00e1ln\u00ed kurz.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Doba \u010dten\u00ed<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minuty<\/span><\/span>Excel, zn\u00e1m\u00fd u\u017eivatel\u016fm Windows i Macu, ji\u017e dlouho nab\u00edz\u00ed mo\u017enost p\u0159en\u00e1\u0161et webov\u00fd obsah do vlastn\u00edch tabulek, a\u010dkoli data na webov\u00fdch str\u00e1nk\u00e1ch, kter\u00e1 jsou p\u0159\u00edstupn\u00e1 pouze po p\u0159ihl\u00e1\u0161en\u00ed, nelze na\u010d\u00edst. Postup v syst\u00e9mech Windows a Mac OS se m\u00edrn\u011b li\u0161\u00ed. Aplikace Excel 2016 pro syst\u00e9m Mac OS je pops\u00e1na zde. Po instalaci aplikace Excel se v u\u017eivatelsk\u00e9 slo\u017ece vytvo\u0159\u00ed soubory...&nbsp;<a href=\"https:\/\/csiag.eu\/cs\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">\u010c\u00edst d\u00e1le \"<span class=\"screen-reader-text\">Import aktu\u00e1ln\u00edho sm\u011bnn\u00e9ho kurzu do aplikace 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\/cs\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/cs\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}