Ask Your Question

Link dynamic data from website to Calc

asked 2019-05-25 00:12:27 +0200

Rainmanne gravatar image

updated 2019-05-25 00:13:20 +0200

I'm trying to link exchange rates from this page to a spreadsheet. I use it at work in Excel and it works fine. But it does not work in Libreoffice Calc for some reason. I tried to Sheet/Link to External Data but it does not insert a table. I also noticed Data/XMLSource but it's greyed out. I woonder if it's possible to do in Libreoffice at all.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-25 03:35:10 +0200

m.a.riosv gravatar image

I think it's possible with WEBSERVICE() and FILTERXML() functions working together.


Help about XPath expressions

Sample file to recover the data from mentioned web.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-25 00:12:27 +0200

Seen: 40 times

Last updated: May 25