Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked 2018-06-24 11:36:36 +0200

Lupp gravatar image

How to use FILTERXML with local file?

LibreOffice Calc V6.0.4.2 on Win 10.

If I save the example xml content "books.xml" from this page to a local file I do not succeed with any formula I try using FILTERXML().

=FILTERXML("file:///C:/Users/MyID/folderpath/books.xml";"//book/year") or something using Xpath strings like /bookstore/book[1]/year only returns the #VALUE! error whether entered for array-evaluation or otherwise.

What's wrong with my formulae?