Unreadable PHPExcel Content

I make a .xlsx file and send it by email. But when I received the file in my letter. He says "unreadable content" and tries to restore it. When I restored it, the file will be complete and intact. Nothing is missing. But I do not want this error window to appear.

I use this line of code because php_zip is not enabled on my server, so I have to use this. Without this, I get an error that says that ZipArchive is missing or something like that.

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP); 

And finally, this is my function to make an excel file:

 $objPHPExcel = new PHPExcel(); $counter = -1; $counterEmpty = 0; foreach($user_notifications as $mode => $arrayRawData){ if(!empty($arrayRawData)){ if($counter != -1) {$objPHPExcel->createSheet();} $Header = "A"; $Header2 = "A"; $HeaderCol = 1; $counter++; $counterEmpty++; foreach($arrayRawData as $HwKeyColumn => $arrayHwData){ $objPHPExcel->setActiveSheetIndex($counter) -> setCellValue($Header2 . $HeaderCol , $HwKeyColumn); $objPHPExcel->getActiveSheet()->setTitle($mode); $Header2++; } foreach($arrayRawData as $HwKeyColumn => $arrayHwData){ $HeaderCol2 = $HeaderCol; foreach($arrayHwData as $id => $value){ $HeaderCol2++; $objPHPExcel->setActiveSheetIndex($counter) -> setCellValue($Header . $HeaderCol2,$value); } $Header++; } } } if($counterEmpty==0) { $Header2 = "A"; $HeaderCol = 1; $objPHPExcel->setActiveSheetIndex(0) -> setCellValue($Header2 . $HeaderCol, 'No update or errors.'); } else{} $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save($date.'_SUBCON_'.$vendor_name.'_AUTO_UPDATE_REPORT.xlsx'); 

Excel error image enter image description here

+1
php phpexcel
source share

No one has answered this question yet.

See similar questions:

7
Export PHPExcel File "Unread Content" Excel File in yii2

or similar:

4
PHPExcel export for large files fails
one
PhpExcel will not create a file on IE10
one
PHPExcel creates "unreadable content"
one
PHPExcel generated the file via $ objWriter-> save ('php: // output') - is permission required?
one
Do not print pdf chart with phpexcel
one
how to download excel file in Internet Explorer with phpexcel library
0
PHPexcel will not export query result fields
0
PHPExcel Zip Extension Errors - Cannot Create Excel File
0
How to check if excel file has unreadable content in phpexcel
0
ERROR_MESSAGE_MAIN ERROR_MESSAGE_REASON on iPad and iPhone Safari

All Articles