export to excel

[vuras]

Hi,  I was wondering about creating a button to export easyui datagrid to excel file. Is there a way?

[mzeddd]

Hi,

Check this https://github.com/PHPOffice/PHPExcel

It seems very friendly. I use it for couple of years already.

And yes, I have special "Excel" export button on my DataGrid and TreeGrid.

[vuras]

thanks, for your response and help. Maybe you could put me into right direction by showing one of your examples how to implement this plugin with easyui datagrid?

[mzeddd]

Lots of PHPExcel example could be found here: https://github.com/PHPOffice/PHPExcel/tree/develop/Examples

On client side I have the following code:

Code:

function myButtonClick(){
getFile('phpExcelTest.php',$("#myForm").serialize());
}

function getFile(address,parameters){
$.messager.progress({text:'Processing. Please wait...'});
$.post(address,
parameters,
function(data){
$.messager.progress('close');
if(isNaN(data)==false){
javascript:window.location='getFile.php?p='+data;
} else {
$.messager.alert('ERROR',data);
}
}
);
}

In my case PHP script generates/saves file and sends its integer ID back to getFile function.
If I get integet value than it is OK and I could call for already generated file ohtervise show message from PHP script.

If you 100% sure that your Excel file will be generated without any problems you can call for Excel file directly via "javascript:window.location=" for example