Phpexcel Export excel_php Tutorial

Source: Internet
Author: User
Tags border color getcolor
If garbled when exporting Chinese, you can try to convert the string to gb2312, for example$yourStr from UTF-8 converted into a gb2312:$yourStr= Mb_convert_encoding ("gb2312", "UTF-8",$yourStr); Summary PHP Export Excel PHP import Excel phpexcel Instructions phpexcel user manual1: First recommendation of Phpexcel, official website: http://Www.codeplex.com/PHPExcelImport and export, you can export office2007 format, and compatible with 2003. The downloaded package has documentation and examples that you can study on your own. 
 //to set the include path for the Phpexcel class librarySet_include_path('.'. Path_separator. ' D:\workspace\biznaligy_eh\dev_src\includes\PHPExcel '. Path_separator.Get_include_path()); /** * The following is an example of use, for a line beginning with////is a different alternative, please open the corresponding line comment according to the actual need.   * If you use Excel5, the content of the output should be GBK encoded. */    require_once' Phpexcel.php '; require_once' phpexcel/writer/excel5.php ';//for other low version xls   require_once' phpexcel/writer/excel2007.php ';//for excel-2007 format//Create a Processing object instance   $objExcel=NewPhpexcel ();//create a file format to write to an object instance, uncomment   $objWriter=NewPhpexcel_writer_excel5 ($objExcel);//for other version formats//or//$objWriter = new phpexcel_writer_excel2007 ($objExcel);//For 2007 formats//$objWriter->setoffice2003 Compatibility (TRUE); Set document basic Properties   $objProps=$objExcel-getProperties (); $objProps->setcreator ("Zeal Li"); $objProps->setlastmodifiedby ("Zeal Li"); $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"); //sets the current sheet index for subsequent content operations. It is generally only necessary to display a call when multiple sheet are used. By default, Phpexcel automatically creates the first sheet to be set sheetindex=0   $objExcel->setactivesheetindex (0); $objActSheet=$objExcel-Getactivesheet ();//sets the name of the currently active sheet    $objActSheet->settitle (' Test sheet '); //Set cell contents automatically determine cell content type by phpexcel based on incoming content    $objActSheet->setcellvalue (' A1 ', ' string content ');//string Content    $objActSheet->setcellvalue (' A2 ', 26);//value    $objActSheet->setcellvalue (' A3 ',true);//Boolean value    $objActSheet->setcellvalue (' A4 ', ' =sum (A2:A2) ');//Formula//explicitly specify content type   $objActSheet->setcellvalueexplicit (' A5 ', ' 8757584 ', Phpexcel_cell_datatype::type_string); //Merge Cells    $objActSheet->mergecells (' B1:c22 '); //Separating cells    $objActSheet->unmergecells (' B1:c22 '); //Set Width   $objActSheet->getcolumndimension (' B ')->setautosize (true); $objActSheet->getcolumndimension (' A ')->setwidth (30); //sets the number format for the contents of the cell. If you use Phpexcel_writer_excel5 to generate content,//You need to note that in the Phpexcel_style_numberformat class, the const variable definition//Various custom formatting methods, Other types can be used normally, but when setformatcode//is format_number, the actual effect is not formatted as "0". Need//Modify the GETXF ($style) method in the Phpexcel_writer_excel5_format class source code,//in front of if ($this->_biff_version = = 0x0500) {(Near line No. 363) Add a//Line code://if ($ifmt = = = ' 0 ') $ifmt = 1; Format to Phpexcel_style_numberformat::format_number, avoid some large numbers//are used scientific notation display, with the following Setautosize method can let each line of content// Are all displayed according to the original content.     $objStyleA 5=$objActSheet->getstyle (' A5 '); $objStyleA 5->getnumberformat ()->setformatcode (Phpexcel_style_numberformat::format_number); //Set Font    $objFontA 5=$objStyleA 5-GetFont (); $objFontA 5->setname (' Courier New '); $objFontA 5->setsize (10); $objFontA 5->setbold (true); $objFontA 5->setunderline (Phpexcel_style_font::underline_single); $objFontA 5->getcolor ()->setargb (' FFFF0000 ')) ; $objFontA 5->getcolor ()->setargb (Phpexcel_style_color::color_white);//$ objFontA5->getfont ()->setcolor (phpexcel_style_color::color_red);//Set Alignment    $objAlignA 5=$objStyleA 5-getalignment (); $objAlignA 5->sethorizontal (phpexcel_style_alignment::horizontal_right); $objAlignA 5->setvertical (phpexcel_style_alignment::vertical_center); //Set Border   $objBorderA 5=$objStyleA 5-getborders (); $objBorderA 5->gettop ()->setborderstyle (Phpexcel_style_border::Border_thin); $objBorderA 5->gettop ()->getcolor ()->setargb (' FFFF0000 ');//Border Color   $objBorderA 5->getbottom ()->setborderstyle (Phpexcel_style_border::Border_thin); $objBorderA 5->getleft ()->setborderstyle (Phpexcel_style_border::Border_thin); $objBorderA 5->getright ()->setborderstyle (Phpexcel_style_border::Border_thin); //Set cell fill Color   $objFillA 5=$objStyleA 5-Getfill (); $objFillA 5->setfilltype (Phpexcel_style_fill::fill_solid); $objFillA 5->getstartcolor ()->setargb (' ffeeeeee ')); //copies the style information from the specified cell.    $objActSheet->duplicatestyle ($objStyleA 5, ' B1:c22 '); //Add a picture   $objDrawing=Newphpexcel_worksheet_drawing (); $objDrawing->setname (' zealimg '); $objDrawing->setdescription (' Image inserted by Zeal '); $objDrawing->setpath ('./zeali.net.logo.gif ')); $objDrawing->setheight (36); $objDrawing->setcoordinates (' C23 '); $objDrawing->setoffsetx (10); $objDrawing->setrotation (15); $objDrawing->getshadow ()->setvisible (true); $objDrawing->getshadow ()->setdirection (36); $objDrawing->setworksheet ($objActSheet); //Add a new worksheet   $objExcel-Createsheet (); $objExcel->getsheet (1)->settitle (' Test 2 '); //Protect Cells   $objExcel->getsheet (1)->getprotection ()->setsheet (true); $objExcel->getsheet (1)->protectcells (' A1:c22 ', ' phpexcel ');//Display grid lines:$objPHPExcel->getactivesheet ()->setshowgridlines (true);//Show hidden Columns$objPHPExcel->getactivesheet ()->getcolumndimension (' C ')->setvisible (true);$objPHPExcel->getactivesheet ()->getcolumndimension (' D ')->setvisible (false);//Show hidden rows$objPHPExcel->getactivesheet ()->getrowdimension (' Ten ')->setvisible (false);//Default Column width$objPHPExcel->getactivesheet ()->getdefaultcolumndimension ()->setwidth (12);//Default line width$objPHPExcel->getactivesheet ()->getdefaultrowdimension ()->setrowheight (15);//Worksheet default style settings (and default different settings required separately)$objPHPExcel->getactivesheet ()->getdefaultstyle ()->getfont ()->setname (' Arial ');$objPHPExcel->getactivesheet ()->getdefaultstyle ()->getfont ()->setsize (8);$objPHPExcel->getactivesheet ()->getdefaultstyle ()getalignment ();$objPHPExcel->getactivesheet ()->getdefaultstyle ()->getalignment ()->sethorizontal (phpexcel_style_alignment::horizontal_center); $objPHPExcel->getactivesheet ()->getdefaultstyle ()->getalignment ()->setvertical (phpexcel_style_alignment::vertical_center);//Output Content   $outputFileName= "Output.xls"; //to a file////$objWriter->save ($outputFileName);//or//to the browser   Header("Content-type:application/force-download"); Header("Content-type:application/octet-stream"); Header("Content-type:application/download"); Header(' Content-disposition:inline;filename= '.$outputFileName.'"'); Header("Content-transfer-encoding:binary"); Header("Last-modified:".)gmdate("D, D M Y h:i:s"). "GMT"); Header("Cache-control:must-revalidate, post-check=0, pre-check=0"); Header("Pragma:no-cache"); $objWriter->save (' Php://output '); ?>

http://www.bkjia.com/PHPjc/814549.html www.bkjia.com true http://www.bkjia.com/PHPjc/814549.html techarticle if garbled in the export of Chinese, you can try to convert the string to gb2312, for example, the following $yourStr from the Utf-8 converted to gb2312: $yourStr = mb_convert_encoding ("gb2312", "utf- ...

  • 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.