blob: d6ab6e78ece819838d3bc886bc2bf9a2a64b9021 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
<?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"/>
<paragraph role="heading" id="hd_id3149012" xml-lang="en-US" level="2">WEBSERVICE</paragraph>
<paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp hid="HID_FUNC_WEBSERVICE">Get some web content from a URI.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3146944" xml-lang="en-US" level="3">Syntax</paragraph>
<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>
<paragraph role="heading" id="hd_id3150141" xml-lang="en-US" level="3">Example</paragraph>
<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>
</section>
<section id="filterxml">
<paragraph role="heading" id="hd_id2949012" xml-lang="en-US" level="2"><bookmark xml-lang="en-US" branch="index" id="bm_id2949012"><bookmark_value>FILTERXML function</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FILTERXML" id="bm_id2950028" localize="false"/>FILTERXML</paragraph>
<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>
<paragraph role="heading" id="hd_id2946944" xml-lang="en-US" level="3">Syntax</paragraph>
<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>
<paragraph role="heading" id="hd_id2950141" xml-lang="en-US" level="3">Example</paragraph>
<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>
</section>
<section id="encodeurl">
<paragraph id="hd_id671517132649769" role="heading" level="2" xml-lang="en-US"><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>ENCODEURL function</paragraph>
<paragraph id="par_id51517132649769" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph>
<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>
<paragraph role="heading" id="hd_id351517132879400" level="2" xml-lang="en-US">Syntax</paragraph>
<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>
<paragraph role="heading" id="hd_id901517132933934" level="2" xml-lang="en-US">Example</paragraph>
<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>
</section>
</body>
</helpdocument>
|
