Ve sv\u011bt\u011b modern\u00edch kancel\u00e1\u0159sk\u00fdch n\u00e1stroj\u016f, jako jsou MS Excel a Google Tabulky, existuje mnoho funkcionalit, kter\u00e9 umo\u017e\u0148uj\u00ed efektivn\u00ed zpracov\u00e1n\u00ed r\u016fzn\u00fdch typ\u016f dat. Jednou z pokro\u010dil\u00fdch funkc\u00ed pro pr\u00e1ci s daty ve form\u00e1tu XML v MS Excel je funkce P\u0159\u00edklad syntaxe:<\/strong><\/p>\n Tento v\u00fdraz vr\u00e1t\u00ed pole jmen „Alice“ a „Bob“, kter\u00e9 jsou extrahov\u00e1ny z XML struktury.<\/p>\n P\u0159edstavte si, \u017ee m\u00e1te XML odpov\u011b\u010f z webov\u00e9 slu\u017eby obsahuj\u00edc\u00ed informace o po\u010das\u00ed. XML m\u016f\u017ee vypadat n\u00e1sledovn\u011b:<\/p>\n Chcete z\u00edskat hodnoty teploty a vlhkosti a um\u00edstit je do dvou bun\u011bk ve va\u0161em Excel dokumentu. Pou\u017eijete:<\/p>\n Kde M\u00e1te XML soubor se seznamem objedn\u00e1vek a ka\u017ed\u00e1 objedn\u00e1vka obsahuje n\u00e1zev produktu a mno\u017estv\u00ed. Nap\u0159\u00edklad:<\/p>\n Abyste z\u00edskali seznam mno\u017estv\u00ed pro ka\u017ed\u00fd produkt, pou\u017eijete:<\/p>\n T\u00edmto z\u00edsk\u00e1te pole s hodnotami „20“ a „50“, co\u017e zn\u00e1zorn\u00ed mno\u017estv\u00ed objednan\u00fdch produkt\u016f, kter\u00e9 lze dal\u0161\u00edmi funkcemi pou\u017e\u00edt pro dal\u0161\u00ed zpracov\u00e1n\u00ed nebo anal\u00fdzu.<\/p>\n Funkce Vr\u00e1t\u00ed specifick\u00e1 data z obsahu XML pomoc\u00ed zadan\u00e9ho v\u00fdrazu XPath<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[295],"tags":[],"class_list":["post-5571","post","type-post","status-publish","format-standard","hentry","category-webove"],"acf":[],"yoast_head":"\nFILTERXML<\/code>. Tato funkce umo\u017e\u0148uje extrahovat informace z XML textu na z\u00e1klad\u011b zadan\u00e9ho XPath v\u00fdrazu.<\/p>\nJak pou\u017e\u00edvat funkci ve sv\u00fdch projektech<\/h2>\n
FILTERXML(xml, xpath)<\/code> je funkce, kter\u00e1 p\u0159ij\u00edm\u00e1 dva argumenty: <\/p>\n\n
xml<\/code>: textov\u00fd \u0159et\u011bzec obsahuj\u00edc\u00ed XML data.<\/li>\nxpath<\/code>: textov\u00fd \u0159et\u011bzec XPath v\u00fdrazu pro v\u00fdb\u011br specifick\u00e9 \u010d\u00e1sti XML dokumentu.<\/li>\n<\/ul>\n=FILTERXML(\"<team><member>Alice<\/member><member>Bob<\/member><\/team>\", \"\/\/member\")<\/code><\/pre>\nPraktick\u00e9 vyu\u017eit\u00ed funkce v anal\u00fdze dat<\/h2>\n
P\u0159\u00edklad 1: Extrahov\u00e1n\u00ed dat z XML odpov\u011bdi<\/h3>\n
<weather> <location>Prague<\/location> <temperature>5<\/temperature> <humidity>80%<\/humidity> <\/weather><\/code><\/pre>\n=FILTERXML(xmlData, \"\/\/temperature\") =FILTERXML(xmlData, \"\/\/humidity\")<\/code><\/pre>\nxmlData<\/code> je bu\u0148ka s XML \u0159et\u011bzcem. Po pou\u017eit\u00ed funkc\u00ed dostanete v jedn\u00e9 bu\u0148ce hodnotu „5“ a v druh\u00e9 „80%“.<\/p>\nP\u0159\u00edklad 2: Zpracov\u00e1n\u00ed seznamu objedn\u00e1vek<\/h3>\n
<orders> <order><product>Tablet<\/product><quantity>20<\/quantity><\/order> <order><product>Smartphone<\/product><quantity>50<\/quantity><\/order> <\/orders><\/code><\/pre>\n=FILTERXML(xmlOrders, \"\/\/quantity\")<\/code><\/pre>\nZ\u00e1v\u011bre\u010dn\u00e9 pozn\u00e1mky<\/h2>\n
FILTERXML<\/code> v MS Excel je velmi u\u017eite\u010dn\u00fdm n\u00e1strojem pro ka\u017ed\u00e9ho, kdo pot\u0159ebuje pracovat s XML daty p\u0159\u00edmo v r\u00e1mci tabulkov\u00e9ho procesoru. Umo\u017e\u0148uje flexibiln\u00ed zp\u016fsob, jak extrahovat pot\u0159ebn\u00e9 informace pomoc\u00ed standardizovan\u00e9ho jazyka dotaz\u016f XPath. Kombinace s dal\u0161\u00edmi funkcemi, jako jsou textov\u00e9 funkce nebo funkce pro pr\u00e1ci s polem, dok\u00e1\u017ee vykouzlit siln\u00fd n\u00e1stroj pro pokro\u010dilou anal\u00fdzu dat.<\/p>\n","protected":false},"excerpt":{"rendered":"