toExcel limitation for more than 3000 registers

Suite and Optimus Suite 5
#1

Hi,

I’m using mygrid.toExcel(…); for exporting the grid to Excel file. It’s working properly but for a limitated number of register. I can’t export more than 3000 registers.

Do you have a way to export grid results to an excel without limitations? is this method support for big amount of data?

Thanks!

#2

Hi.
One thing you can do to fix this - set maximum execution time in generate.php:

<?php
ini_set('max_execution_time', 300);
require_once 'gridExcelGenerator.php';
...

But this just give more time to the server to generate file. It doesn’t make generation process faster. Unfortunately there is no way to make exporting faster for big datasets.

#3

Hi Radyno,

Is any new solution now ??
#4

Hi,
There is no any new solution.