Can't get toExcel function to work

Suite and Optimus Suite 5

gabbian0 June 18, 2013, 9:19am #1

I’m trying to use PHP package to export a grid into Excel, but after clicking the page is being executed but nothing happens after that.
I activated debug, every time i fire toExcel functions, two files are created into codebase folder, for example:
debug_2013_06_18__10_11_08.xml (see example)
phpCA9C.tmp (empty)

Here is some other clues:

toPdf function works good in the same page;
online app works good (dhtmlxgrid.appspot.com/export/excel);

Here is my includes:

<link rel="STYLESHEET" type="text/css" href="/js/dhtmlx/dhtmlxGrid/codebase/dhtmlxgrid.css">
<link rel="stylesheet" type="text/css" href="/js/dhtmlx/dhtmlxGrid/codebase/skins/dhtmlxgrid_dhx_skyblue.css">
<script  src="/js/dhtmlx/dhtmlxGrid/codebase/dhtmlxcommon.js"></script>
<script  src="/js/dhtmlx/dhtmlxGrid/codebase/dhtmlxgrid.js"></script>        
<script  src="/js/dhtmlx/dhtmlxGrid/codebase/dhtmlxgridcell.js"></script>    
<script  src="/js/dhtmlx/dhtmlxGrid/codebase/ext/dhtmlxgrid_start.js"></script>
<script  src="/js/dhtmlx/dhtmlxGrid/codebase/ext/dhtmlxgrid_export.js"></script>

Here is my grid init:

<script>	
	var mygrid;
	function doInitGrid(){
		mygrid = new dhtmlXGridObject('mygrid_container');
		mygrid.setImagePath("/js/dhtmlx/dhtmlxGrid/codebase/imgs/");
		mygrid.setHeader("QTA',MARCA,CODICE,DESCRIZIONE,INCASSO,ORD,GCZ,DSP,IMP");
		mygrid.setInitWidthsP("5,10,10,*,10,5,5,5,5");
		mygrid.setColAlign("right,left,left,left,right,right,right,right,right");
		mygrid.setColSorting("int,str,str,str,int,int,int,int,int");
		mygrid.setColTypes("ro,rotxt,rotxt,rotxt,ro,ro,ro,ro,ro")
		mygrid.setSkin("dhx_skyblue");
		mygrid.init();
	}
</script>

debug_2013_06_18__10_11_08.xml content:

