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


Thanks for the example. I tried to follow your example but only able to get 1 cell works. Can you show me how to "extend" the range?

raiko gravatar imageraiko ( 2019-08-19 22:57:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 200 times

Last updated: May 25 '19