K
K
Kenguru77772019-11-25 12:19:56
Google Sheets
Kenguru7777, 2019-11-25 12:19:56

ImportXML multipage list?

Greetings!
There is a site: spravkaby.com/phones/mts/page/1 you need to select numbers from it.
I made this structure:

=IMPORTXML("http://spravkaby.com/phones/mts/page/1";"//div[1]/p")

Tell me, is it possible to select information from other pages automatically by changing the structure of the request somehow?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2019-11-26
@ProgrammerForever

There are pages like " spravkaby.com/phones/mts/page N "

={
IMPORTXML("http://spravkaby.com/phones/mts/page/1";"//div[1]/p");
IMPORTXML("http://spravkaby.com/phones/mts/page/2";"//div[1]/p");
IMPORTXML("http://spravkaby.com/phones/mts/page/3";"//div[1]/p")
}

etc.
But all the same it will rest against the size of the processed data. Or the number of requests per day. It's easier to make a parser on something else

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question