thinkphp3.2 and phpexcel import-php手册-php.cn

Home

php教程

php手册

thinkphp3.2 and phpexcel import

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 06, 2016 pm 01:29 PM

The most basic usage of importing thinkphp3.2 and phpexcel
Start with the most basic code. Once you understand this, the rest will be very simple$file_name= './Upload/excel/123456.xls'; import("Org.Util.PHPExcel"); import("Org.Util.PHPExcel.IOFactory"); $objReader = PHPExcel_IOFactory::createReader('Excel5'); $objPHPExcel = $objReader->load($file_name,$encode='utf-8'); $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); // 取得总行数 $highestColumn = $sheet->getHighestColumn(); // 取得总列数 $s = $objPHPExcel->getActiveSheet()->getCell("A2")->getValue();Table content:
thinkphp3.2 and phpexcel import
I’ll give you a little more difficulty and let’s talk about the idea first.
1. Upload the excel file and get its address
2. Write a function to process exl, that’s it
Example code demonstration: public function upload(){ $files = $_FILES['exl']; // exl format, otherwise re-upload If($files['type'] !='application/vnd.ms-excel'){ $this->error('Not an Excel file, please re-upload'); } // Upload $upload = new ThinkUpload(); // Instantiate upload class $upload->maxSize $upload->exts $ Upload-& gt; rootpath = './upload/'; // Set the attachment to upload the root directory $upload->savePath = 'excel/'; // Set attachment upload (sub) directory //$upload->subName = array('date', 'Ym'); $upload->subName // Upload files $info = $upload->upload(); $file_name = $upload->rootPath.$info['exl']['savepath'].$info['exl']['savename']; $exl = $this->import_exl($file_name); //Remove the first row in the exl table unset($exl[0]); // Clean up empty arrays foreach($exl as $k=>$v){ If(empty($v)){ Unset ($ exl [$ k]); }; //Reorder sort($exl); $count = count($exl); // After the test form is imported successfully, whether there is data generating If($count $this->error('No valid data detected'); } //Start combining data foreach($exl as $k=>$v){ $goods[$k]['goods_sn'] = $v; // Query database $where['goods_sn'] = array('like','%'.$v.'%'); $res = M('goods')->where($where)->find(); $goods[$k]['goods_name'] = $res['goods_name']; $goods[$k]['goods_thumb'] = $res['goods_thumb']; if($res){ ’ s being being matched successfully' s $goods[$k]['is_match'] $f = 1; }else{ -- // Matching failed $goods[$k]['is_match'] } } // Instantiation data $this->assign('goods',$goods); //print_r($f); //Statistical results $total['count'] = $count; $total['success'] = $f; $total['error'] = $w; $this->assign('total',$total); //Delete Excel file unlink($file_name); $this->display('info'); } /* Process uploaded exl data * $file_name File path */ Public function import_exl($file_name){ //$file_name= './Upload/excel/123456.xls'; import("Org.Util.PHPExcel"); .Import("Org.Util.PHPExcel.IOFactory"); $objReader = PHPExcel_IOFactory::createReader('Excel5'); $objPHPExcel = $objReader->load($file_name,$encode='utf-8'); $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); // Get the total number of rows $highestColumn = $sheet->getHighestColumn(); // Get the total number of columns for($i=1;$i } Return $data; } Perfect case of generating pictures with thinkphp3.2 and phpexcel http://www.thinkphp.cn/code/2112.html Yunqi Conference Beijing Station: It is rare for Alibaba technical experts to appear on the scene. More than 100 people came this time? !

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn