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
To add further to my earlie question ...the page source shows
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="http://reports.ieso.ca/docrefs/stylesheet/IntertieScheduleFlow_HTML_t1-2.xsl" ?><IMODocument docID="IntertieScheduleFlow" xmlns="http://www.theIMO.com/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.theIMO.com/schema http://reports.ieso.ca/docrefs/schema/IntertieScheduleFlow_r2.xsd">
<DocTitle>Intertie Schedule and Flow Report</DocTitle>
And i tried the following xpath
I would like to extract the value of Import 30 ;
I think i am clear in explaning my problem a bit in detail
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 the second path
so should be used with
// ns1: Export
all exports are found
now work with square brackets
You mean to say
url would be "http://www.theIMO.com/schema"
and Query path would be "// ns1: Export" (right?)
if you don't mind my google sheet url is
yes that's correctly define ns1
and then use
with // ns1: Export
38 entries found
I have the tool stylus used
and an XPath query started
and without namespace gets no result
to test create a local file on the hard disk
and the namespace xmlns = "http://www.theIMO.com/schema" remove
then test without namespace // Export
based on Example
// ns1: IMODocBody / ns1: IntertieZone  / ns1: schedules / ns1: Schedule / ns1: Export
Isn't it about time forums rewarded their contributors?
Contribute to this discussion and earn rewards points that can be cashed out for dollars.
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...
Hi. Im using vb 2010. I want to dynamically add textboxes to my form by clicking on a button. I've google searched and so far this code worked:
Private Sub btn_addline_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_addline.Click Dim txtB1 As New TextBox Dim i For i = ...