aideb
asked on
IMPORTXML from jscript
I am trying to use IMPORTXML to read in some values from this page
https://www.fundingcircle.com/loans/44801/auction
I am looking to collect the 'time left' as displayed on the page which is
attr('data-close-date');
within the jscript
Can anyone help?
https://www.fundingcircle.com/loans/44801/auction
I am looking to collect the 'time left' as displayed on the page which is
attr('data-close-date');
within the jscript
Can anyone help?
Can you post what you have so far, also is this page you are creating also on the same domain?
ASKER
Ah, sorry. I am doing this in a spreadsheet....
URL https://www.fundingcircle.com/loans/43037/auction
XPATH //tr
And then doing IMPORTXML(URL,XPATH)
I cannot get the correct XPATH to get the data I am looking for
URL https://www.fundingcircle.com/loans/43037/auction
XPATH //tr
And then doing IMPORTXML(URL,XPATH)
I cannot get the correct XPATH to get the data I am looking for
the xpath for what you are trying to do would be
//div[@data-close-date]
but I am not sure the page will resolve correctly. But you can try it :)
ASKER
Unfortunately it just gives me an error
can you attach your spreadsheet
ASKER
as requested (note, I have exported from google docs)
I do not see an attachment..
ASKER
I will try again!
Scraper.xlsx
Scraper.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No other comment was valid