{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"_xlfn.WEBSERVICE(\"https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml\")","v":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<gesmes:Envelope xmlns:gesmes=\"http://www.gesmes.org/xml/2002-08-01\" xmlns=\"http://www.ecb.int/vocabulary/2002-08-01/eurofxref\">\n\t<gesmes:subject>Reference rates</gesmes:subject>\n\t<gesmes:Sender>\n\t\t<gesmes:name>European Central Bank</gesmes:name>\n\t</gesmes:Sender>\n\t<Cube>\n\t\t<Cube time='2019-04-15'>\n\t\t\t<Cube currency='USD' rate='1.1313'/>\n\t\t\t<Cube currency='JPY' rate='126.66'/>\n\t\t\t<Cube currency='BGN' rate='1.9558'/>\n\t\t\t<Cube currency='CZK' rate='25.625'/>\n\t\t\t<Cube currency='DKK' rate='7.4639'/>\n\t\t\t<Cube currency='GBP' rate='0.86305'/>\n\t\t\t<Cube currency='HUF' rate='320.25'/>\n\t\t\t<Cube currency='PLN' rate='4.2742'/>\n\t\t\t<Cube currency='RON' rate='4.7618'/>\n\t\t\t<Cube currency='SEK' rate='10.4608'/>\n\t\t\t<Cube currency='CHF' rate='1.1345'/>\n\t\t\t<Cube currency='ISK' rate='135.60'/>\n\t\t\t<Cube currency='NOK' rate='9.6018'/>\n\t\t\t<Cube currency='HRK' rate='7.4360'/>\n\t\t\t<Cube currency='RUB' rate='72.7011'/>\n\t\t\t<Cube currency='TRY' rate='6.5637'/>\n\t\t\t<Cube currency='AUD' rate='1.5761'/>\n\t\t\t<Cube currency='BRL' rate='4.3985'/>\n\t\t\t<Cube currency='CAD' rate='1.5060'/>\n\t\t\t<Cube currency='CNY' rate='7.5867'/>\n\t\t\t<Cube currency='HKD' rate='8.8685'/>\n\t\t\t<Cube currency='IDR' rate='15906.08'/>\n\t\t\t<Cube currency='ILS' rate='4.0295'/>\n\t\t\t<Cube currency='INR' rate='78.5405'/>\n\t\t\t<Cube currency='KRW' rate='1281.37'/>\n\t\t\t<Cube currency='MXN' rate='21.2497'/>\n\t\t\t<Cube currency='MYR' rate='4.6573'/>\n\t\t\t<Cube currency='NZD' rate='1.6729'/>\n\t\t\t<Cube currency='PHP' rate='58.476'/>\n\t\t\t<Cube currency='SGD' rate='1.5299'/>\n\t\t\t<Cube currency='THB' rate='35.936'/>\n\t\t\t<Cube currency='ZAR' rate='15.8192'/>\n\t\t</Cube>\n\t</Cube>\n</gesmes:Envelope>"}]
[null,"La fórmula de la A1 seria =SERVICIOWEB(\"https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml\")"]
[]
[null,null,{"$f":"_xlfn.FILTERXML(B1,\"//Cube/@currency\")","v":"USD"},{"$f":"_xlfn.FILTERXML(B1,\"//Cube[2]/@currency\")","v":"JPY"}]
[null,null,{"$f":"_xlfn.FILTERXML(B1,\"//Cube/@rate\")","v":1.1313},{"$f":"_xlfn.FILTERXML(B1,\"//Cube[2]/@rate\")","v":126.66}]
[]
[]
[]
[]
[null,"La fórmula de USD =XMLFILTRO(B1;\"//Cube/@currency\")"]
[]
[null,"La fórmula del valor =XMLFILTRO(B1;\"//Cube/@rate\")"]
[]
[null,"Podemos cambiar entre valores:"]
[null,"Mediante =XMLFILTRO(B1;\"//Cube[2]/@currency\")"]
[]
[]
[null,"Observa que mediante XPATH accedemos al segundo elemento."]