Excel Export not working after upgrade to 2.2.6

QuestionsExcel Export not working after upgrade to 2.2.6
Michael Sheppard asked 2 years ago

I cannot export to excel with the new 2.2.6 version (which I noticed is now using PHPExcel_IOFactory instead of the older PHP-export class.
It writes garbage characters that can’t be opened by excel.
How can I fix-this to be able to export?
 
Thanks for any help.

Michael Sheppard replied 2 years ago

I added an ob_clean_end(); right before the output and that seemed to solve the issue for now.

I apologize for asking questions then finding the answer – but I hope it helps if anyone else has issues.

Thanks

Mike

———8save(‘php://output’);

Stanislav replied 1 year ago

Hi,

Seems like I have same issue. Michael could you please advice how to use this solution? I would like to try it for my case.
Thank you

4 Answers
Abu Ghufran Staff answered 2 years ago

Thanks for sharing.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Stanislav replied 1 year ago

Hi,

Seems like I have same issue. Abu, Michael could you please advice how to use this solution or maybe there was some updates on export function?

jorge D answered 3 months ago

Hello  Im having the same issue here, the export just creates an empty file, just after upgrade.Any sugested solution?

Abu Ghufran Staff answered 3 months ago

Are you able to produce same issue on demos > export as well?

Please share you code on gist to regenerate the sceanrio.

An alternate option (if works for you) is to move to old export library. For that rename lib/inc/excel/PHPExcel to “newPHPExcel

This will disable new library and use previous version.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Abu Ghufran Staff answered 3 months ago

Are you able to produce same issue on demos > export as well?

Please share you code on gist to regenerate the sceanrio.

An alternate option (if works for you) is to move to old export library. For that rename lib/inc/excel/PHPExcel to “newPHPExcel

This will disable new library and use previous version.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Your Answer

5 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!