Warm tip: This article is reproduced from stackoverflow.com, please click
import xml xpath

ImportXML for live exchange rates from Xe.com

发布于 2020-04-08 09:21:47

I'm trying to import specific currency exchange rates,i.e. JPY-USD, JPY-EUR,JPY-INR etc from XE.com into Google spreadsheets using Import XML. How can I figure out the x path that I need from XE.com's page source? Help would be greatly appreciated!

URL: http://www.xe.com/currency/jpy-japanese-yen?r=

Questioner
SGK
Viewed
92
分享
LuFFy 2017-03-29 14:47

Use IMPORTHTML instead : 

=IMPORTHTML ("http://www.xe.com/currency/xau-gold-ounce","table",1)

xe.com returns a table with the data which you could then use a HLOOKUP to only return the data for USD. Eg. :

=hlookup("USD",{IMPORThtML("http://www.xe.com/currency/xau-gold-ounce","table",1)},2,false)
SGK 2017-03-29 14:58:30

Thanks very much! Is there a way I can autoupdate this data?

LuFFy 2017-03-29 14:59:54

@SGK, Use Ajax to autoUpdate <div> using setInterval.

LuFFy 2017-03-29 15:39:50

@SGK Also Keep habbit of accepting and upvoting the answers if you find them useful. Thanks.

Related issues

1
Java project with Gradle in IntelliJ IDEA: cannot resolve symbol 'google' but project compiles
2
node js MODULE_NOT_FOUND error in node_modules
3
Python
4
Adding a module (Specifically pymorph) to Spyder (Python IDE)
5
Use type definitions from .d.ts file without importing
6
Importing JSON library into IntelliJ IDEA
7
Python Flask SQLAlchemy: Import app.db to /models/model.py is failing
8
Why import works in this ROS python script
9
How do I make a list of imported classes in Python?
10
VBA to import data from closed workbook and paste into specific worksheet as values