Download Address: Http://www.codeplex.com/PHPExcel
Here is a summary of several ways to use
Include ' phpexcel.php ';
Include ' phpexcel/writer/excel2007.php ';
Or include ' phpexcel/writer/excel5.php '; For the output. xls
Create an Excel
$objPHPExcel = new Phpexcel ();
Save excel-2007 Format
$objWriter = new phpexcel_writer_excel2007 ($objPHPExcel);
or $objwriter = new Phpexcel_writer_excel5 ($objPHPExcel); Non-2007 format
$objWriter->save ("xxx.xlsx");
Direct output to Browser
$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 ');
——————————————————————————————————————–
To set properties for Excel:
Create person
$objPHPExcel->getproperties ()->setcreator ("Maarten Balliauw");
Last modified person
$objPHPExcel->getproperties ()->setlastmodifiedby ("Maarten Balliauw");
Title
$objPHPExcel->getproperties ()->settitle ("Office" XLSX Test Document ");
Topic
$objPHPExcel->getproperties ()->setsubject ("Office" XLSX Test Document ");
Describe
$objPHPExcel->getproperties ()->setdescription ("Test document for Office-XLSX, generated using PHP classes.");
Key words
$objPHPExcel->getproperties ()->setkeywords ("Office openxml PHP");
Kinds
$objPHPExcel->getproperties ()->setcategory ("Test result file");
——————————————————————————————————————–
Set the current sheet
$objPHPExcel->setactivesheetindex (0);
Set the name of the sheet
$objPHPExcel->getactivesheet ()->settitle (' simple ');
Set the value of a cell
$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) ');
Merge cells
$objPHPExcel->getactivesheet ()->mergecells (' a18:e22′);
Separating cells
$objPHPExcel->getactivesheet ()->unmergecells (' a28:b28′);
Protect cell
$objPHPExcel->getactivesheet ()->getprotection ()->setsheet (true); Needs to BES set to true in order to enable any worksheet protection!
$objPHPExcel->getactivesheet ()->protectcells (' a3:e13′, ' phpexcel ');
Set format
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′);
Setting width width
Set column Widths
$objPHPExcel->getactivesheet ()->getcolumndimension (' B ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' D ')->setwidth (12);
Set 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);
Set 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);
Center vertically
$objPHPExcel->getactivesheet ()->getstyle (' a18′)->getalignment ()->setvertical (phpexcel_style_ Alignment::vertical_center);
Set the border of column
$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);
Set the color of the border
$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′);
Set Fill Color
$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′ ') ;
Add picture
$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 ());
After the default sheet, create a worksheet
echo Date (' H:i:s '). "Create new Worksheet objectn";
$objPHPExcel->createsheet ();
$objWriter = Phpexcel_iofactory::createwriter ($objExcel, ' Excel5 ');
$objWriter-save (' php://output ');
The above describes the Excel use tips PHP Excel class Phpexcel usage, including the Excel use of the content, I hope to be interested in PHP tutorial friends helpful.
