python - How to solve the problem when the browser is half stuck when exporting excel with more than 10,000 items?

Question

Business requirements sometimes require tens of thousands of items to be exported.
Can I use python to process it?? It’s too stuck.
What if I use python to process it?

Answer 1

Use export to completely explode phpexcel. phpexcel is recognized to be slow in performance
/q/101... I have answered this question. Please understand

Answer 2

Can be done using asynchronously.
For example, when the user clicks export, a queue for exporting excel is added the day after tomorrow. This is the "Exporting" status that the user sees.
When the queue is completed and the excel file is generated, the export is completed, and the user can download the excel

The user submits the export task->Adds the export queue in the background->The export queue is executed->The user clicks to download the exported file

Answer 3

10,000 items is not too much, but you cannot use PHPExcel because it is too slow and can easily burst the memory.
I have written one https://github.com/qpwoeiru96... , which is specially used for simple Excel export. You can use it.