Ask Your Question

Replicate ImportHtml function of google sheets in calc.

asked 2016-10-14 09:20:39 +0100

evileyeball gravatar image

updated 2016-10-14 10:07:16 +0100

Hello all. I have an issue i'm struggling with. I have a spreadsheet with a list of Magic The Gatherimg cards What I want is to scrape live price data at some interval from the web. I accomplished this easily be in Google sheets (see test file )

But my actual sheet uses other things that make using google sheets to house it impractical

I tried my damnedest to get web service and filterxml to pull me the data I want but had no luck Maybe one of you gurus knows how to pull this off. In the case that webservice and filter xml can't do this I'm not apposed to learning macros to do this

I haven't ever dealt with macros in libre but if that's what it takes I'm down to learn

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-10-17 14:26:18 +0100

erAck gravatar image

updated 2016-10-17 14:26:41 +0100

Maybe menu Sheet - Insert Sheet From File... or Sheet - Link to External Data... is what you are looking for.

edit flag offensive delete link more


In theory yes, but no table can be retrieved properly from the link

m.a.riosv gravatar imagem.a.riosv ( 2016-10-17 23:57:38 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-14 09:20:39 +0100

Seen: 281 times

Last updated: Oct 17 '16