All Questions
Tagged with custom-function web-scraping
8 questions
0
votes
0
answers
87
views
Format imported table
I've been attempting to import a table of events from the following website: https://scpgajt.bluegolf.com/bluegolf/scpgajt23/schedule/index.htm?type=2&display=champ (and others similar in ...
0
votes
2
answers
496
views
Google Sheets, Web scrape Best Buy Price
im trying to figure out how to web scrape the price of a product into google sheets.
Before i would use =importrange(A1,B1)
And have A1 = https://www.bestbuy.com/site/asus-17-3-chromebook-intel-...
- 15
1
vote
1
answer
112
views
Google sheet web-scrape table within table
On this website, https://finance.yahoo.com/quote/ANZ.AX/financials - I am trying to extract the value for "Basic EPS" from the 2017 column, into cell J12 (google sheets).
I have the ANZ.AX ...
- 45
0
votes
1
answer
727
views
Trouble with regex in Google App Script getting a lot of garbage after the result
Using this Google App Script to get cryptocurrency prices from coinmarketcap:
( credit for this script goes to Josh Bradley via this stackoverflow topic: To exceed the ImportXML limit on Google ...
- 71
1
vote
1
answer
1k
views
Filter extracted data via ImportDATA
When trying to extract data from https://int.soccerway.com/ via ImportDATA, the spreadsheet sometimes returns a message saying that it exceeds the data limit.
What I would like to do is that instead ...
- 2,177
0
votes
1
answer
476
views
VBA: getHTML as custom function - Avoid several HTML retrivals
I am using this to retrieve HTML from a webpage
Function GetHTML(url As String) As String
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", url, False
.Send
GetHTML = ....
- 567
2
votes
2
answers
605
views
Import single value from a webpage/JSON into Google spreadsheet
There is a web page:
https://steexp.com/account/GDDHGJNRGR75ZQOXRD3FVGBTXS23JOIYYZX7ZNED7P4EQSNRR57MA54U
I'm trying to import the XLM Balance value (currently 4.9999897) into my Google spreadsheet . ...
10
votes
2
answers
27k
views
To exceed the ImportXML limit on Google Spreadsheet
I am stucking on a "scraping problem" right now. Especially i want to extract the name of the author from a webpage to google spreadsheet. Actually the function =IMPORTXML(A2,"//span[@class='author ...
- 111