Recently, I had a task assigned and I can’t find a suitable solution to achieve the project. Maybe you guys could help me find the best way to do what I’d like to get.
We do have an Excel .xls file hosted locally that has automatic changes in cells, since it has an add-in binded. My colleague has it open all the time and never closes it.
We need to automatically (or by ctrls+s) push the data from specific cells to a WordPress page (with a table, not only values but the frames of the table too); every time a value change or every X minutes.
We basically need to set up this auto sync by selecting the cells we need to sync from excel to wordpress one time, and then it would automatically do the job every time they change or once every 5 minutes for example.
It thought about CData solution, but our WordPress is not on localhost, but on a cloud hosting. (flywheels)
It also thought about 2 plugins to achieva that, first SyncSheet to auto sync .xls to Google Sheets, then WP Table Manager to sync the Google Sheet cells to WordPress, but SyncSheet freezes the screen with a pop up everytime it does sync…
Is there any other solution?
Thank you very much in advance and have you all a nice day,