thinkphp导入导出xls文件

1 /**
2 * 数组转xls格式的excel文件
3 * &＃64;param array $data 需要生成excel文件的数组
4 * &＃64;param string $filename 生成的excel文件名
5 * 示例数据&＃xff1a;
6 $data &＃61; array(
7 array(NULL, 2010, 2011, 2012),
8 array(&＃39;Q1&＃39;, 12, 15, 21),
9 array(&＃39;Q2&＃39;, 56, 73, 86),
10 array(&＃39;Q3&＃39;, 52, 61, 69),
11 array(&＃39;Q4&＃39;, 30, 32, 0),
12 );
13 */
14 function create_xls($data,$filename &＃61; &＃39;simple.xls&＃39;){
15 ini_set(&＃39;max_execution_time&＃39;,&＃39;0&＃39;);
16 Vendor(&＃39;PHPExcel.PHPExcel&＃39;);
17 $filename &＃61; str_replace(&＃39;.xls&＃39;,&＃39;&＃39;,$filename) . &＃39;.xls&＃39;;
18 $phpexcel &＃61; new PHPExcel();
19 $phpexcel->getProperties()
20 ->setCreator("Maarten Balliauw")
21 ->setLastModifiedBy("Maarten Balliauw")
22 ->setTitle("Office 2007 XLSX Test Document")
23 ->setSubject("Office 2007 XLSX Test Document")
24 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
25 ->setKeywords("office 2007 openxml php")
26 ->setCategory("Test result file");
27 $phpexcel->getActiveSheet()->fromArray($data);
28 $phpexcel->getActiveSheet()->setTitle(&＃39;Sheet1&＃39;);
29 $phpexcel->setActiveSheetIndex(0);
30 header(&＃39;Content-Type: application/vnd.ms-excel&＃39;);
31 header("Content-Disposition: attachment;filename&＃61;$filename");
32 header(&＃39;Cache-Control: max-age&＃61;0&＃39;);
33 header(&＃39;Cache-Control: max-age&＃61;1&＃39;);
34 header (&＃39;Expires: Mon, 26 Jul 1997 05:00:00 GMT&＃39;);//Date in the past
35 header (&＃39;Last-Modified: &＃39; . gmdate(&＃39;D, d M Y H:i:s&＃39;) . &＃39; GMT&＃39;);//always modified
36 header (&＃39;Cache-Control: cache, must-revalidate&＃39;);//HTTP/1.1
37 header (&＃39;Pragma: public&＃39;);//HTTP/1.0
38 $objwriter &＃61; PHPExcel_IOFactory::createWriter($phpexcel,&＃39;Excel5&＃39;);
39 $objwriter->save(&＃39;php://output&＃39;);
40 exit;
41 }

1 //导出
2 public function create_xls() {
3 $industry_list &＃61; M(&＃39;welfare&＃39;)->field(&＃39;welfare_name&＃39;)->select();
4 $data &＃61; array();
5 array_push($data, array(&＃39;福利名称&＃39;));
6 foreach ($industry_list as $key &＃61;> $value) {
7 array_push($data, array($value[&＃39;welfare_name&＃39;]));
8 }
9 create_xls($data, &＃39;福利&＃39;);
10 }

//导入public function upload_xls() {$upload &＃61; new \Think\Upload();$upload->maxSize &＃61; 3145728;$upload->exts &＃61; array(&＃39;xls&＃39;, &＃39;xlsx&＃39;);$upload->saveExt &＃61; &＃39;xls&＃39;;$upload->rootPath &＃61; &＃39;./Application/Upload/excel/&＃39;;$upload->autoSub &＃61; false;$result &＃61; $upload->uploadOne($_FILES[&＃39;xls_file&＃39;]);if (!$result) {$this->error($upload->getError(), U(&＃39;WelFare/welfare_list&＃39;));}$data &＃61; import_excel($upload->rootPath . $result[&＃39;savepath&＃39;] . $result[&＃39;savename&＃39;]);delDirAndFile($upload->rootPath . $result[&＃39;savepath&＃39;]);$list &＃61; array();unset($data[1]);$i &＃61; 0;foreach ($data as $k &＃61;> $v) {$param &＃61; array();$param[&＃39;welfare_name&＃39;] &＃61; $v[0];$info &＃61; M(&＃39;welfare&＃39;)->where($param)->find();if ($info)continue;$list[$i][&＃39;welfare_name&＃39;] &＃61; $v[0];$i&＃43;&＃43;;}if ($i) {M(&＃39;welfare&＃39;)->addAll($list);$this->success(&＃39;成功插入了&＃39; . $i . &＃39;条数据&＃39;, U(&＃39;WelFare/welfare_list&＃39;));} else {$this->error(&＃39;插入了0条数据&＃39;, U(&＃39;WelFare/welfare_list&＃39;));}}