国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home Backend Development PHP Tutorial phpexcel class library instance supports (excel2003 excel2007)

phpexcel class library instance supports (excel2003 excel2007)

Jul 25, 2016 am 08:56 AM

  1. ini_set("display_errors",1);//Whether to display the error message

  2. ini_set('include_path', ini_get('include_path').';D:\PHP \PHPExcel 1.6.6\Tests\classes\');//Set the include path for this page
  3. include "classes/PHPExcel.php";
  4. include "classes/PHPExcel/Writer/Excel5.php";
  5. //Create an excel
  6. $objPHPExcel = new PHPExcel();
  7. $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
  8. $objWriter->save("xxx.xls");
  9. ?>

  10. //Set the include path of the PHPExcel class library
  11. set_include_path('.'. PATH_SEPARATOR .
  12. 'D:ZealPHP_LIBS' . PATH_SEPARATOR .
  13. get_include_path());
  14. /**
  15. * Usage examples, there are different optional methods for lines starting with ////, please turn on the comments of the corresponding lines according to actual needs
  16. *.
  17. * If you use Excel5, the output content should be GBK encoded.
  18. */
  19. require_once ' PHPExcel.php';
  20. // uncomment
  21. ////require_once 'PHPExcel/Writer/Excel5.php'; // For other lower versions of xls
  22. // or
  23. ////require_once 'PHPExcel/Writer/Excel2007 .php'; // Used for excel-2007 format
  24. // Create a processing object instance
  25. $objExcel = new PHPExcel();
  26. // Create a file format writing object instance, uncomment
  27. ////$objWriter = new PHPExcel_Writer_Excel5($objExcel); // For other version formats
  28. // or
  29. ////$objWriter = new PHPExcel_Writer_Excel2007($objExcel); // For 2007 format
  30. //$objWriter->setOffice2003Compatibility( true);
  31. //****************************************
  32. //Set the basic document Properties
  33. $objProps = $objExcel->getProperties();
  34. $objProps->setCreator("Zeal Li");
  35. $objProps->setLastModifiedBy("Zeal Li");
  36. $objProps->setTitle( "Office XLS Test Document");
  37. $objProps->setSubject("Office XLS Test Document, Demo");
  38. $objProps->setDescription("Test document, generated by PHPExcel.");
  39. $objProps-> ;setKeywords("office excel PHPExcel");
  40. $objProps->setCategory("Test");
  41. //****************************** ****************
  42. //Set the current sheet index for subsequent content operations.
  43. //Generally, display calls are only needed when using multiple sheets.
  44. //By default, PHPExcel will automatically create the first sheet with SheetIndex=0 set
  45. $objExcel->setActiveSheetIndex(0);
  46. $objActSheet = $objExcel->getActiveSheet();
  47. / /Set the name of the current active sheet
  48. $objActSheet->setTitle('Test Sheet');
  49. //****************************** ************
  50. //Set cell content
  51. //
  52. //PHPExcel automatically determines the cell content type based on the incoming content
  53. $objActSheet->setCellValue('A1', ' String content'); // String content
  54. $objActSheet->setCellValue('A2', 26); // Value
  55. $objActSheet->setCellValue('A3', true); // Boolean value
  56. $ objActSheet->setCellValue('A4', '=SUM(A2:A2)'); // Formula
  57. //Explicitly specify the content type
  58. $objActSheet->setCellValueExplicit('A5', '847475847857487584',
  59. PHPExcel_Cell_DataType::TYPE_STRING);
  60. //Merge cells
  61. $objActSheet->mergeCells('B1:C22');
  62. //Separate cells
  63. $objActSheet->unmergeCells('B1:C22');
  64. //*************************************
  65. //Set cell style
  66. / /
  67. //Set width
  68. $objActSheet->getColumnDimension('B')->setAutoSize(true);
  69. $objActSheet->getColumnDimension('A')->setWidth(30);
  70. $ objStyleA5 = $objActSheet->getStyle('A5');
  71. //Set the number format of the cell content.
  72. //
  73. //If PHPExcel_Writer_Excel5 is used to generate content,
  74. //It should be noted here that in the
  75. //various custom formatting methods defined by the const variable of the PHPExcel_Style_NumberFormat class, other types can be used normally, but When setFormatCode
  76. //is FORMAT_NUMBER, the actual effect is that the format is not set to "0". Need to
  77. //Modify the getXf($style) method in the PHPExcel_Writer_Excel5_Format class source code,
  78. //Add a
  79. //line of code before if ($this->_BIFF_version == 0x0500) { (near line 363):
  80. //if($ifmt === '0') $ifmt = 1;
  81. //
  82. //Set the format to PHPExcel_Style_NumberFormat::FORMAT_NUMBER to avoid certain large numbers
  83. //being displayed using scientific notation. The setAutoSize method below can make the content of each row
  84. // be displayed according to the original content.
  85. $objStyleA5
  86. ->getNumberFormat()
  87. ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER);
  88. //設置字體
  89. $objFontA5 = $objStyleA5->getFont();
  90. $objFontA5->setName('Courier New');
  91. $objFontA5->setSize(10);
  92. $objFontA5->setBold(true);
  93. $objFontA5->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
  94. $objFontA5->getColor()->setARGB('FF999999');
  95. //設置對齊方式
  96. $objAlignA5 = $objStyleA5->getAlignment();
  97. $objAlignA5->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
  98. $objAlignA5->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
  99. //設置邊框
  100. $objBorderA5 = $objStyleA5->getBorders();
  101. $objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  102. $objBorderA5->getTop()->getColor()->setARGB('FFFF0000'); // color
  103. $objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  104. $objBorderA5->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  105. $objBorderA5->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  106. //設置填充顏色
  107. $objFillA5 = $objStyleA5->getFill();
  108. $objFillA5->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
  109. $objFillA5->getStartColor()->setARGB('FFEEEEEE');
  110. //從指定的單元格復制樣式信息.
  111. $objActSheet->duplicateStyle($objStyleA5, 'B1:C22');
  112. //*************************************
  113. //添加圖片
  114. $objDrawing = new PHPExcel_Worksheet_Drawing();
  115. $objDrawing->setName('ZealImg');
  116. $objDrawing->setDescription('Image inserted by Zeal');
  117. $objDrawing->setPath('./zeali.net.logo.gif');
  118. $objDrawing->setHeight(36);
  119. $objDrawing->setCoordinates('C23');
  120. $objDrawing->setOffsetX(10);
  121. $objDrawing->setRotation(15);
  122. $objDrawing->getShadow()->setVisible(true);
  123. $objDrawing->getShadow()->setDirection(36);
  124. $objDrawing->setWorksheet($objActSheet);
  125. //添加一個新的worksheet
  126. $objExcel->createSheet();
  127. $objExcel->getSheet(1)->setTitle('測試2');
  128. //保護單元格
  129. $objExcel->getSheet(1)->getProtection()->setSheet(true);
  130. $objExcel->getSheet(1)->protectCells('A1:C22', 'PHPExcel');
  131. //*************************************
  132. //輸出內容
  133. //
  134. $outputFileName = "output.xls";
  135. //到文件
  136. ////$objWriter->save($outputFileName);
  137. //or
  138. //到瀏覽器
  139. ////header("Content-Type: application/force-download");
  140. ////header("Content-Type: application/octet-stream");
  141. ////header("Content-Type: application/download");
  142. ////header('Content-Disposition:inline;filename="'.$outputFileName.'"');
  143. ////header("Content-Transfer-Encoding: binary");
  144. ////header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
  145. ////header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  146. ////header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  147. ////header("Pragma: no-cache");
  148. ////$objWriter->save('php://output');
  149. ?>

