Reloading Excel File

Help from Community
,
1

Hello,
I am trying to import day events from calendar into my display. In the process so far I am able to

  • Export calendar events as a .cvs file

  • Open it in excel and link it to outlook ( so when I add new event, it is added in the excel as well, this was a big moment for me :slight_smile: )

  • Now I want to add the excel to the display and reload capture the newly updated excel sheet with new events.
    I tried adding triggers but it doesn’t capture new values. How do I set the trigger and add the new file
    Thanks
    Vrunda

2

How would I do it:

use an selfwritten “API” in php,
host a php file at your webserver,
where you read your csv and return it as a xml,
to filter you could use GET variables.

This links could help you:
https://www.php.net/manual/en/function.fgetcsv.php
https://www.sanwebe.com/2013/08/creating-rss-feed-using-php-simplexml

1 Like