TP5 Excel Export Download the PHPExcel1.8 is referenced in the project
The Controller class calls the method to support chained operations
Quickly export Excel
You only need to define the fields and query criteria you want to download.
Support for multi-table output into one Excel
$excel =new Excel (); $table _name= "Mk_material_list_edit"; $field =["id" + "serial number", "GUID" and "Project Code", "name" + "project name" "]; $map =[" status "=>1]; $map 2=[" status "=>-1]; $excel->setexcelname (" Download Decoration Project ")->createsheet (" Renovation project ", $ TABLE_NAME, $field, $map)->createsheet ("Removed renovation project", $table _name, $field, $map 2)->downloadexcel ();//Fast Import $ Getexcelobject=excel::loadexcel ("Test.xls"); $sheetName = $getExcelobject->getsheetnames ();d UMP ($SHEETNAME); $ Sheet = $getExcelobject->getsheetbyname ($sheetName [0])->toarray ();d UMP ($sheet);