python - How to solve the problem when the browser is half stuck when exporting excel with more than 10,000 items?
習慣沉默2017-06-14 10:49:44
0
13
2003
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?
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
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.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Use export to completely explode phpexcel. phpexcel is recognized to be slow in performance/q/101... I have answered this question. Please understand
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 file10,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.