I have been trying since long to extract data using xpath in google sheets but everytime 'am getting message 'imported content is empty'. i need help . The url is http://reports.ieso.ca/public/IntertieScheduleFlow/PUB_IntertieScheduleFlow.xml
Jump to Post
Hello unprecedented way
Your Probelm is handling namespace
to you shall define a namespace
and then start with XPath
from Google XML file
xmlns = "http://www.theIMO.com/schema"
So give to name as a parameter http://www.theIMO.com/schema
or as a variable
ns1 = "http://www.theIMO.com/schema"
I choose …
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.