Incorrect excel response with doctrine select about excelbundle HOT 11 CLOSED

Hi, I think that there are some missing information between the findOneById and the way you create xls.
IMHO there's a bug in your code, try to add some try and catch or log line by line.
Let me know

from excelbundle.

Hi, i wrapped the repository call into an try/catch block but there are no errors or warnings.

I pulled my code to pastebin:
http://pastebin.com/7E0WbJXP

I don't do anything with the Object i retrieved from Database.
But if i comment the try/catch block everything work as expected.

from excelbundle.

You paste the code, without Exception,
echo the exception

from excelbundle.

I'm going to close this ticket because is not related to ExcelBundle

from excelbundle.

Hi

"You paste the code, without Exception,
echo the exception"

• pelase look in pastebin on line 9

I think it is related to your ExcelBundle because if i use the StreamWriter to Save the File to the Filesystem and Download it with Filezilla or direct Link everything is alright.

This Problem only appears with the direct Response.

from excelbundle.

hi, please could you pastebin the exception please.

from excelbundle.

The Strange thing is that there is no Exception!

i get the correct result object back from Doctrine but the Excel Response is damaged (Image from 1 Post).

If i comment the doctrine action the Excel Response works perfect.

My problem is that i don't know if it is an Doctrine problem or an ExcelBundle problem, cause everything else works fine i thought it could be an ExcelBundle problem.

I uploaded one of the damaged excel files to my googl drive with following link you can download it:
https://docs.google.com/open?id=0B-ePhomTc6A2WmNKS2Z0Wklqd3M

from excelbundle.

I think that you don't see the exc because your Response is redirect into the xls file.
put a die() and you'll see the problem.

Divide et impera.
First split the function in different functionS.
Then, remove the Excel part and go there with debug = true.

from excelbundle.

The only Exception i get wenn i remove the direct response is that i had to return a Response Object instead of null.
The WebProfiler shows no other exceptions or anything else.

from excelbundle.

I solved my problem with saving the excel file to disk, create an redirect response to another route where i read this excel file with the file class, generate response headers and return the content via fpassthru().

It seems that my doctrine connection modifies the response object in a way that i couldn't change the response headers manualy. Maybe its cause i use multiple doctrine managers, i had no idea.

But at all thank you for this bundle and your time to help me.

from excelbundle.

wow thanks this is still really strange ...

from excelbundle.