getproperties();$objprops->setcreator(lao mao);$objprops->setlastmodifiedby(lao mao);$objprops->settitle(office xls test document);$objprops->setsubject(office xls test document, demo);$objprops->setdescription(test document, generated by phpexcel.);$objprops->setkeywords(office excel phpexcel);$objprops->setcategory(test);//设置当前的sheet索引，用于后续的内容操作。
//一般只有在使用多个sheet的时候才需要显示调用。//缺省情况下，phpexcel会自动创建第一个sheet被设置sheetindex=0$objphpexcel->setactivesheetindex(0);//设置当前活动sheet的名称
$objactsheet = $objphpexcel->getactivesheet();$objactsheet->settitle('测试sheet');//设置单元格内容
//这里的数据可以从数据库中读取，然后再做循环处理//by bbs.it-home.org$objphpexcel->getactivesheet()->setcellvalue('a1', 'a1');$objphpexcel->getactivesheet()->setcellvalue('a2', 'a2');$objphpexcel->getactivesheet()->setcellvalue('a3', 'a3');$objphpexcel->getactivesheet()->setcellvalue('a4', 'a4');$objphpexcel->getactivesheet()->setcellvalue('a5', 'a5');$objphpexcel->getactivesheet()->setcellvalue('b1', 'b1');
$objphpexcel->getactivesheet()->setcellvalue('b2', 'b2');$objphpexcel->getactivesheet()->setcellvalue('b3', 'b3');$objphpexcel->getactivesheet()->setcellvalue('b4', 'b4');$objphpexcel->getactivesheet()->setcellvalue('b5', 'b5');$objphpexcel->getactivesheet()->setcellvalue('c1', 'c1');
$objphpexcel->getactivesheet()->setcellvalue('c2', 'c2');$objphpexcel->getactivesheet()->setcellvalue('c3', 'c3');$objphpexcel->getactivesheet()->setcellvalue('c4', 'c4');$objphpexcel->getactivesheet()->setcellvalue('c5', 'c5');//输出文档
$objwriter = new phpexcel_writer_excel5($objphpexcel);//设置header头部信息，并输出到浏览器
//header('content-type: application/vnd.ms-excel');//header(content-disposition:attachment; filename=demo.xls);//header('cache-control: max-age=0');//$objwriter->save('php://output');//保存至某一位置
$objwriter->save(dirname(__file__) . '/demo.xls');
复制代码