//保存
$objPHPExcel = new \PHPExcel();
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
$this->Sheet0($objPHPExcel);//Sheet0表
$this->Sheet1($objPHPExcel);//Sheet1表
$this->Sheet2($objPHPExcel);//Sheet2表
$this->Sheet3($objPHPExcel);//Sheet3表
$this->Sheet4($objPHPExcel);//Sheet4表
$this->data($objPHPExcel,$h_name);//表1数据,Sheet0
$this->catData($objPHPExcel,$h_name);//表2数据,Sheet1
$this->shopsData($objPHPExcel,$h_name);//表4数据,Sheet3
$this->outData($objPHPExcel,$h_name);//表5,其它房产,Sheet4
//导出文件名
$filename = time().'.xlsx';
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); //excel5为xls格式,excel2007为xlsx格式
//获得tp6路径
$Absolute_Path=$_SERVER['SCRIPT_FILENAME'];
$user_path = substr($Absolute_Path,0,-9).'/storage/xsc/';//保存路径
$objWriter->save($user_path.$filename);//保存excle文件