How to bind macro to excel in php?

Question

PHP

Hello. There is a task - to generate an excel file (one sheet) on the server, but with the addition of a macro. The macro analyzes this sheet and scatters the data on other sheets, it is ready.
The file is generated, there are no problems with this. The question is how to attach a macro to it that would run immediately after the document is unloaded (or even before)?
I am using phpexcel. But in general, all possible options are interesting.

Answer 1

You need to manually create an empty table already with a macro and save it as xlsm .
Then load it into phpExcel, fill it with data and save.
More details with an example of a working library can be found here: https ://dev.1c-bitrix.ru/support/forum/forum6/topi...
sheets on the server.