As for the Google grid to display a string from another site online?
Example: I need to be the domain of these website https://readmanga.me/rashititel_grobnic Display a row from a table (1-49) and a separate date of publication.
Example table:
Is it possible ?
Example table:
Is it possible ?
asked April 19th 20 at 12:28
1 answer
answered on
Solution
Use
If the link to the page in cell B1 the text "to read" available on the formula
Release year
The examples in the Table https://docs.google.com/spreadsheets/d/1MSw2YDCN2C...
IMPORTXMLIf the link to the page in cell B1 the text "to read" available on the formula
=INDEX(IMPORTXML(B1;"//h4/a");1;1)Release year
=INDEX(IMPORTXML(B1;"//span[@class="elem_year"]/a");1;1)The examples in the Table https://docs.google.com/spreadsheets/d/1MSw2YDCN2C...
Thank you very much. - Shanie.Eichmann63 commented on April 19th 20 at 12:33
Find more questions by tags Data transferGoogle SheetsHTML