Answer the question
In order to leave comments, you need to log in
What is the best way to generate large and complex Excel documents?
There is a need to create an Excel document in which there will be about 15 thousand commodity items.
All products are grouped with collapsible blocks, for each commodity item its image is inserted and then in the opposite columns the quantity for each day, movement (in/out) and price dynamics are displayed. The resulting document should look something like this:
The data is all in the database. The PHP script selects this data and generates a document. However, now the document is formed in about 15 minutes and eats up an astronomical amount of memory. I could implement all the specified functionality only with the help of the PHPExcel library.
However, I came up with the following thoughts - to create a document on the client machine. I.e:
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question