{"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":"aktualis-arfolyam-importalasa-az-excelbe","status":"publish","type":"post","link":"https:\/\/csiag.eu\/hu\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/","title":{"rendered":"Aktu\u00e1lis \u00e1rfolyam import\u00e1l\u00e1sa Excelbe"},"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\">Tartalomjegyz\u00e9k<\/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\/hu\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Fallbeispiel\" >Esettanulm\u00e1ny<\/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\/hu\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Integration_in_die_eigene_Datei\" >Integr\u00e1ci\u00f3 a saj\u00e1t f\u00e1jlj\u00e1ba<\/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\/hu\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/#Aktualisierung_des_Inhalts\" >A tartalom friss\u00edt\u00e9se<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Olvas\u00e1si id\u0151<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">percek<\/span><\/span>\n<p>A Windows- \u00e9s Mac-felhaszn\u00e1l\u00f3k sz\u00e1m\u00e1ra egyar\u00e1nt ismer\u0151s Excel m\u00e1r r\u00e9g\u00f3ta k\u00edn\u00e1lja a webes tartalmak saj\u00e1t t\u00e1bl\u00e1zatokba t\u00f6rt\u00e9n\u0151 \u00e1tvitel\u00e9nek lehet\u0151s\u00e9g\u00e9t.<br>A csak bejelentkez\u00e9s ut\u00e1n el\u00e9rhet\u0151 weboldalakon l\u00e9v\u0151 adatok azonban nem k\u00e9rhet\u0151k le.<\/p>\n\n\n\n<p>A Windows \u00e9s a Mac OS eset\u00e9ben az elj\u00e1r\u00e1s kiss\u00e9 elt\u00e9r\u0151. Az Excel 2016 a Mac OS sz\u00e1m\u00e1ra itt van le\u00edrva.<\/p>\n\n\n\n<p>Az Excel telep\u00edt\u00e9se sor\u00e1n a felhaszn\u00e1l\u00f3i mappa (pl. xyz) tartalmazza a k\u00f6vetkez\u0151ket <kbd>\/Users\/xyz\/Library\/Group Containers\/UBF8T346G9.Office\/User Content.localised\/K\u00e9rd\u00e9sek<\/kbd> k\u00e9t mintaf\u00e1jl, amelyek a k\u00f6vetkez\u0151vel v\u00e9gz\u0151dnek <em>.iqy <\/em>mindegyiket egy keres\u00e9si lek\u00e9rdez\u00e9ssel.<\/p>\n\n\n\n<p>A f\u00e1jlok szerkeszthet\u0151k a sz\u00f6vegszerkeszt\u0151vel <em>Sz\u00f6veg szerkeszt\u00e9se<\/em> feldolgozand\u00f3.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fallbeispiel\"><\/span>Esettanulm\u00e1ny<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tegy\u00fck fel, hogy a finanzen.net weboldalon szeretn\u00e9 ellen\u0151rizni a doll\u00e1r \u00e1rfolyam\u00e1t, amely t\u00f6bbek k\u00f6z\u00f6tt ezen a linken is megtal\u00e1lhat\u00f3. <a href=\"https:\/\/www.finanzen.net\/devisen\/dollarkurs\" target=\"_blank\" rel=\"noreferrer noopener\">Honlap<\/a> tal\u00e1lhat\u00f3.<\/p>\n\n\n\n<p>A webc\u00edm m\u00e1sol\u00e1sa \u00e9s a mintaf\u00e1jl megnyit\u00e1sa ut\u00e1n <em>SampleWebQuery01.iqy<\/em> t\u00f6r\u00f6lje a tartalm\u00e1t, \u00e9s helyettes\u00edtse a k\u00f6vetkez\u0151vel<\/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>A f\u00e1jl let\u00f6lthet\u0151 pl. a k\u00f6vetkez\u0151 c\u00edmr\u0151l <kbd>dollarkurs.iqy<\/kbd> megmenthet\u0151.<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\u00e1ci\u00f3 a saj\u00e1t f\u00e1jlj\u00e1ba<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Nyissa meg saj\u00e1t Excel-f\u00e1jlj\u00e1t, \u00e9s hozzon l\u00e9tre benne egy \u00faj munkalapot. Helyezze a kurzort az \u00faj munkalap A1 cell\u00e1j\u00e1ba, \u00e9s kattintson a bejegyz\u00e9sre <em>adatok<\/em>lejjebb a <em>K\u00fcls\u0151 adatok lek\u00e9rdez\u00e9se<\/em>amelyet a k\u00f6vetkez\u0151 k\u00f6vet <em>Webes lek\u00e9rdez\u00e9s v\u00e9grehajt\u00e1sa<\/em> kattints. A megny\u00edl\u00f3 Finder ablakban v\u00e1lassza ki az im\u00e9nt l\u00e9trehozott f\u00e1jlt. <em>dollarkurs.iqy<\/em> dupla kattint\u00e1ssal.<\/p>\n\n\n\n<p>Az adatokat ezut\u00e1n a benne tal\u00e1lhat\u00f3 URL-c\u00edmr\u0151l h\u00edvja le. N\u00e9h\u00e1ny m\u00e1sodperc m\u00falva a tartalom megjelenik a t\u00e1bl\u00e1zatban.<\/p>\n\n\n\n<p>Felt\u0171n\u0151, hogy az \u00e1rfolyam sz\u00f6veges karakterl\u00e1nck\u00e9nt jelenik meg, pl. \"1,0857 USD\", \u00e9s nem val\u00f3s sz\u00e1mk\u00e9nt. Az sem elegend\u0151, hogy ezt a cell\u00e1t \"sz\u00e1mk\u00e9nt\" hat\u00e1rozzuk meg a cella form\u00e1z\u00e1s\u00e1val. A karakterl\u00e1ncot el\u0151sz\u00f6r numerikus karakterekre kell reduk\u00e1lni, majd val\u00f3s sz\u00e1mm\u00e1 alak\u00edtani.<\/p>\n\n\n\n<p>A karakterl\u00e1ncot a k\u00f6vetkez\u0151 k\u00e9plet megad\u00e1s\u00e1val cs\u00f6kkenthetj\u00fck <\/p>\n\n\n\n<p>                    <code><kbd>=LINKS(B9;8)<\/kbd><\/code><\/p>\n\n\n\n<p>Ennek hat\u00e1s\u00e1ra nyolc karakter ker\u00fcl \u00e1t a LEFT-b\u0151l, a t\u00f6bbi pedig t\u00f6rl\u0151dik.<\/p>\n\n\n\n<p>A val\u00f3s sz\u00e1mm\u00e1 val\u00f3 \u00e1talak\u00edt\u00e1s a k\u00f6vetkez\u0151vel val\u00f3 szorz\u00e1st okozza <kbd>1,0<\/kbd>ami a teljes k\u00e9plet:<\/p>\n\n\n\n<p>                    <kbd>=LEFT(B9;8)*1.0<\/kbd><\/p>\n\n\n\n<p>Most v\u00e1ltson a saj\u00e1t t\u00e1bl\u00e1zat\u00e1ra, v\u00e1lassza ki azt a mez\u0151t, amelyben a doll\u00e1r \u00e1rfolyam\u00e1t meg k\u00edv\u00e1nja jelen\u00edteni, \u00e9s kattintson a <em>Sum jel<\/em> kattints. Az \u00faj munkalapra val\u00f3 \u00e1tt\u00e9r\u00e9s ut\u00e1n jel\u00f6lje ki a k\u00edv\u00e1nt cell\u00e1t a - most m\u00e1r tiszta - doll\u00e1r\u00e1rfolyammal, \u00e9s nyomja meg a <kbd>Enter\/Return gomb<\/kbd> v\u00e9gleges\u00edteni. A doll\u00e1r \u00e1rfolyama most a k\u00edv\u00e1nt mez\u0151ben van. Ne felejtsen el menteni!<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aktualisierung_des_Inhalts\"><\/span>A tartalom friss\u00edt\u00e9se<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A f\u00e1jl k\u00f6vetkez\u0151 megnyit\u00e1sakor megjelenik egy ablak, amelyben a tartalom friss\u00edthet\u0151, \u00edgy a f\u00e1jl megnyit\u00e1sakor is az aktu\u00e1lis kurzus jelenik meg.<\/p>","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Olvas\u00e1si id\u0151<\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">percek<\/span><\/span>A Windows- \u00e9s Mac-felhaszn\u00e1l\u00f3k \u00e1ltal egyar\u00e1nt ismert Excel m\u00e1r r\u00e9g\u00f3ta k\u00edn\u00e1lja a webes tartalmak saj\u00e1t t\u00e1bl\u00e1zatokba t\u00f6rt\u00e9n\u0151 \u00e1tvitel\u00e9nek lehet\u0151s\u00e9g\u00e9t, b\u00e1r a csak bejelentkez\u00e9s ut\u00e1n el\u00e9rhet\u0151 weboldalakon tal\u00e1lhat\u00f3 adatok nem h\u00edvhat\u00f3k le. Az elj\u00e1r\u00e1s Windows \u00e9s Mac OS alatt kiss\u00e9 elt\u00e9r\u0151. A Mac OS-re k\u00e9sz\u00fclt Excel 2016-ot itt ismertetj\u00fck. Az Excel telep\u00edt\u00e9sekor a f\u00e1jlokat a felhaszn\u00e1l\u00f3i mapp\u00e1ban hozza l\u00e9tre...&nbsp;<a href=\"https:\/\/csiag.eu\/hu\/blog\/2022\/06\/27\/aktuellen-waehrungskurs-in-excel-importieren\/\" rel=\"bookmark\">Olvass tov\u00e1bb \"<span class=\"screen-reader-text\">Aktu\u00e1lis \u00e1rfolyam import\u00e1l\u00e1sa Excelbe<\/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\/hu\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":0,"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"wp:attachment":[{"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csiag.eu\/hu\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}