0
Hello, I come to ask for help regarding EXCEL and PHP; A little while I joined a company, where has a Dashboard made in VBA in EXCEL, however, I realized that it gives much problem. So I decided to develop a new Dashboard, remove from VBA and go to Browser(HTML5, PHP and Mysql because it has login and password system).
Dashboard in excel does the following:
- By pressing the green arrow he starts to do his functions
- With the SELENIUM extension, it automatically accesses the site, does the dowload of the spreadsheets in Excel and places the values on Dashboard
- Every 4 minutes it deletes everything that is in the dowload folder (where the files are downloaded) and does this whole procedure again, always updating the data;
Here is the image of Dashboard: https://prnt.sc/fhdemt
He prints the values on the screen everything cute, climbs the bar there where is the "Planned x Produced", calculates the percentage, etc...
I want to migrate all this to Browser, to PHP. I want it to do the same of his features. But how?! How to make PHP also access the site automatically, dowload and play everything on screen?
NOTE: I will use the same model of excel Dashboard, in the browser... Save the image in PNG and put in the browser and then play the information above? Or do the same Dashboard of 0?
I heartily thank those who help me!!! I’m picking up lots of fragments of codes of this type on the internet, but nothing concrete.
Thanks for the info Diego! Hugs
– Alexandre Amado