skip to Main Content

Html – Importxml errors with /div and [2] [3]

Importing using importxml code: =LET(list, IMPORTXML("https://www.officialcharts.com/charts/dance-singles-chart/20240212/104/", "//*[@id='__nuxt']/div[3]/div/main/div[2]/section/div/div/div/div/div/div[2]/p/a/span"), WRAPROWS(BYROW(list, LAMBDA(r, JOIN("", r))), 2)) The errors are to do with pulling unwanted text from column 1 chart positions NEW and Re get pulled in and causes table data to jump out of…

VIEW QUESTION
Back To Top
Search