Weird characters shown in excel

Topics: User Forum
Dec 6, 2011 at 5:52 AM

My exporting to excel codes are working greatly with my localhost and test server but in production server it goes crazy.

Something like that:

     ÐÏࡱá;þÿ 
þÿÿÿþÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ » ÌÑB°=¼%r8X"1ܐCalibri1ܼCalibriàõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À à À à È “€ÿ’â8ÿÿÿÿÿÿÿÿÿÿÿÿ€€€€€€€€€ÀÀÀ€€€™™ÿ™3fÿÿÌÌÿÿffÿ€€fÌÌÌÿ€ÿÿÿÿÿÿ€€€€€ÿÌÿÌÿÿÌÿÌÿÿ™™Ìÿÿ™ÌÌ™ÿÿÌ™3fÿ3ÌÌ™ÌÿÌÿ™ÿfff™–––3f3™f333™3™3f33™333…é WorksheetÁÁgæ®ü£CihazImei_NoGsm_NoKampanyaActivation_Date Fatura_Tutari Temlik_Tutari » ÌÑ*+‚€Áƒ„&ffffffæ?'ffffffæ?(è?)è?¡"dXX333333Ó?333333Ó?U} } }  }  } } } } $ } $ } $ } $ }

$ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ } $ }   $ } !!$ } ""$ } ##$ } $$$ } %%$ } &&$ } ''$ } (($ } ))$ } **$  

 

I think something with my server configurations. I could not find anything. What can it be?

Coordinator
Dec 6, 2011 at 9:47 AM

Are those leading spaces before the ÐÏà characters in the output?

Dec 6, 2011 at 10:04 AM

As i see you answered this from stackoverflow too. I replied frome there. Added my file.

Dec 6, 2011 at 10:48 AM

Have you any idea about it?

Coordinator
Dec 6, 2011 at 10:59 AM

Only that the file you uploaded to SO was not generated by PHPExcel, because it contains information that PHPExcel does not write... writing the DocumentSummaryInformation and SummaryInformation streams is on the TO DO list, PHPExcel doesn't write them yet, but the file contains those streams

Dec 6, 2011 at 11:10 AM

I updated file can you check it again. I directly put it in server after generating from PHPExcel.

ehcp.vidizayn.com/temlik (15).xls

Coordinator
Dec 6, 2011 at 4:51 PM

Again, the file contains content that PHPExcel simply cannot write with the Excel5 Writer

Do you have any other xls scripts (Perl, Java, whatever) on the production server that might be generating that file .

Dec 7, 2011 at 7:23 AM

I can't give you direct address of generating excel but I generate it and put it in server. I guess because of this you think it is not generated by PHPExcel. 

This is the file which is generated by my test server:

ehcp.vidizayn.com/temlik (19).xls

 

Maybe you can find something with this