PHPExcel Save File

Question

Hi everyone, I have a website and I want to create an excel file and save it in my folder on my server. I tried in this mode, but every time I ask you to download it. I do not want this request to load, because after I need to create a lot of xls, this is a report and I do not need to download it, but only to save it to a folder. This is my code:

require_once 'inc/PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("Alessandro Minoccheri") ->setLastModifiedBy("Alessandro Minoccheri") ->setTitle("Office 2007 XLSX Test Document") ->setSubject("Office 2007 XLSX Test Document") ->setDescription("Generazione report inverter") ->setKeywords("office 2007 openxml php") ->setCategory(""); // Add some data $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A1', 'Hello') ->setCellValue('B2', 'world!') ->setCellValue('C1', 'Hello') ->setCellValue('D2', 'world!'); // Miscellaneous glyphs, UTF-8 $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A4', 'Miscellaneous glyphs') ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç'); // Rename worksheet $objPHPExcel->getActiveSheet()->setTitle('Simple'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client's web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="01simple.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); exit; 

I also tried:

 $objWriter->save('namee.xls'); 

But ask me to download.

How can i solve this?

Answer 1

This is because the following headers:

 // Redirect output to a client's web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="01simple.xls"'); header('Cache-Control: max-age=0'); 

This is because browsers will open the save as ... window if they see the Content-Disposition header. Delete these lines.

However, excel should be saved to disk anyway. Can't you see? if not, make sure PHP has the appropriate permissions to write to this folder