diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/func_webservice.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_webservice.xhp | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_webservice.xhp b/helpcontent2/source/text/scalc/01/func_webservice.xhp new file mode 100644 index 000000000..cd1df5c87 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_webservice.xhp @@ -0,0 +1,82 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- +* This file is part of the LibreOffice project. +* +* This Source Code Form is subject to the terms of the Mozilla Public +* License, v. 2.0. If a copy of the MPL was not distributed with this +* file, You can obtain one at http://mozilla.org/MPL/2.0/. +* +--> +<helpdocument version="1.0"> + <meta> + <topic id="textscalc01func_webservice" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">URI Functions</title> + <filename>/text/scalc/01/func_webservice.xhp</filename> + </topic> + </meta> + <body> + <section id="webservice"> + <bookmark xml-lang="en-US" branch="index" id="bm_id3149012"> + <bookmark_value>WEBSERVICE function</bookmark_value> + </bookmark> + <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEBSERVICE" id="bm_id3150028" localize="false"/> + <section id="webservicefuncheader"> + <h2 id="hd_id3149012"><variable id="webservicefuncname"><link href="text/scalc/01/func_webservice.xhp#webservice" name="webservice">WEBSERVICE</link></variable></h2> + <paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp + hid="HID_FUNC_WEBSERVICE">Get some web content from a URI.</ahelp></paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph role="code" id="par_id3154844" xml-lang="en-US">WEBSERVICE(URI)</paragraph> + <paragraph role="paragraph" id="par_id3147469" xml-lang="en-US"><emph>URI: </emph> URI text of the web service.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph role="paragraph" id="par_id3146142" xml-lang="en-US"><item type="input">=WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")</item></paragraph> + <paragraph role="paragraph" id="par_id3146143" xml-lang="en-US">Returns the web page content of "https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss".</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.WEBSERVICE</literal></paragraph> + </section> + <section id="filterxml"> + <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FILTERXML" id="bm_id2950028" localize="false"/> + <bookmark xml-lang="en-US" branch="index" id="bm_id2949012"> + <bookmark_value>FILTERXML function</bookmark_value> + </bookmark> + <section id="filterxmlfuncheader"> + <h2 id="hd_id2949012"><variable id="filterxmlfuncname"><link href="text/scalc/01/func_webservice.xhp#filterxml" name="filterxml">FILTERXML</link></variable></h2> + <paragraph role="paragraph" id="par_id2949893" xml-lang="en-US"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a XML document.</ahelp></paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph role="code" id="par_id2954844" xml-lang="en-US">FILTERXML(XML Document; XPath expression)</paragraph> + <paragraph role="paragraph" id="par_id2947469" xml-lang="en-US"><emph>XML Document (required):</emph> String containing a valid XML stream.</paragraph> + <paragraph role="paragraph" id="par_id2847469" xml-lang="en-US"><emph>XPath expression (required):</emph> String containing a valid XPath expression.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph role="paragraph" id="par_id2946142" xml-lang="en-US"><item type="input">=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")</item></paragraph> + <paragraph role="paragraph" id="par_id2946143" xml-lang="en-US"> Returns information on the last build date of the wiki.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341600873986703" localize="false"><literal>COM.MICROSOFT.FILTERXML</literal></paragraph> + </section> + <section id="encodeurl"> + <bookmark id="bm_id121517132649769" xml-lang="en-US" branch="hid/SC_HID_FUNC_ENCODEURL" localize="false"/> + <bookmark xml-lang="en-US" branch="index" id="bm_id811517136840444"> + <bookmark_value>ENCODEURL function</bookmark_value> + </bookmark> + <section id="encodeurlfuncheader"> + <h2 id="hd_id671517132649769"><variable id="encodeurlname"><link href="text/scalc/01/func_webservice.xhp#encodeurl" name="linkname">ENCODEURL</link></variable></h2> + <paragraph id="par_id51517132649769" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph> + </section> + <paragraph role="paragraph" id="par_id721517134647880" xml-lang="en-US">Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph role="code" id="par_id351517132879400" xml-lang="en-US">ENCODEURL(Text)</paragraph> + <paragraph role="paragraph" id="par_id921517132924079" xml-lang="en-US"><emph>Text</emph>: String to encode to a sequence of URL-standard symbols.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph role="paragraph" id="par_id651517132994921" xml-lang="en-US">If cell A1 contains the Cyrillic text "автомобиль", <item type="input">=ENCODEURL(A1)</item> returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word "автомобиль" means car in Russian).</paragraph> + <paragraph role="paragraph" id="par_id991517133057478" xml-lang="en-US">If cell B1 contains the text "車", <item type="input">=ENCODEURL(B1)</item> returns %E8%BB%8A ("車" means car in Japanese).</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id301640873986703" localize="false"><literal>COM.MICROSOFT.ENCODEURL</literal></paragraph> + </section> + </body> +</helpdocument> |