{"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":"importuoti-dabartini-valiutos-kursa-i-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/lt\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Importuokite dabartin\u012f valiutos kurs\u0105 \u012f \"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\">Turinys<\/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\/lt\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Atvejo analiz\u0117<\/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\/lt\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integravimas \u012f savo fail\u0105<\/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\/lt\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Turinio atnaujinimas<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Skaitymo laikas<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minut\u0117s<\/span><\/span>\n<p class=\"wp-block-paragraph\">Tiek \"Windows\", tiek \"Mac\" naudotojams gerai pa\u017e\u012fstamoje \"Excel\" programoje jau seniai si\u016bloma galimyb\u0117 perkelti \u017einiatinklio turin\u012f \u012f savo lenteles.<br>Ta\u010diau duomen\u0173 i\u0161 svetaini\u0173, prie kuri\u0173 galima prisijungti tik prisijungus, atkurti negalima.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Proced\u016bra \"Windows\" ir \"Mac OS\" operacin\u0117se sistemose \u0161iek tiek skiriasi. \u010cia apra\u0161yta \"Mac OS\" skirta \"Excel 2016\".<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u012ediegus \"Excel\", naudotojo aplanke (pvz., xyz) yra <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/Queries<\/kbd> du pavyzdiniai failai, kurie baigiasi <em>.iqy <\/em>su paie\u0161kos u\u017eklausa.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Failus galima redaguoti teksto redaktoriumi <em>Teksto redagavimas<\/em> b\u016bti apdoroti.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Atvejo analiz\u0117<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Tarkime, kad norite patikrinti dolerio kurs\u0105 svetain\u0117je finanzen.net, kuri\u0105, be kita ko, rasite \u0161iame puslapyje. <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">Svetain\u0117<\/a> galima rasti.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nukopijav\u0119 \u017einiatinklio adres\u0105 ir atidar\u0119 pavyzdin\u012f fail\u0105 <em>SampleWebQuery01.iqy<\/em> i\u0161trinkite jo turin\u012f ir pakeiskite j\u012f<\/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\">Fail\u0105 galima atsisi\u0173sti, pvz., i\u0161 <kbd>dollarkurs.iqy<\/kbd> galima i\u0161saugoti.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Integration_in_die_eigene_Datei\"><\/span>Integravimas \u012f savo fail\u0105<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Atidarykite savo \"Excel\" fail\u0105 ir jame sukurkite nauj\u0105 darbalap\u012f. Nustatykite \u017eymekl\u012f naujosios darbalapio l\u0105stel\u0117je A1 ir spustel\u0117kite \u012fra\u0161\u0105 <em>duomenys<\/em>toliau \u017eemyn <em>I\u0161orini\u0173 duomen\u0173 gavimas<\/em>po kurio seka <em>Vykdyti \u017einiatinklio u\u017eklaus\u0105<\/em> spustel\u0117kite. Atsidariusiame \"Finder\" lange pasirinkite k\u0105 tik sukurt\u0105 fail\u0105. <em>dollarkurs.iqy<\/em> dukart spustel\u0117kite.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tada duomenys gaunami i\u0161 jame nurodyto URL adreso. Po keli\u0173 sekund\u017ei\u0173 turinys rodomas lentel\u0117je.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pasteb\u0117tina, kad kursas rodomas kaip teksto eilut\u0117, pvz., \"1,0857 USD\", o ne kaip realus skai\u010dius. Taip pat nepakanka \u0161\u012f langel\u012f apibr\u0117\u017eti kaip \"skai\u010di\u0173\" per langelio formatavim\u0105. Pirmiausia eilut\u0117 turi b\u016bti suma\u017einta iki skaitini\u0173 simboli\u0173 ir tada paversta realiuoju skai\u010diumi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Eilut\u0117 suma\u017einama \u012fvedant formul\u0119 <\/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\">A\u0161tuoni simboliai perkeliami i\u0161 LEFT, o kiti i\u0161trinami.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Konvertuojant \u012f real\u0173j\u012f skai\u010di\u0173, dauginama i\u0161 <kbd>1,0<\/kbd>tai yra visa formul\u0117:<\/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\">Dabar pereikite prie savo lentel\u0117s, pasirinkite lauk\u0105, kuriame turi b\u016bti rodomas dolerio kursas, ir spustel\u0117kite <em>Suma \u017eenklas<\/em> spustel\u0117kite. Per\u0117j\u0119 \u012f nauj\u0105 darbalap\u012f, pasirinkite norim\u0105 l\u0105stel\u0119 su dabar jau grynu dolerio kursu ir paspauskite klavi\u0161\u0105 <kbd>\u012evesties \/ gr\u0105\u017einimo mygtukas<\/kbd> u\u017ebaigti. Dabar dolerio kursas yra norimame laukelyje. Nepamir\u0161kite i\u0161saugoti!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Turinio atnaujinimas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kit\u0105 kart\u0105 atidarant fail\u0105 rodomas langas, kuriame galima atnaujinti turin\u012f taip, kad atidarant fail\u0105 b\u016bt\u0173 rodomas ir dabartinis kursas.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Skaitymo laikas<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">minut\u0117s<\/span><\/span>Tiek \"Windows\", tiek \"Mac\" vartotojams \u017einomoje \"Excel\" programoje jau seniai si\u016bloma galimyb\u0117 perkelti \u017einiatinklio turin\u012f \u012f savo lenteles, ta\u010diau duomen\u0173 i\u0161 svetaini\u0173, kurias galima pasiekti tik prisijungus, gauti negalima. Proced\u016bra \"Windows\" ir \"Mac OS\" operacin\u0117se sistemose \u0161iek tiek skiriasi. \u010cia apra\u0161oma \"Mac OS\" skirta \"Excel 2016\". \u012ediegus \"Excel\", naudotojo aplanke sukuriami failai...&nbsp;<a href=\"https:\/\/csiag.eu\/lt\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">Skaityti daugiau \"<span class=\"screen-reader-text\">Importuokite dabartin\u012f valiutos kurs\u0105 \u012f \"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\/lt\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/lt\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}