CODEWITHSUNDEEP
phpmysqlphpexcel
Anubhav Gupta
Anubhav Gupta

Reputation: 102

Generating/ Downloading Large Excel File - PhpExcel

I have a backend system a sort of inventory management. I want to simply download all my inventory to excel sheet. To accomplish this i have used PhpExcel as my system is built with php.

So far everything is working fine (No. of records were around 9 000). But since i have uploaded another 12 000 records into database system is causing issues while generating excel file.

Excel file:

The excel file which gets generated contains multiple worksheet (around 12 maybe). About 3 of then contains > 100k entries. Basically it depends on the number of records.

For example: Records = product & single product contains multiple attributes. So if i have 22 000 products and each product contains 10 attribute then i will have 22 0000 entries in attributes worksheet. As far as i am able to get this issue, i think these 3 worksheet related to attributes is causing issue.

What can I do to prevent this issue?

Upvotes: 0

Views: 1063

Answers (1)

Saurabh Sharma
Saurabh Sharma

Reputation: 450

try changing below configuration in your php.ini file

max_input_vars
max_execution_time
post_max_size

to higher values of your current configuration

Upvotes: 1

Related Questions