I want to get a range of links in a spreadsheet and display the link destination.

Asked 2 years ago, Updated 2 years ago, 108 views

"6. Getting tags on articles" in this article doesn't work

Scraped with SpreadSheet.Importxml and other useful functions 9+1-Qiita
https://qiita.com/ktmg/items/d53440c913e20f8bb34c#6-%E8%A8%98%E4%BA%8B%E3%81%AB%E3%81%A4%E3%81%91%E3%82%89%E3%82%8C%E3%81%9F%E3%82%BF%E3%82%B0%E3%81% AE%E5%8F%96%E5%BE%97f4

The situation is
A1 can display 25 links to A25 with =IMPORTXML() =IMPORTXML(A1:A25,XPath)) in B1 reflects only the first (A1)

I would like it to be reflected in B2 to B25, but it doesn't work.
I thought the XPath after A2 was different, so I checked it, but it was correct.

web-scraping xpath

2022-09-30 11:24

1 Answers

Enter the expression =IMPORTXML(A1,XPath)) in B1 and copy B1.
Then choose B25 from B2 and paste it.

Then, since B2 will have expressions such as =IMPORTXML(A2,XPath)) and B3 will have expressions such as =IMPORTXML(A3,XPath)), will the tag be displayed from B2 to B25?


2022-09-30 11:24

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.