{"id":683,"date":"2020-03-07T21:24:11","date_gmt":"2020-03-07T13:24:11","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=683"},"modified":"2020-03-08T08:01:01","modified_gmt":"2020-03-08T00:01:01","slug":"excel%e5%ae%9e%e7%8e%b0%e7%bf%bb%e8%af%91%e5%87%bd%e6%95%b0filterxml%ef%bc%88%ef%bc%89%ef%bc%8cwebservice%ef%bc%88%ef%bc%89","status":"publish","type":"post","link":"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=683","title":{"rendered":"Excel\u5b9e\u73b0\u7ffb\u8bd1&#8211;\u51fd\u6570filterxml\uff08\uff09\uff0cwebservice\uff08\uff09"},"content":{"rendered":"<p>=IFERROR(FILTERXML(WEBSERVICE(&#8220;http:\/\/fanyi.youdao.com\/translate?&amp;i=&#8221;&amp;A1&amp;&#8221;&amp;doctype=xml&amp;version&#8221;),&#8221;\/\/translation&#8221;),&#8221;&#8221;)<\/p>\n\n\n\n<p>\u5728A1\u5355\u5143\u683c\u653e\u7f6e\u8981\u7ffb\u8bd1\u7684\u8bcd\uff08\u82f1\u6587\u4e2d\u6587\u5747\u53ef\uff09\uff0cB2\u5355\u5143\u683c\u8f93\u5165\u4e0a\u8ff0\u4ee3\u7801\uff0c\u5373\u53ef\u5f97\u5230\u7ffb\u8bd1\u7ed3\u679c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/cnliutz.uicp.io\/wp-content\/uploads\/2020\/03\/image-1024x576.png\" alt=\"\" class=\"wp-image-686\" srcset=\"http:\/\/g1n29wqq.ipyingshe.net:5347\/wp-content\/uploads\/2020\/03\/image-1024x576.png 1024w, http:\/\/g1n29wqq.ipyingshe.net:5347\/wp-content\/uploads\/2020\/03\/image-300x169.png 300w, http:\/\/g1n29wqq.ipyingshe.net:5347\/wp-content\/uploads\/2020\/03\/image-768x432.png 768w, http:\/\/g1n29wqq.ipyingshe.net:5347\/wp-content\/uploads\/2020\/03\/image-1536x864.png 1536w, http:\/\/g1n29wqq.ipyingshe.net:5347\/wp-content\/uploads\/2020\/03\/image.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-file\"><a href=\"http:\/\/cnliutz.uicp.io\/wp-content\/uploads\/2020\/03\/fanyi.xlsx\">\u7ffb\u8bd1excel\u6587\u4ef6<\/a><a href=\"http:\/\/cnliutz.uicp.io\/wp-content\/uploads\/2020\/03\/fanyi.xlsx\" class=\"wp-block-file__button\" download>\u4e0b\u8f7d<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5728A1\u5355\u5143\u683c\u653e\u7f6e\u8981\u7ffb\u8bd1\u7684\u8bcd\uff08\u82f1\u6587\u4e2d\u6587\u5747\u53ef\uff09\uff0cB2\u5355\u5143\u683c\u8f93\u5165\u4e0a\u8ff0\u4ee3\u7801\uff0c\u5373\u53ef\u5f97\u5230\u7ffb\u8bd1 <span class=\"readmore\"><a href=\"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=683\">Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,6],"tags":[],"class_list":["post-683","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-6"],"_links":{"self":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=683"}],"version-history":[{"count":4,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions"}],"predecessor-version":[{"id":692,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions\/692"}],"wp:attachment":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}