Updating an Excel document?

Question

PHP

I am being asked to do something like update an excel document in real time via php. That is, a person has an excel document open, and every second php parses prices from one site and transfers them to this excel document. Will the information be updated for the user who already has this document open, or will he have to reopen it?

Answer 1

You need to google the topic "How to share an Excel workbook". This is real. Then everything depends on the nuances - where the file is located, how it is accessed and ...

Answer 2

It is necessary to add macros to the document that will request the necessary information and update the document.

Answer 3

Better look towards google sheets api , it's more reliable