Large data set export into excel sheet

[megastream]

I have an issue with the large data set export into an excel sheet.  I am export 13k product into excel sheet using  blob = this.exportData({}); but it's not working properly it's working only for small data set. 

So please provide necessary solution regarding this

 blob = this.exportData({
                    url: "ajaxurl",
                    filename: JSON.stringify({
                        'filename': filename,
                        'ids': ids,
                        'groupIds': groupIds
                    }),
                    // render: true
                });
 if(typeof blob === "string"){ blob = new Blob([blob]);}
saveAs(filePath, exportedFileName);

[paramvir]

Please mention what issue are you facing.

[megastream]

it's not passing $_POST['pq_data'] value into API method so, it's not generating Xls file. but when I am trying with some of the selected row ex  1-100 records then it's working fine.

[paramvir]

In your first post your code is for local export:

Code: [Select]

saveAs(filePath, exportedFileName);

There is no need to pass $_POST['pq_data'] to the remote server in case of local export.

Example: https://paramquery.com/pro/demos/export_local

[megastream]

Thank you for your reply.

I am using the $_POST['pq_data']  variable under the API method for getting the selected row HTML which is using for generating an excel-sheet.

[paramvir]

PHP post variable size can be increased by php.ini configuration.

Anyway if you want to do any run time manipulation in generated Excel, it's better to do it in intermediate javascript worksheet rather than in your PHP scripts.