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;$igetactivesheet(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');