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 
php phpexcel
aozora
source share