Ask Your Question
0

link/query to an online xls-file

asked 2020-08-10 15:44:24 +0100

Tresfjording gravatar image

Hi ... I have been looking and searching, but I couldn't find how to link an online xls or xlsx file, such as the Query-method in Excel, to a locally stored Calc spreadsheet. Is this even possible in LibreOffice?

In advance thanks!

rgs Tresfjording

edit retag flag offensive close merge delete

Comments

May be Sheet -> Link to External Data... is what you are looking for.

Opaque gravatar imageOpaque ( 2020-08-10 17:40:25 +0100 )edit

Seems like it, but when I insert the URL to the xls file, all options are still greyed out. The URL is: https://www.nordpoolgroup.com/globala...

Your suggestion asks for a server address. I just have the URL.

Tresfjording gravatar imageTresfjording ( 2020-08-11 00:35:47 +0100 )edit

Your suggestion asks for a server address. I just have the URL.

No it doesn't - why should it ask for a server address, if the URL already contains the server address (www.nordpoolgroup.comis the server address with IP address 23.100.1.29)? And your URL works perfectly for me.


May be you missed one thing: If you have entered the URL into the URL box you need to press ENTERbefore leaving the URL box. Then you get (after a while):

image description

Just selcet OK

and finally

image description

(I get a Elspot Prices in NOK/MWh Table, when selecting HTML_1 from the selection list)

BTW: The file is a fake .xls file - in fact it is an HTML table.

Opaque gravatar imageOpaque ( 2020-08-11 12:03:17 +0100 )edit

2 Answers

Sort by » oldest newest most voted
2

answered 2020-08-11 18:53:33 +0100

Opaque gravatar image

For the records (according to OPs last comment)

Use Sheet -> Link to External Data... and provide the URL in the URL of External Data Source field. Please be aware that you need to press ENTER before you leave the URL input field (the OK button gets active only after you have selected the table from the Available Tables/Ranges pane.

For examples of the dialog appearing - see my comment above.

edit flag offensive delete link more
0

answered 2020-08-11 18:39:06 +0100

Tresfjording gravatar image

Hi Opaque ... Thanks for your excellent description! I didn't think of tapping ENTER when there is an OK-button present. It works fine now.

I am new to Linux. Installed it a few days ago. Been a Microsoft user since mid eighties.

edit flag offensive delete link more

Comments

Please do not post an answer on this site, if you actually don't answer a question (in this case your own question, but providing a comment. On this site answers are reserved for solutions to a question. BTW: That why I commented until I was sure that this solves your problem.

Opaque gravatar imageOpaque ( 2020-08-11 18:56:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-10 15:44:24 +0100

Seen: 43 times

Last updated: Aug 11 '20