Php reading excel file example sharing (update and modify excel) _ PHP Tutorial-php Tutorial

Share an example of php reading an excel file (update and modify an excel file ). Copy the code as follows: example; $ txttest; instantiate 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 ');

The http://www.bkjia.com/PHPjc/736841.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/736841.htmlTechArticle code is as follows: // The Template directory $ dir = $ DOCUMENT_ROOT. '/backoffice/admin/oemcheck/'; $ templateName = '1.xlsx '; $ outputFileName = 'templat.xlsx'; $ txt = 'test'; // instantiate...