Php update and modify content in excel example _ PHP Tutorial

Php updates and modifies the content in excel. Example; $ txttest; instantiate the Excel reading class $ PHPReadernew

































$ 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 www.111cn.net$ 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 nameHeader ("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 code is as follows:

Original article: http://www.111cn.net/phper/php/58174.htmyou may be interested in

• Phpexcel generate excel code
• Php uses phpexcel to generate an excel document instance
• The phpExcel class exports data from mysql to xls garbled characters
• Phpexcel Read excel document code
• Use phpexcel to read the excel code
• PHP Excel
• Solutions to errors when exporting Excel files in PHPExcel
• PHPExcel usage details
• PhpExcel data memory overflow solution
• PHPEXCEL usage and introduction

Export $ dir = $ DOCUMENT_ROOT. '/backoffice/admin/oemcheck/'; $ templateName = '1.xlsx'; $ outputFileName = 'templat.xlsx'; $ txt = 'test '; // instantiate the Excel reading class $ PHPReader = new...