Ask Your Question
0

External data source with csv [closed]

asked 2013-12-12 17:17:40 +0100

PatrickH gravatar image

updated 2015-11-16 16:17:05 +0100

Alex Kemp gravatar image

Hi, I'm trying to create a calc sheet from a webservice. The webservice provides the data as CSV content. Downloading the result and then importing via Insert-> Table from File works just fine. However neither using the URL nor the downloaded file via Insert->link to external data works. I tried the same with MS Excel on a different computer, where this works. Any hints what can be done to get it to work with Libreoffice?
The URL is: http://www.gw2spidy.com/api/v0.9/csv/all-items/all
I'm on Libreoffice 4.1.3.2 (german).

Thanks
Patrick

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 16:17:22.958880

2 Answers

Sort by » oldest newest most voted
1

answered 2013-12-12 20:29:49 +0100

m.a.riosv gravatar image

Well I have done a try, and it works for me with Win7x64 Version 4.0.6.2, with Insert from file. Link to external data seems to need a html file.

I think the issue is that it seems doesn't work and some steps take a while.

How I did it?
- Menu/Insert/Sheet from file
- In address bar enter the path [enter]
- Wait for Open button.
- Click Open and wait, in my case near a minute.
- Window for set up the import appears.
- Ok
- Wait until you can mark link option.
- Ok

image description

edit flag offensive delete link more

Comments

if insert sheet only allowed to enter something .. no .. it needs a "hard" file on disk .. simply stupid .. if even microsoft managed to do it

eagle275 gravatar imageeagle275 ( 2018-09-18 20:53:28 +0100 )edit
0

answered 2013-12-12 18:11:38 +0100

Pedro gravatar image

Apparently it wont work with CSV. It expects a named table and CSV doesn't have named tables. If you open the CSV, and give a Name to the range (Insert > Names > Define) and save it as ODS (or XLS, etc) then you can use it as a source to Insert the Link in another file :)

But I think this defeats the utility of the External link...

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-12-12 17:17:40 +0100

Seen: 4,968 times

Last updated: Dec 12 '13