Ask Your Question
0

How to use WEBSERVICE and FILTERXML calc functions?

asked 2016-03-11 10:59:05 +0100

Andrea Borruso gravatar image

updated 2016-03-11 11:05:33 +0100

Hi,

I'm using LibreOffice 5.1.1.3 (x64) and I would like to make a live import of a remote XML file. The URL is: http://www.comune.palermo.it/xmls/VIS...

I have written this formula, but calc import only the firs row.

=FILTERXML(WEBSERVICE("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml"),"/main/DATA_RECORD")

Is it normal? How to import all the output of the XPath query?

In gdrive sheet it works with:

=IMPORTXML("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml","/main/DATA_RECORD")

Thank you very much

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-04-07 00:41:50 +0100

m.a.riosv gravatar image

Sample_filterxlmArray.ods

Entered as array and calling every row, seems a workaround:

A3: ={FILTERXML(WEBSERVICE("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml");"//main/DATA_RECORD["&ROW()-3&"]")}
edit flag offensive delete link more
0

answered 2016-03-11 12:43:44 +0100

pierre-yves samyn gravatar image

Hi

There is a bug report about this.

m.a.riosv give an example to get an array.

Regards

edit flag offensive delete link more

Comments

Thank you. I have added my comment to the issue https://bugs.documentfoundation.org/s...

Andrea Borruso gravatar imageAndrea Borruso ( 2016-03-11 19:19:30 +0100 )edit
1

And I have reopened again the bug, because the function only return the first value when there are several.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-07 00:34:14 +0100 )edit

Thank you very much m.a.riosv

Andrea Borruso gravatar imageAndrea Borruso ( 2016-04-08 17:49:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-11 10:59:05 +0100

Seen: 2,533 times

Last updated: Apr 07 '16