Applescript version:
- Change "Kalender" to your calendars name
- Open a blank excel file
- Run the applescript
PHP/Google Charts version:
- set $accessToken in getData.php with MS Graph API accesstoken (use Graph API Explorer and extract token from random request header)
- run composer install
- run local php webserver: php -S localhost:8000
- open index.html
Open issues: Applescript - potential issues when event has multiple categories PHP - doesn't seem to consider series events