<rows profile='color'><head><columns><column width='47' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[QTA']]></column><column width='96' align='left' type='ed' hidden='false' sort='str' color=''><![CDATA[MARCA]]></column><column width='95' align='left' type='ed' hidden='false' sort='str' color=''><![CDATA[CODICE]]></column><column width='431' align='left' type='ed' hidden='false' sort='str' color=''><![CDATA[DESCRIZIONE]]></column><column width='96' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[INCASSO]]></column><column width='48' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[ORD]]></column><column width='47' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[GCZ]]></column><column width='48' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[DSP]]></column><column width='48' align='right' type='ed' hidden='false' sort='int' color=''><![CDATA[IMP]]></column></columns></head> <row><cell><![CDATA[5]]></cell><cell><![CDATA[AREXONS]]></cell><cell><![CDATA[8010]]></cell><cell><![CDATA[ROLIN ALUX L 1 (ROSSO)]]></cell><cell><![CDATA[26.85]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[115]]></cell><cell><![CDATA[115]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[4]]></cell><cell><![CDATA[SHELL]]></cell><cell><![CDATA[55952643]]></cell><cell><![CDATA[SHELL HELIX HX7 10W40 LT. 1]]></cell><cell><![CDATA[28.1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[74]]></cell><cell><![CDATA[74]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[2]]></cell><cell><![CDATA[DICRA]]></cell><cell><![CDATA[9331201]]></cell><cell><![CDATA[LAMPADA 12V ASIMMETRICA]]></cell><cell><![CDATA[4.13]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[41]]></cell><cell><![CDATA[41]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[CHAMPION]]></cell><cell><![CDATA[F105/606]]></cell><cell><![CDATA[Filtro Olio]]></cell><cell><![CDATA[6.61]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[JAPANPARTS]]></cell><cell><![CDATA[FA-615S]]></cell><cell><![CDATA[F. ARIA PIAGGIO PORTER Furgonato 1.3 i 16V]]></cell><cell><![CDATA[7.02]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[TECNOCAR]]></cell><cell><![CDATA[R317]]></cell><cell><![CDATA[F.OLIO ASCONA / CORSA]]></cell><cell><![CDATA[4.13]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[REPKIT]]></cell><cell><![CDATA[RKB1749]]></cell><cell><![CDATA[kit ruota]]></cell><cell><![CDATA[33.06]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[TECNOCAR]]></cell><cell><![CDATA[RN236]]></cell><cell><![CDATA[F.GASOLIO CITROEN C3 PLURIEL 1.4 XSARA]]></cell><cell><![CDATA[23.97]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[5]]></cell><cell><![CDATA[5]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[AREXONS]]></cell><cell><![CDATA[8453]]></cell><cell><![CDATA[STARTER SPRAY ML 200]]></cell><cell><![CDATA[7.02]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[15]]></cell><cell><![CDATA[15]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[TRW]]></cell><cell><![CDATA[GDB980]]></cell><cell><![CDATA[DAIHATSU F20 02/77-03/84]]></cell><cell><![CDATA[37.19]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[CHAMPION]]></cell><cell><![CDATA[XE519/606]]></cell><cell><![CDATA[Filtro Olio OPEL Agila, Astra (G), Corsa (B), Corsa (C)]]></cell><cell><![CDATA[4.96]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[11]]></cell><cell><![CDATA[11]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[PLUS LUBE]]></cell><cell><![CDATA[0015-0510]]></cell><cell><![CDATA[PLUS LUBE HYDROL 68 4X5LT]]></cell><cell><![CDATA[18.18]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[11]]></cell><cell><![CDATA[11]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[REPKIT]]></cell><cell><![CDATA[RKT9026]]></cell><cell><![CDATA[Puleggia smorzatrice]]></cell><cell><![CDATA[49.59]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[AUTOGAMMA]]></cell><cell><![CDATA[VE14592]]></cell><cell><![CDATA[INTERR. PRESS. OLIO OPEL AGILA-CORSA]]></cell><cell><![CDATA[5.37]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[TECNOCAR]]></cell><cell><![CDATA[RN234]]></cell><cell><![CDATA[F.GASOLIO IVECO DAILY]]></cell><cell><![CDATA[9.92]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[ERG]]></cell><cell><![CDATA[0030]]></cell><cell><![CDATA[HD MULTI FM20W50]]></cell><cell><![CDATA[4.13]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[5]]></cell><cell><![CDATA[5]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[WALKER]]></cell><cell><![CDATA[70308]]></cell><cell><![CDATA[Silenz term OPEL CORSA B (Aluminox)]]></cell><cell><![CDATA[29.75]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell></row> <row><cell><![CDATA[1]]></cell><cell><![CDATA[ERG]]></cell><cell><![CDATA[177759]]></cell><cell><![CDATA[SINTHRON 10W40 B/D 4 LITRI]]></cell><cell><![CDATA[17.77]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[48]]></cell><cell><![CDATA[48]]></cell><cell><![CDATA[0]]></cell></row></rows>

Any clue?

radyno June 18, 2013, 12:41pm #2

Hi,
your xml was exported at local machine correctly.
Please try to update grid-excel-php from here:
download/file.php?id=6473

gabbian0 June 19, 2013, 9:18am #3

I update the file you provided (dhtmlxgrid_export.js), it was in dhtmlxGrid/codebase/ext folder, it is right? However, i updated it but the issue remain the same, empty .tmp file and debug file with a xml-excel content…

gabbian0 June 21, 2013, 7:15am #4

If this can be of any help to other users, i solved the issue setting

public $outputType = 'Excel2003' instead of Excel2007 in gridExcelGenerator.php file.