{"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":"importet-pasreizejo-valutas-kursu-programma-excel","status":"publish","type":"post","link":"https:\/\/csiag.eu\/lv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Pa\u0161reiz\u0113j\u0101 val\u016btas kursa import\u0113\u0161ana programm\u0101 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\">Satura r\u0101d\u012bt\u0101js<\/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\/lv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Gad\u012bjuma izp\u0113te<\/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\/lv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integr\u0101cija j\u016bsu fail\u0101<\/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\/lv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >Satura atjaunin\u0101\u0161ana<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Las\u012b\u0161anas laiks<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">protokols<\/span><\/span>\n<p class=\"wp-block-paragraph\">Gan Windows, gan Mac lietot\u0101jiem paz\u012bstam\u0101 programm\u0101 Excel jau sen tiek pied\u0101v\u0101ta iesp\u0113ja p\u0101rvietot t\u012bmek\u013ca saturu sav\u0101s tabul\u0101s.<br>Tom\u0113r datus par vietn\u0113m, kur\u0101m var piek\u013c\u016bt tikai p\u0113c pieteik\u0161an\u0101s, nav iesp\u0113jams atg\u016bt.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Proced\u016bra oper\u0113t\u0101jsist\u0113m\u0101s Windows un Mac OS nedaudz at\u0161\u0137iras. \u0160eit ir aprakst\u012bta Excel 2016 oper\u0113t\u0101jsist\u0113mai Mac OS.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kad ir instal\u0113ta programma Excel, lietot\u0101ja map\u0113 (piem., xyz) atrodas <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/Queries<\/kbd> divi parauga faili, kas beidzas ar <em>.iqy <\/em>katr\u0101 no tiem ir mekl\u0113\u0161anas vaic\u0101jums.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Failus var redi\u0123\u0113t, izmantojot teksta redaktoru <em>Teksta redi\u0123\u0113\u0161ana<\/em> j\u0101apstr\u0101d\u0101.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Gad\u012bjuma izp\u0113te<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pie\u0146emsim, ka v\u0113laties p\u0101rbaud\u012bt dol\u0101ra mai\u0146as kursu vietn\u0113 finanzen.net, kuru, cita starp\u0101, var atrast \u0161eit <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">T\u012bmek\u013ca vietne<\/a> ir atrodams.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P\u0113c t\u012bmek\u013ca adreses kop\u0113\u0161anas un parauga faila atv\u0113r\u0161anas <em>SampleWebQuery01.iqy<\/em> dz\u0113st t\u0101s saturu un aizst\u0101t to ar<\/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\">Datni var lejupiel\u0101d\u0113t, piem\u0113ram, sada\u013c\u0101 <kbd>dollarkurs.iqy<\/kbd> var saglab\u0101t.<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\u0101cija j\u016bsu fail\u0101<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Atveriet savu Excel failu un izveidojiet taj\u0101 jaunu darblapu. Novietojiet kursoru jaun\u0101s darblapas A1 \u0161\u016bn\u0101 un noklik\u0161\u0137iniet uz ieraksta <em>dati<\/em>t\u0101l\u0101k uz leju <em>\u0100r\u0113jo datu atg\u016b\u0161ana<\/em>kam seko <em>Izpild\u012bt t\u012bmek\u013ca vaic\u0101jumu<\/em> noklik\u0161\u0137iniet uz. Atv\u0113rtaj\u0101 Finder log\u0101 atlasiet tikko izveidoto failu. <em>dollarkurs.iqy<\/em> ar divk\u0101r\u0161u klik\u0161\u0137i.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P\u0113c tam dati tiek ieg\u016bti no taj\u0101 ietvert\u0101 URL. P\u0113c da\u017e\u0101m sekund\u0113m saturs par\u0101d\u0101s tabul\u0101.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ir paman\u0101ms, ka kurss tiek par\u0101d\u012bts k\u0101 teksta virkne, piem\u0113ram, \"1,0857 USD\", nevis k\u0101 re\u0101ls skaitlis. Ar \u0161\u016bnas format\u0113\u0161anu nepietiek, lai \u0161o \u0161\u016bnu defin\u0113tu k\u0101 \"skaitli\". Virkne vispirms j\u0101samazina l\u012bdz ciparu rakstz\u012bm\u0113m un p\u0113c tam j\u0101p\u0101rveido par re\u0101lu skaitli.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rindu samazina, ievadot formulu <\/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\">T\u0101 rezult\u0101t\u0101 asto\u0146as rakstz\u012bmes tiek p\u0101rnestas no LEFT un p\u0101r\u0113j\u0101s tiek dz\u0113stas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Konvert\u0113t uz re\u0101lu skaitli izraisa reizin\u0101\u0161anu ar <kbd>1,0<\/kbd>kas ir visa formula:<\/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\">Tagad p\u0101rsl\u0113dzieties uz savu tabulu, atlasiet lauku, kur\u0101 tiks par\u0101d\u012bts dol\u0101ra kurss, un noklik\u0161\u0137iniet uz ikonas <em>Summas z\u012bme<\/em> noklik\u0161\u0137iniet uz. P\u0113c p\u0101rsl\u0113g\u0161an\u0101s uz jauno darblapu atlasiet vajadz\u012bgo \u0161\u016bnas ar - tagad t\u012bro - dol\u0101ra likmi un nospiediet tausti\u0146u . <kbd>Ievades\/atgrie\u0161an\u0101s poga<\/kbd> pabeigt. Dol\u0101ra kurss tagad ir v\u0113lamaj\u0101 lauk\u0101. Neaizmirstiet saglab\u0101t!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>Satura atjaunin\u0101\u0161ana<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">N\u0101kamreiz, atverot failu, tiek par\u0101d\u012bts logs, kur\u0101 var atjaunin\u0101t saturu, lai, atverot failu, tiktu par\u0101d\u012bts ar\u012b pa\u0161reiz\u0113jais kurss.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Las\u012b\u0161anas laiks<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">protokols<\/span><\/span>Gan Windows, gan Mac lietot\u0101jiem paz\u012bstamais Excel jau sen pied\u0101v\u0101 iesp\u0113ju p\u0101rnest t\u012bmek\u013ca saturu sav\u0101s tabul\u0101s, lai gan datus no vietn\u0113m, kur\u0101m var piek\u013c\u016bt tikai p\u0113c pierakst\u012b\u0161an\u0101s, nav iesp\u0113jams ieg\u016bt. Proced\u016bra oper\u0113t\u0101jsist\u0113m\u0101s Windows un Mac OS ir nedaudz at\u0161\u0137ir\u012bga. \u0160eit ir aprakst\u012bta Excel 2016 oper\u0113t\u0101jsist\u0113mai Mac OS. Instal\u0113jot Excel, lietot\u0101ja map\u0113 tiek izveidoti faili...&nbsp;<a href=\"https:\/\/csiag.eu\/lv\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">Las\u012bt vair\u0101k \"<span class=\"screen-reader-text\">Pa\u0161reiz\u0113j\u0101 val\u016btas kursa import\u0113\u0161ana programm\u0101 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\/lv\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/lv\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}