Phpexcel notes, phpexcel Chinese help manual

Source: Internet
Author: User
Tags border color getcolor

Phpexcel is a good thing, powerful, below this is a phpexcel simple Chinese help manual, lists the various properties, as well as the commonly used methods of operation, each one is illustrated with examples, I hope to help you.

Reference Phpexcel

include ' phpexcel.php '; include ' phpexcel/writer/excel2007.php '; // or include ' phpexcel/writer/excel5.php '; for output. xls
$objPHPExcel New // Create an instance

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");//Topics$objPHPExcel->getproperties ()->setsubject (Office "XLSX Test Document");//Description$objPHPExcel->getproperties ()->setdescription ("Test document for Office" XLSX, generated using PHP classes.));//Key Words$objPHPExcel->getproperties ()->setkeywords ("Office openxml PHP");//type$objPHPExcel->getproperties ()->setcategory ("Test result file");

You can also use the following method

$objPHPExcel->getproperties ()->setcreator ("CTOs")              ->setlastmodifiedby (" CTOs ")              ->settitle (" office "XLSX Test Document")              ->setsubject ("office XLSX Test Document ")              ->setdescription (" Test document for Office "XLSX, generated using PHP classes. " )              ->setkeywords ("Office openxml PHP")              

Set the current sheet

$objPHPExcel->setactivesheetindex (0);

Set the title of the sheet

$objPHPExcel->getactivesheet ()->settitle (' simple ');

Set cell width

$objPHPExcel->getactivesheet ()->getcolumndimension (' A ')->setwidth (20);

Set cell height

$objPHPExcel->getactivesheet ()->getrowdimension ($i)->setrowheight (40);

Merge cells

$objPHPExcel->getactivesheet ()->mergecells (' A18:e22 ');

Split Cells

$objPHPExcel->getactivesheet ()->unmergecells (' a28:b28 ');

Set up a protection cell to protect the worksheet

$objPHPExcel->getactivesheet ()->getprotection ()->setsheet (true$ Objphpexcel->getactivesheet ()->protectcells (' A3:e13 ', ' phpexcel ');

Set format

$objPHPExcel->getactivesheet ()->getstyle (' E4 ')->getnumberformat ()->setformatcode (phpexcel _style_numberformat::format_currency_eur_simple); $objPHPExcel $objPHPExcel->getactivesheet ()->getstyle (' E4 '), ' e5:e13 ');

Set Bold

$objPHPExcel->getactivesheet ()->getstyle (' B1 ')->getfont ()->setbold (true);

Set the horizontal alignment (horizontal_right,horizontal_left,horizontal_center,horizontal_justify)

$objPHPExcel->getactivesheet ()->getstyle (' D11 ')->getalignment ()->sethorizontal (phpexcel_style_ Alignment::horizontal_right);

Set Vertical Center

$objPHPExcel->getactivesheet ()->getstyle (' A18 ')->getalignment ()->setvertical (phpexcel_ Style_alignment::vertical_center);

Set Font size

$objPHPExcel->getactivesheet ()->getdefaultstyle ()->getfont ()->setsize (10);

Set border

$objPHPExcel

Set 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 ‘);

Inserting images

$objDrawing=Newphpexcel_worksheet_drawing ();/*set the picture path remember: only local pictures*/ $objDrawing->setpath (' Image address ');/*Set Picture height*/ $objDrawing->setheight (180);//Photo Height$objDrawing->setwidth (150);//Photo Width/*set the cell for the picture to insert*/$objDrawing->setcoordinates (' E2 '); /*format the cell where the picture is located*/$objDrawing->setoffsetx (5);$objDrawing->setrotation (5);$objDrawing->getshadow ()->setvisible (true);$objDrawing->getshadow ()->setdirection (50);$objDrawing->setworksheet ($objPHPExcel->getactivesheet ());

Set cell background color

$objPHPExcel->getactivesheet (0)->getstyle (' A1 ')->getfill ()->setfilltype (\phpexcel_style_ Fill::fill_solid); $objPHPExcel->getactivesheet (0)->getstyle (' A1 ')->getfill ()->getstartcolor ()->setargb (' Ffcae8ea ');

Last input browser, export Excel

$savename= ' Export Excel sample ';$ua=$_server["Http_user_agent"];$datetime=Date(' y-m-d ', Time()); if(Preg_match("/msie/",$ua)) {    $savename=UrlEncode($savename);//processing IE export name garbled} //Excel Header ParametersHeader(' Content-type:application/vnd.ms-excel '); Header(' Content-disposition:attachment;filename= '.$savename.‘. XLS "');//date is the file name suffixHeader(' Cache-control:max-age=0 '); $objWriter= \phpexcel_iofactory::createwriter ($objPHPExcel, ' Excel5 ');//excel5 to XLS format, excel2007 to xlsx format$objWriter->save (' php://output ');

Phpexcel notes, phpexcel Chinese help manual

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.