I’m struggling getting data from the web to excel, as it isn’t detected as a table. There was a similar case reported (How to get data to excel from web that the data is not in a table?), but I have no idea what the solution proposed is, as there is very little information on how did the guy implement it.
I basically need to extract revenue from Euronext Website.
URL : https://live.euronext.com/fr/product/equities/FR0014005AC9-XPAR/company-information
The data I want is in red in this screenshot. Data to extract
It’s weird as the web preview in excel seems to be missing almost all the body of the website (see the image). Website preview
I’m comfortable with VBA, but I have no idea on how to interact with a website whatsoever. All ideas on how to overcome this issue are much appreciated !
I tried the Get data built in feature in excel, but it didn’t recognize the table.
Iñaki Vignal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.