I am trying to import several web pages into an Excel 2019 spreadsheet. I can import one page at a time using Power Query, but, I cannot get it to work on a table that contains several HTML links.
If you wish I can upload the Excel spreadsheet but I cannot see how to do that from the options on the Mrexcel screen.
In image 1 I can download the html data from file:///C:/Viking%20Family%20Htmls/591.html.
In image 2 I am trying to download html data from a table, but Power Query only downloads the URL e.g I am trying to get data from 591.html, 592.html, 587.html, 589.html etc. I can get the data if I do the import individually but it doesn't work for a table.
Image 3 shows the Power Query text when the "URL" function is invoked.
Image 4 has the table and the text.
Image 5 has the error message I get when I add a new Custom Column in Power Query.
If you wish I can upload the Excel spreadsheet but I cannot see how to do that from the options on the Mrexcel screen.
In image 1 I can download the html data from file:///C:/Viking%20Family%20Htmls/591.html.
In image 2 I am trying to download html data from a table, but Power Query only downloads the URL e.g I am trying to get data from 591.html, 592.html, 587.html, 589.html etc. I can get the data if I do the import individually but it doesn't work for a table.
Image 3 shows the Power Query text when the "URL" function is invoked.
Image 4 has the table and the text.
Image 5 has the error message I get when I add a new Custom Column in Power Query.
