The Code is as follows: |
|
| $ 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 ');
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