88 lines
7 KiB
XML
88 lines
7 KiB
XML
<?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">URI Functions</title>
|
|
<filename>/text/scalc/01/func_webservice.xhp</filename>
|
|
</topic>
|
|
</meta>
|
|
<body>
|
|
<section id="uri_functions">
|
|
<h1 id="hd_id391677019419915"><variable id="h1"><link href="text/scalc/01/func_webservice.xhp">URI Functions</link></variable></h1>
|
|
<paragraph id="par_id141677019419921" role="paragraph">These spreadsheet functions are used for inserting data from Universal Resource Identifiers (URI).</paragraph>
|
|
</section>
|
|
<section id="webservice">
|
|
<bookmark branch="index" id="bm_id3149012">
|
|
<bookmark_value>WEBSERVICE function</bookmark_value>
|
|
</bookmark>
|
|
<bookmark 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">WEBSERVICE</link></variable></h2>
|
|
<paragraph role="paragraph" id="par_id3149893"><ahelp hid="HID_FUNC_WEBSERVICE">Get some web content from a URI.</ahelp></paragraph>
|
|
</section>
|
|
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
|
|
<paragraph role="code" id="par_id3154844">WEBSERVICE(URI)</paragraph>
|
|
<paragraph role="paragraph" id="par_id3147469"><emph>URI: </emph> URI text of the web service.</paragraph>
|
|
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
|
|
<paragraph role="paragraph" id="par_id3146142"><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">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 branch="hid/SC_HID_FUNC_FILTERXML" id="bm_id2950028" localize="false"/>
|
|
<bookmark 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">FILTERXML</link></variable></h2>
|
|
<paragraph role="paragraph" id="par_id2949893"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a XML document.</ahelp></paragraph>
|
|
</section>
|
|
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
|
|
<paragraph role="code" id="par_id2954844">FILTERXML(XML Document; XPath expression)</paragraph>
|
|
<paragraph role="paragraph" id="par_id2947469"><emph>XML Document (required):</emph> String containing a valid XML stream.</paragraph>
|
|
<paragraph role="paragraph" id="par_id2847469"><emph>XPath expression (required):</emph> String containing a valid XPath expression.</paragraph>
|
|
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
|
|
<paragraph role="paragraph" id="par_id2946142"><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"> 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" branch="hid/SC_HID_FUNC_ENCODEURL" localize="false"/>
|
|
<bookmark 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">ENCODEURL</link></variable></h2>
|
|
<paragraph id="par_id51517132649769" role="paragraph"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph>
|
|
</section>
|
|
<paragraph role="paragraph" id="par_id721517134647880">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/ful_func.xhp#func_head_syntax"/>
|
|
<paragraph role="code" id="par_id351517132879400">ENCODEURL(Text)</paragraph>
|
|
<paragraph role="paragraph" id="par_id921517132924079"><emph>Text</emph>: String to encode to a sequence of URL-standard symbols.</paragraph>
|
|
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
|
|
<paragraph role="paragraph" id="par_id651517132994921">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">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>
|
|
<section id="relatedtopics">
|
|
<tip id="par_id781677019731175"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE">WEBSERVICE</link>, <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTERXML">FILTERXML</link>, <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ENCODEURL">ENCODEURL</link> wiki pages.</tip>
|
|
</section>
|
|
</body>
|
|
</helpdocument>
|