Ask Your Question

Dynamic Web Queries using 'link to external data'

asked 2015-06-25 05:38:21 +0200

EnvoyMajeh gravatar image

updated 2016-03-09 21:11:29 +0200

Alex Kemp gravatar image

Is it possible to use a dynamic URL when creating a link to external data in libreoffice calc? I am currently trying to make a spreadsheet that will query a web page for tables, but I want the URL that the tables are generated from to be dynamic - based off what is entered into a specific cell. I have tried to reference a cell for the URL when using the 'link to external data' but it does not seem to work. Is there some other way to do this so that when I enter something into a cell it will automatically update the queried tables with the new URL?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-25 23:39:39 +0200

m.a.riosv gravatar image

I think what you are looking for are the WEBSERVICE() and FILTERXML() functions,

The help:

but there is a bug: fdo# 88257 XMLpath in FIlterxml does not work with arrayfunction

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-25 05:38:21 +0200

Seen: 1,574 times

Last updated: Jun 25 '15