復制代碼


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

PHP Tutorial
1502
276
PHP Variable Scope Explained PHP Variable Scope Explained Jul 17, 2025 am 04:16 AM

Common problems and solutions for PHP variable scope include: 1. The global variable cannot be accessed within the function, and it needs to be passed in using the global keyword or parameter; 2. The static variable is declared with static, and it is only initialized once and the value is maintained between multiple calls; 3. Hyperglobal variables such as $_GET and $_POST can be used directly in any scope, but you need to pay attention to safe filtering; 4. Anonymous functions need to introduce parent scope variables through the use keyword, and when modifying external variables, you need to pass a reference. Mastering these rules can help avoid errors and improve code stability.

How to handle File Uploads securely in PHP? How to handle File Uploads securely in PHP? Jul 08, 2025 am 02:37 AM

To safely handle PHP file uploads, you need to verify the source and type, control the file name and path, set server restrictions, and process media files twice. 1. Verify the upload source to prevent CSRF through token and detect the real MIME type through finfo_file using whitelist control; 2. Rename the file to a random string and determine the extension to store it in a non-Web directory according to the detection type; 3. PHP configuration limits the upload size and temporary directory Nginx/Apache prohibits access to the upload directory; 4. The GD library resaves the pictures to clear potential malicious data.

Commenting Out Code in PHP Commenting Out Code in PHP Jul 18, 2025 am 04:57 AM

