Web
★ 12 · ◉ 14 · Excel 2013
=ENCODEURL()
The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.
=ENCODEURL(text)
External Data, Web & Cube
Web
★ 12 · ◉ 13 · Excel 2013
=FILTERXML()
The FILTERXML function returns specific data from XML content by using the specified xpath.
=FILTERXML(xml, xpath)
Text Manipulation
External Data, Web & Cube
Web
★ 15 · ◉ 10 · Excel 2013
=WEBSERVICE()
The WEBSERVICE function returns data from a web service on the Internet or Intranet.
=WEBSERVICE(url)
External Data, Web & Cube
Web
★ 15 · ◉ 9 · Microsoft 365
=PY()
PY function
=PY(python_code,return_type)
External Data, Web & Cube
Web
★ 15 · ◉ 8 · Microsoft 365
=IMPORTCSV()
IMPORTCSV function
=IMPORTCSV(path, [skip_rows], [take_rows], [locale])
External Data, Web & Cube
Web
★ 15 · ◉ 6 · Microsoft 365
=COPILOT()
COPILOT Function
External Data, Web & Cube
Web
★ 15 · ◉ 6 · Microsoft 365
=IMPORTTEXT()
IMPORTTEXT function
=IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])
External Data, Web & Cube