Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results for importxml tagged with not importxml
Search options questions only
not deleted
0
votes
2
answers
146
views
IMPORTXML script not working: Outputs formula not the result
I'm trying to use IMPORTXML in a custom function by passing a ticker symbol so I can avoid retyping a long formula each time, when only the ticker symbol is changing. … that doesn't work without pasting and activating:
=IMPORTXML("https://finviz.com/quote.ashx? …
- 11
1
vote
0
answers
13
views
Retrieve URLs from website tables [duplicate]
The formulas IMPORTXML and IMPORTHTML only allow me to save the link titles (but not the URL)
=IMPORTHTML("https://www.cmfchile.cl/institucional/inc/dictamenes.php? … aa=2021", "table", 1)
=importxml("https://www.cmfchile.cl/institucional/inc/dictamenes.php? …
- 11
20
votes
3
answers
51k
views
How to import JSON data into a Google spreadsheet?
Google Sheets has an IMPORTXML function to import data from various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. …
- 4,522
0
votes
1
answer
1k
views
Formula Parse Error - unable to work out why
I'm trying to use the importxml function on Google Sheets on this page:
https://www.attheraces.com/racecard/Ayr/15-February-2022/1320
Essentially I want to import the "Forecast" bit that's down the page … I have been using this formula:
=importxml("https://www.attheraces.com/racecard/Ayr/15-February-2022/1320", "//*[@id="forecast"]/p[2]/strong")
here is a picture of the developer tools:
I assumed that …
- 3
0
votes
0
answers
38
views
How to extract contents of table in website into GOOGLESHEET?
=IMPORTXML("https://www.asugsvsummit.com/gsv-edtech-150","//*[@id="__next"]/main/div[3]/section[2]/div[3]/div[2]/div[3]") …
- 1
0
votes
0
answers
787
views
Extract data from web with Google script
I'm trying to use the function below (source) to avoid using importxml in Google Sheets:
function importRegex(url, regex_string) {
var html, content = '';
var response = UrlFetchApp.fetch(url); …
0
votes
1
answer
333
views
How can I import json from url using only existing formulas of google sheets (without script...
So whenever I'm trying to use IMPORTXML or IMPORTDATA it gives me error whatever parameters I was trying to pass there. … :
It's logical that IMPORTXML doesn't work since it's not xml that target url returns. …
0
votes
0
answers
305
views
How to separate direct sibling elements into different columns?
Importweb has the same behaiviour as Importxml but it doesn't return the Exceed maximum size error), but while trying to do the same for the stages I've encountered a problem: each name can have from 1 … Or should I combine the importxml with other formulas? …
2
votes
1
answer
3k
views
How to combine and consolidate rows from multiple sheets into one and sort them?
I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. …
- 4,522
1
vote
0
answers
197
views
How do I get my last played on a steam game from my profile
=REGEXEXTRACT(REGEXEXTRACT(CONCATENATE(IMPORTXML("http://steamcommunity.com/id/PerfectPlays/games/?tab=recent", "//script")),"Dota\s+2[^{]\d. …
0
votes
1
answer
253
views
ISNUMBER() - Shows for cell formatted as number FALSE
Issue:
Cell C1 fetches a number from a web page via IMPORTXML.
Cell B1 refers to it (=C1).
B1 and C1 are formatted as number and also display numbers. …
0
votes
0
answers
20
views
How to get an information of a webpage with google spreadsheets?
I'd already tryied to use the importxml function with the xpath of the object that contains the information, but without sucess. …
Matheus Detrans
1
vote
2
answers
122
views
Copying cell values to AVERAGE function
The importregex code is from here:
https://stackoverflow.com/questions/39014766/to-exceed-the-importxml-limit-on-google-spreadsheet
I tried
=AVERAGE(SPLIT(SUBSTITUTE(SUBSTITUTE(D4,""",""","""|""")," …
- 11
0
votes
2
answers
2k
views
gscript "getValue()" returns "#VALUE!" error
When I use importxml(myUrl, mypath) by itself, it works fine. This function returns text. The text is like $3,212.45. … However, when I do value(importxml(myUrl, mypath)) it works fine on the spreadsheet, but crashes in script.
If I do =value(SUBSTITUTE(importxml(MyUrl,MyXPath,"$","")) it also works fine. …
- 299
0
votes
1
answer
24
views
Grep links to Twitter from a web page
I am using this formula to get all link URLs from a website:
=importxml("http://centegix.com", "//@href")
How can I get only the URLs that point to Twitter? …
- 3