Pimoroni Enviro pHAT to O365 Excel Logger

Why I built it

I built the app already for using Google Drive Sheets as "storage". I wanted to learn how to use the Microsoft ecosystem, for e.g. Microsoft Graph API, to handle the same task.

Keep things simple

This simple script does not more as it have to do. I use the diagram feature of Excel Online to generate some nice looking graphs. There is no magic behind it.

There is also no refresh token source or local storage of credentials. This is, as I said, a working concept for further projects in this area of IoT.

Lesson learned

It seems that the Microsoft Graph required a work or school O365 account (Azure Active Directory user).

The temperature sensor sits just a few centimeters above the Pi's CPU. That means. The temperature measurements are always way too hot. and should be only used as indicator for trends, not for actual values.