Directly provide the generated excel file as a download page to generate an excel file

Directly provide the generated excel file as a download page to generate an excel file

To download the excel display download page in php to the local hard disk, you need to set the header information:

Code:

$ ObjWriter = \ PHPExcel_IOFactory: createWriter ($ objPHPExcel, 'excel2007 '); header ("Pragma: public"); header ("Expires: 0 "); header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0"); // sets the http protocol. Download supports header ("Content-Type: application/force-download "); // sets the Content to be downloaded as excelheader (" Content-Type: application/vnd. ms-execl "); // sets the downloaded Content to the 8-mechanism stream Content header (" Content-Type: application/octet-stream "); // sets the http protocol, download support header ("Content-Type: application/download"); // download the definition header of the excel name ('content-Disposition: attachment; filename = "commodity information .xlsx "'); // set the Content to binary format Transfer header ("Content-Transfer-Encoding: binary"); // directly provide the excel file as the download format $ objWriter-> save ('php: // output ');