vendor(phpexcel176.phpexcel); // create new phpexcel object $objphpexcel = new phpexcel(); // set properties $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); //set width $objphpexcel->getactivesheet()->getcolumndimension('a')->setwidth(80); $objphpexcel->getactivesheet()->getcolumndimension('b')->setwidth(80); $objphpexcel->getactivesheet()->getcolumndimension('c')->setwidth(80); $objphpexcel->getactivesheet()->getcolumndimension('d')->setwidth(80); $objphpexcel->getactivesheet()->getcolumndimension('e')->setwidth(80); $objphpexcel->getactivesheet()->getcolumndimension('f')->setwidth(80); //设置行高度 //$objphpexcel->getactivesheet()->getrowdimension('1')->setrowheight(22); //$objphpexcel->getactivesheet()->getrowdimension('2')->setrowheight(20); //set font size bold $objphpexcel->getactivesheet()->getdefaultstyle()->getfont()->setsize(10); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getfont()->setbold(true); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getalignment()->setvertical(phpexcel_style_alignment::vertical_center); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getborders()->getallborders()->setborderstyle(phpexcel_style_border::border_thin); //设置水平居中 //$objphpexcel->getactivesheet()->getstyle('a1')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('a')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('b')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('d')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('f')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); //合并cell //$objphpexcel->getactivesheet()->mergecells('a1:f1'); //set font size bold //$objphpexcel->getactivesheet()->getdefaultstyle()->getfont()->setsize(10); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getfont()->setbold(true); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getalignment()->setvertical(phpexcel_style_alignment::vertical_center); //$objphpexcel->getactivesheet()->getstyle('a2:f2')->getborders()->getallborders()->setborderstyle(phpexcel_style_border::border_thin); $objphpexcel->getactivesheet()->getstyle('a1')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('a')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('b')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('d')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); $objphpexcel->getactivesheet()->getstyle('f')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center); //?cell $objphpexcel->getactivesheet()->mergecells('a1:f1'); // set table header content $objphpexcel->setactivesheetindex(0) ->setcellvalue('a1', iconv(utf-8,gb2312,订单数据汇总 时间:'.date('y-m-d h:i:s'))) ->setcellvalue('a2', iconv(utf-8,gb2312,订单id)) ->setcellvalue('b2', iconv(utf-8,gb2312,下单人)) ->setcellvalue('c2', iconv(utf-8,gb2312,客户名称)) ->setcellvalue('d2', iconv(utf-8,gb2312,下单时间)) ->setcellvalue('e2', iconv(utf-8,gb2312,需求机型)) ->setcellvalue('f2', iconv(utf-8,gb2312,需求数量)); // miscellaneous glyphs, utf-8 for($i=0;$i $objphpexcel->getactivesheet(0)->setcellvalue('a'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['id'])); $objphpexcel->getactivesheet(0)->setcellvalue('b'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['reid'])); $objphpexcel->getactivesheet(0)->setcellvalue('c'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['topid'])); //$objphpexcel->getactivesheet(0)->setcellvalue('d'.($i+3), iconv('utf-8','gb2312',todate($ordersdata[$i]['typename']))); //?common.php $objphpexcel->getactivesheet(0)->setcellvalue('d'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['typename'])); $objphpexcel->getactivesheet(0)->setcellvalue('e'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['typelink'])); $objphpexcel->getactivesheet(0)->setcellvalue('f'.($i+3), iconv(utf-8,gb2312,$ordersdata[$i]['keyword'])); //$objphpexcel->getactivesheet()->getstyle('a'.($i+3).':f'.($i+3))->getalignment()->setvertical(phpexcel_style_alignment::vertical_center); //$objphpexcel->getactivesheet()->getstyle('a'.($i+3).':f'.($i+3))->getborders()->getallborders()->setborderstyle(phpexcel_style_border::border_thin); //$objphpexcel->getactivesheet()->getrowdimension($i+3)->setrowheight(16); } // sheet $objphpexcel->getactivesheet()->settitle( iconv(utf-8,gb2312,'订单汇总表')); // set active sheet index to the first sheet, so excel opens this as the first sheet $objphpexcel->setactivesheetindex(0); // excel头参数 header('content-type: application/vnd.ms-excel; charset=utf-8'); header('content-type: application/force-download'); header('content-type: application/octet-stream'); header('content-type: application/download'); //header('content-type:charset=utf-8); //header('content-transfer-encoding: utf-8'); header('content-disposition: attachment;filename='.iconv(utf-8,gb2312,订单汇总.date('ymd-his')..xls)); //日期为文件名后缀 //header('cache-control: max-age=0'); $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel5'); //excel5为xls格式，excel2007为xlsx格式 $objwriter->save('php://output');
复制代码
php, phpexcel, excel