Dashboard Production: constantly import Excel-file

Hi, i´m working on a dashboard which shows you the current situation in a fictional production. The Production figures, like the progress of an order, are written in an excel-file. I want the app to create graphics and charts based on the excel-file. The excel-file is updated like every minute, every time something happens in the production, for example a product completed.  How can i constantly import the data from the excel-file? So the charts and diagrams get updated every time the excel-file get updated?   Thanks for your help.
2 answers

You need a proper API if you want to do realtime dashboarding. In this case, would it not be better to display the graphs in excel itself? 

Anyway, in theory you could use the FileDocumentFromFile java action from the community commons module to import the excel file at regular intervals from a scheduled event into your app, and import the data into your database using the excel importer functionality.

You will however need to store the excel file in a location that is accessible by your Mendix application. This might prove difficult or easy depending on where you run your app.




thanks for your answer. 
Yes, it would be better and easier to display the graphs in excel. But the goal of my project is to devlop a dashboard in mendix for mobile devices, so you can see the necessary information everywhere. The production is fictional so we decided the data from the production is stored in an excel-file. The Mendix app will have access to this file at every time.


I will try to solve my problem with your Advice, thanks :)