Exporting to Excel not working for large grid

Suite and Optimus Suite 5
#1

I have been trying to make the export to Excel with a large grid (approximately 10k rows). The grid has pagination so I use use a callback to generate on the server-side.

The function is something like this:

function toExcel() {
   mygrid.clearAndLoad(xml, function(a,b,data){		
      mygrid.toExcel('<?php echo Configure::read('SERVER_NAME'); ?>/app/webroot/js/codebase/excel/server/generate.php');
   });  
}

I store the xml in a variable “xml” and I can ensure it is generated just fine.
I thought it was something regarding a timeout on the server as the Excel is being generated for smaller grids. I also tried increase the memory_limit and the timeout limits in the php.ini file or by using the ini_set function, both to no avail.

Does anyone have any hints on this?

#2

Hi,
unfortunately grid-excel-php doesn’t support exporting so big datasets.
Please, try to use the follow url for exporting to excel:
dhtmlxgrid.appspot.com/export/html

It’s online export service which generates html table and returns it into browser with excel extension. This file may be opened in excel.

#3

Thanks for the reply.

In fact it works. At least it has been working - although it take a lot of time - however it a specific network conditions it seems to have problems with timeout of the requests. If I can recall rightly, the grid uploaded by the client to the server and then the server processes it by performing the conversion and post the Excel file back to the client. It seems that if the request takes to long (the upload part) it is failing somehow.

I’ll have a look in this URL though it won’t work locally, will it?

#4

There is no way to run it at local server, it’s available only as service for now.

#5

Back to my first question, I know you said it is not supported, but given that it is working in some networks and not in others, would you have any considerations to make? I mean, it looks like there is a timeout in between when generating the xml and sending to the server. When the Excel file is generated is usually about 3MB.

Just as a hypothesis, do you think I could trigger the function on the client side invoking a server routine to generate the XML in the server’s memory, calling the generate function and only then posting it back to the client? (instead of generating the xml in the client and virtually loading in the grid and making use of the callback to use the server’s generate function)

#6

In other words, is there a way to load the grid in server’s memory?

#7

By the way, I tried using the web service but I got this error:

Error: Server Error

The server encountered an error and could not complete your request.
If the problem persists, please report your problem and mention this error message and the query that caused it.

I am actually using the line:

mygrid.toExcel("http://dhtmlxgrid.appspot.com/export/excel");
#8

Hi
there a way to export data directly from database using connector and grid-excel-php script.
Here is a demo with direct export to pdf. Export to excel is the same, you should only use gridExcelGenerator.php
direct_export.zip (1.02 MB)