I would like to know some ideas to get the data from this link: link
I used the code below to try to extract the data. But when I enter with CSS what I want to extract, it returns the html nodes empty.
rm(list = ls())
#install.packages("rvest")
library(rvest)
url <- paste0("http://relatorios.aneel.gov.br/_layouts/xlviewer.aspx?id=/RelatoriosSAS/RelSAMPClasseConsNivel.xlsx&Source=http%3A%2F%2Frelatorios%2Eaneel%2Egov%2Ebr%2FRelatoriosSAS%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1")
#Reading the HTML code from the website
webpage <- read_html(url)
#Using CSS selectors to scrap the rankings section
rank_data_html <- html_nodes(webpage,'.cv-nwl')
I would like to emphasize that the site is not in the standard format we usually have for extracting data from the internet, ie html. It looks something like an application. Would anyone have an idea how to extract this data?