excel使用技巧 php excel类 phpExcel使用方法介绍

下载地址：http://www.codeplex.com/phpexcel
　　下面是总结的几个使用方法
　　include ‘phpexcel.php';
　　include ‘phpexcel/writer/excel2007.php';
　　//或者include ‘phpexcel/writer/excel5.php'; 用于输出.xls的
　　创建一个excel
　　$objphpexcel = new phpexcel();
　　保存excel—2007格式
　　$objwriter = new phpexcel_writer_excel2007($objphpexcel);
　　//或者$objwriter = new phpexcel_writer_excel5($objphpexcel); 非2007格式
　　$objwriter->save("xxx.xlsx");
　　直接输出到浏览器
　　$objwriter = new phpexcel_writer_excel5($objphpexcel);
　　header("pragma: public");
　　header("expires: 0″);
　　header("cache-control:must-revalidate, post-check=0, pre-check=0″);
　　header("content-type:application/force-download");
　　header("content-type:application/vnd.ms-execl");
　　header("content-type:application/octet-stream");
　　header("content-type:application/download");;
　　header('content-disposition:attachment;filename="resume.xls"‘);
　　header("content-transfer-encoding:binary");
　　$objwriter->save('php://output');
　　——————————————————————————————————————–
　　设置excel的属性：
　　创建人
　　$objphpexcel->getproperties()->setcreator("maarten balliauw");
　　最后修改人
　　$objphpexcel->getproperties()->setlastmodifiedby("maarten balliauw");
　　标题
　　$objphpexcel->getproperties()->settitle("office 2007 xlsx test document");
　　题目
　　$objphpexcel->getproperties()->setsubject("office 2007 xlsx test document");
　　描述
　　$objphpexcel->getproperties()->setdescription("test document for office 2007 xlsx, generated using php classes.");
　　关键字
　　$objphpexcel->getproperties()->setkeywords("office 2007 openxml php");
　　种类
　　$objphpexcel->getproperties()->setcategory("test result file");
　　——————————————————————————————————————–
　　设置当前的sheet
　　$objphpexcel->setactivesheetindex(0);
　　设置sheet的name
　　$objphpexcel->getactivesheet()->settitle('simple');
　　设置单元格的值
　　$objphpexcel->getactivesheet()->setcellvalue('a1′, ‘string');
　　$objphpexcel->getactivesheet()->setcellvalue('a2′, 12);
　　$objphpexcel->getactivesheet()->setcellvalue('a3′, true);
　　$objphpexcel->getactivesheet()->setcellvalue('c5′, ‘=sum(c2:c4)');
　　$objphpexcel->getactivesheet()->setcellvalue('b8′, ‘=min(b2:c5)');
　　合并单元格
　　$objphpexcel->getactivesheet()->mergecells('a18:e22′);
　　分离单元格
　　$objphpexcel->getactivesheet()->unmergecells('a28:b28′);
保护cell
　　$objphpexcel->getactivesheet()->getprotection()->setsheet(true); // needs to be set to true in order to enable any worksheet protection!
　　$objphpexcel->getactivesheet()->protectcells('a3:e13′, ‘phpexcel');
　　设置格式
　　// set cell number formats
　　echo date('h:i:s') . " set cell number formatsn";
　　$objphpexcel->getactivesheet()->getstyle('e4′)->getnumberformat()->setformatcode(phpexcel_style_numberformat::format_currency_eur_simple);
　　$objphpexcel->getactivesheet()->duplicatestyle( $objphpexcel->getactivesheet()->getstyle('e4′), ‘e5:e13′ );
　　设置宽width
　　// set column widths
　　$objphpexcel->getactivesheet()->getcolumndimension('b')->setautosize(true);
　　$objphpexcel->getactivesheet()->getcolumndimension('d')->setwidth(12);
　　设置font
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfont()->setname('candara');
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfont()->setsize(20);
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfont()->setbold(true);
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfont()->setunderline(phpexcel_style_font::underline_single);
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfont()->getcolor()->setargb(phpexcel_style_color::color_white);
　　$objphpexcel->getactivesheet()->getstyle('e1′)->getfont()->getcolor()->setargb(phpexcel_style_color::color_white);
　　$objphpexcel->getactivesheet()->getstyle('d13′)->getfont()->setbold(true);
　　$objphpexcel->getactivesheet()->getstyle('e13′)->getfont()->setbold(true);
　　设置align
　　$objphpexcel->getactivesheet()->getstyle('d11′)->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_right);
　　$objphpexcel->getactivesheet()->getstyle('d12′)->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_right);
　　$objphpexcel->getactivesheet()->getstyle('d13′)->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_right);
　　$objphpexcel->getactivesheet()->getstyle('a18′)->getalignment()->sethorizontal(phpexcel_style_alignment::horizontal_justify);
　　//垂直居中
　　$objphpexcel->getactivesheet()->getstyle('a18′)->getalignment()->setvertical(phpexcel_style_alignment::vertical_center);
　　设置column的border
　　$objphpexcel->getactivesheet()->getstyle('a4′)->getborders()->gettop()->setborderstyle(phpexcel_style_border::border_thin);
　　$objphpexcel->getactivesheet()->getstyle('b4′)->getborders()->gettop()->setborderstyle(phpexcel_style_border::border_thin);
　　$objphpexcel->getactivesheet()->getstyle('c4′)->getborders()->gettop()->setborderstyle(phpexcel_style_border::border_thin);
　　$objphpexcel->getactivesheet()->getstyle('d4′)->getborders()->gettop()->setborderstyle(phpexcel_style_border::border_thin);
　　$objphpexcel->getactivesheet()->getstyle('e4′)->getborders()->gettop()->setborderstyle(phpexcel_style_border::border_thin);
　　设置border的color
　　$objphpexcel->getactivesheet()->getstyle('d13′)->getborders()->getleft()->getcolor()->setargb('ff993300′);
　　$objphpexcel->getactivesheet()->getstyle('d13′)->getborders()->gettop()->getcolor()->setargb('ff993300′);
　　$objphpexcel->getactivesheet()->getstyle('d13′)->getborders()->getbottom()->getcolor()->setargb('ff993300′);
　　$objphpexcel->getactivesheet()->getstyle('e13′)->getborders()->gettop()->getcolor()->setargb('ff993300′);
　　$objphpexcel->getactivesheet()->getstyle('e13′)->getborders()->getbottom()->getcolor()->setargb('ff993300′);
　　$objphpexcel->getactivesheet()->getstyle('e13′)->getborders()->getright()->getcolor()->setargb('ff993300′);
　　设置填充颜色
　　$objphpexcel->getactivesheet()->getstyle('a1′)->getfill()->setfilltype(phpexcel_style_fill::fill_solid);
　　$objphpexcel->getactivesheet()->getstyle('a1′)->getfill()->getstartcolor()->setargb('ff808080′);
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfill()->setfilltype(phpexcel_style_fill::fill_solid);
　　$objphpexcel->getactivesheet()->getstyle('b1′)->getfill()->getstartcolor()->setargb('ff808080′);
　　加图片
　　$objdrawing = new phpexcel_worksheet_drawing();
　　$objdrawing->setname('logo');
　　$objdrawing->setdescription('logo');
　　$objdrawing->setpath('./images/officelogo.jpg');
　　$objdrawing->setheight(36);
　　$objdrawing->setworksheet($objphpexcel->getactivesheet());
　　$objdrawing = new phpexcel_worksheet_drawing();
　　$objdrawing->setname('paid');
　　$objdrawing->setdescription('paid');
　　$objdrawing->setpath('./images/paid.png');
　　$objdrawing->setcoordinates('b15′);
　　$objdrawing->setoffsetx(110);
　　$objdrawing->setrotation(25);
　　$objdrawing->getshadow()->setvisible(true);
　　$objdrawing->getshadow()->setdirection(45);
　　$objdrawing->setworksheet($objphpexcel->getactivesheet());
　　在默认sheet后，创建一个worksheet
　　echo date('h:i:s') . " create new worksheet objectn";
　　$objphpexcel->createsheet();
　　$objwriter = phpexcel_iofactory::createwriter($objexcel, 'excel5');
　　$objwriter-save('php://output');

以上就介绍了excel使用技巧 php excel类 phpExcel使用方法介绍，包括了excel使用技巧方面的内容，希望对PHP教程有兴趣的朋友有所帮助。