How to generate complex XLS in PHP?

Question

PHP

Hello. Can you please tell me how to implement in PHP the generation of a complex file with collapsible multi-level sections just like in this example? ndksale.ru/upload/price-2.xlsx
Ideally, there would be some kind of functionality that allows you to create a template or structure based on an existing file for further filling with data

Answer 1

Open this .xlsx as an archive. There xml lie. Open the file with content and look at the structure. There are many ways to work with xml in php.
https://habrahabr.ru/post/140352/

Answer 2

phpexcel

Answer 3

spout will be faster
https://github.com/box/spout