This article describes how to update and modify the content instance code in excel using php. For more information, see
The Code is as follows:
// Template storage directory
$ Dir = $ DOCUMENT_ROOT. '/backoffice/admin/oemcheck /';
$ TemplateName = '1.xlsx ';
$ OutputFileName = 'template.xlsx ';
$ Txt = 'test ';
// Instantiate the Excel Reading Class
$ PHPReader = new PHPExcel_Reader_Excel2007 ();
If (! $ PHPReader-> canRead ($ dir. $ templateName )){
$ PHPReader = new PHPExcel_Reader_Excel5 ();
If (! $ PHPReader-> canRead ($ dir. $ templateName )){
Echo 'unrecognized Excel file! ';
Return false;
}
}
// Read Excel
$ PHPExcel = $ PHPReader-> load ($ dir. $ templateName );
// Read Worksheet 1
$ CurrentSheet = $ PHPExcel-> getSheet (0 );
$ CurrentSheet-> setCellValue ('b13', iconv ('gbk', 'utf-8', $ txt); // header assignment //
// Instantiate the Excel writing class
$ PHPWriter = new PHPExcel_Writer_Excel2007 ($ PHPExcel );
Ob_start ();
Header ("Content-Type: application/force-download ");
Header ("Content-Type: application/octet-stream ");
Header ("Content-Type: application/download ");
Header ('content-Disposition: attachment; filename = "'. $ outputFileName.'" '); // output Template Name
Header ("Content-Transfer-Encoding: binary ");
Header ("Last-Modified:". gmdate ("D, d m y h: I: s"). "GMT ");
Header ('pragma: public ');
Header ('expires: 30 ');
Header ('cache-Control: public ');
$ PHPWriter-> save ('php: // output ');