$objPHPExcel = new Phpexcel ();
Default one Sheet
$objPHPExcel->getproperties ()->setcreator ("test")
->setlastmodifiedby ("Test")
->settitle ("Office" XLSX Test Document ")
->setsubject ("Office" XLSX Test Document ")
->setdescription ("Test document for Office" XLSX, generated using PHP classes. ")
->setkeywords ("Office openxml PHP")
->setcategory ("Test result file");
$objPHPExcel->setactivesheetindex (0)
->setcellvalue (' A1 ', ' SKU ')
->setcellvalue (' B1 ', ' price ')
->setcellvalue (' C1 ', ' current_price ');
Loop array Output
for ($i =0; $i <count ($result); $i + +)
{
$objPHPExcel->setactivesheetindex (0)->setcellvalue (' A '. ( $i +2), $result [$i] [' SKU ']);
$objPHPExcel->setactivesheetindex (0)->setcellvalue (' B '. ( $i +2), $result [$i] [' Price '];
$objPHPExcel->setactivesheetindex (0)->setcellvalue (' C '. ( $i +2), $result [$i] [' current_price ']);
}
$objPHPExcel->getactivesheet ()->settitle (' title ');
$objPHPExcel->setactivesheetindex (0);
If you add a sheet workbook
Create sheet
$objPHPExcel->createsheet ();
$objPHPExcel->getsheet (1)->settitle (' Imgurl-ie ');
$objPHPExcel->setactivesheetindex (1)
->setcellvalue (' A1 ', ' SKU ')
->setcellvalue (' B1 ', ' url ');
for ($i =0; $i <count ($imgarr); $i + +)
{
$objPHPExcel->setactivesheetindex (1)->setcellvalue (' A '. ( $i +2), $imgarr [$i] [' SKU ']);
$objPHPExcel->setactivesheetindex (1)->setcellvalue (' B '. ( $i +2), $imgarr [$i] [' Imgurl ']);
}
Set Workbook name
$objPHPExcel->getactivesheet ()->settitle (' Imgurl ');
$objPHPExcel->setactivesheetindex (1);
////////////////////////////////////////////////////////////////////////////////
Header (' Content-type:application/vnd.ms-excel ');
Header (' content-disposition:attachment;filename= ' shangxin '. Date ("y-m-d"). XLS "');
Header (' cache-control:max-age=0 ');
$objWriter = Phpexcel_iofactory::createwriter ($objPHPExcel, ' Excel5 ');
$objWriter->save (' php://output ');
Exit
Phpexcel Download Multiple sheet forms