Read xlsx file on a web page after login

Hello everybody,

I was having fun using the multiscrape integration to get data from different webpages until I found out my electricity provider has interactive graphs which are not “scrapable” :frowning:. The only thing they provide is a xlsx file with all the information inside. Do you know if it possible to access data hidden in there automatically. This means, log into the portal, get the file and read it into a sensor.

Thank you!

How do I import excel 365 values one for each day?. ? maybe ?

Unfortunately all solution (as I suspected) propose to change data format. For me this is not possible as I have to read the xlsx file daily from the electricity provider.

It is going to have to be converted to something, unless you can look at an excel file and understand it natively.