There are three common methods for PHP comment code: 1. Use // or # to block one line of code, and it is recommended to use //; 2. Use /.../ to wrap code blocks with multiple lines, which cannot be nested but can be crossed; 3. Combination skills comments such as using /if(){}/ to control logic blocks, or to improve efficiency with editor shortcut keys, you should pay attention to closing symbols and avoid nesting when using them.

Tips for Writing PHP Comments Tips for Writing PHP Comments Jul 18, 2025 am 04:51 AM

The key to writing PHP comments is to clarify the purpose and specifications. Comments should explain "why" rather than "what was done", avoiding redundancy or too simplicity. 1. Use a unified format, such as docblock (/*/) for class and method descriptions to improve readability and tool compatibility; 2. Emphasize the reasons behind the logic, such as why JS jumps need to be output manually; 3. Add an overview description before complex code, describe the process in steps, and help understand the overall idea; 4. Use TODO and FIXME rationally to mark to-do items and problems to facilitate subsequent tracking and collaboration. Good annotations can reduce communication costs and improve code maintenance efficiency.

How Do Generators Work in PHP? How Do Generators Work in PHP? Jul 11, 2025 am 03:12 AM

AgeneratorinPHPisamemory-efficientwaytoiterateoverlargedatasetsbyyieldingvaluesoneatatimeinsteadofreturningthemallatonce.1.Generatorsusetheyieldkeywordtoproducevaluesondemand,reducingmemoryusage.2.Theyareusefulforhandlingbigloops,readinglargefiles,or

Learning PHP: A Beginner's Guide Learning PHP: A Beginner's Guide Jul 18, 2025 am 04:54 AM

TolearnPHPeffectively,startbysettingupalocalserverenvironmentusingtoolslikeXAMPPandacodeeditorlikeVSCode.1)InstallXAMPPforApache,MySQL,andPHP.2)Useacodeeditorforsyntaxsupport.3)TestyoursetupwithasimplePHPfile.Next,learnPHPbasicsincludingvariables,ech

How to access a character in a string by index in PHP How to access a character in a string by index in PHP Jul 12, 2025 am 03:15 AM

In PHP, you can use square brackets or curly braces to obtain string specific index characters, but square brackets are recommended; the index starts from 0, and the access outside the range returns a null value and cannot be assigned a value; mb_substr is required to handle multi-byte characters. For example: $str="hello";echo$str[0]; output h; and Chinese characters such as mb_substr($str,1,1) need to obtain the correct result; in actual applications, the length of the string should be checked before looping, dynamic strings need to be verified for validity, and multilingual projects recommend using multi-byte security functions uniformly.

Quick PHP Installation Tutorial Quick PHP Installation Tutorial Jul 18, 2025 am 04:52 AM

ToinstallPHPquickly,useXAMPPonWindowsorHomebrewonmacOS.1.OnWindows,downloadandinstallXAMPP,selectcomponents,startApache,andplacefilesinhtdocs.2.Alternatively,manuallyinstallPHPfromphp.netandsetupaserverlikeApache.3.OnmacOS,installHomebrew,thenrun'bre

See all articles