php excel
getproperties()->setcreator(maarten balliauw)
                             ->setlastmodifiedby(maarten balliauw)
                             ->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);
$objphpexcel->getactivesheet()->mergecells('a1:g1');
$objphpexcel->getactivesheet()->mergecells('h1:w1');
$objphpexcel->getactivesheet()->getstyle('a1')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center);
$objphpexcel->getactivesheet()->getstyle('h1')->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_center);
$objphpexcel->getactivesheet()->getcolumndimension('c')->setautosize(true);
$objphpexcel->getactivesheet()->getcolumndimension('a')->setwidth(20);
$objphpexcel->getactivesheet()->getcolumndimension('e')->setwidth(20);
// add some data
$objphpexcel->setactivesheetindex(0)
            ->setcellvalue('a1', 'user-data')
            ->setcellvalue('a2', 'username')
            ->setcellvalue('b2', 'password')
            ->setcellvalue('c2', 'sex')
            ->setcellvalue('d2', 'grade')
            ->setcellvalue('e2', 'age')
            ->setcellvalue('f2', 'weight')
            ->setcellvalue('g2', 'height')
            ->setcellvalue('h1', 'module1')
            ->setcellvalue('i2', 'q2')
            ->setcellvalue('j2', 'q3')
            ->setcellvalue('k2', 'q4')
            ->setcellvalue('l2', 'q5')
            ->setcellvalue('m2', 'q6')
            ->setcellvalue('n2', 'q7')
            ->setcellvalue('o2', 'q2')
            ->setcellvalue('p2', 'q3')
            ->setcellvalue('q2', 'q4')
            ->setcellvalue('r2', 'q5')
            ->setcellvalue('s2', 'q6')
            ->setcellvalue('t2', 'q7')
            ->setcellvalue('u2', 'q2')
            ->setcellvalue('v2', 'q3')
            ->setcellvalue('w2', 'q4')
            ->setcellvalue('x1', 'module2')
            ->setcellvalue('y2', 'q1')
            ->setcellvalue('z2', 'q2');
//数据库连接
$db = mysql_connect(localhost, root, );
mysql_select_db(test,$db);  //选择数据库，这里为ywcl。
mysql_query(set names utf8); //设定编码方式为utf8
$sqlgroups=select * from user order by username;
$resultgroups=mysql_query($sqlgroups);