简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

PHP export excel php uses phpexcel to export excel files

WBOY
Release： 2016-07-25 08:54:43
Original
888 people have browsed it

  3. //Load the PHPExcel class

  4. require './phpexcel/PHPExcel.php';

  5. //Create an excel object instance

  6. $objPHPExcel = new PHPExcel();

  7. //Set the basic properties of the document

  8. $objProps = $objPHPExcel->getProperties();
  9. $objProps->setCreator("Lao Mao" );
  10. $objProps->setLastModifiedBy("Lao Mao");
  11. $objProps->setTitle("Office XLS Test Document");
  12. $objProps->setSubject("Office XLS Test Document, Demo");
  13. $objProps->setDescription("Test document, generated by PHPExcel.");
  14. $objProps->setKeywords("office excel PHPExcel");
  15. $objProps->setCategory("Test");

  16. //Set the current sheet index for subsequent content operations.

  17. //Generally, display calls are only needed when using multiple sheets.
  18. //By default, PHPExcel will automatically create the first sheet with SheetIndex=0
  19. $objPHPExcel->setActiveSheetIndex(0);

  20. //Set the name of the current active sheet

  21. $objActSheet = $objPHPExcel->getActiveSheet();
  22. $objActSheet->setTitle('Test Sheet');

  23. //Set cell content

  24. //The data here can Read from the database and then perform loop processing
  25. //by bbs.it-home.org
  26. $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'a1');
  27. $objPHPExcel-> ;getActiveSheet()->SetCellValue('A2', 'a2');
  28. $objPHPExcel->getActiveSheet()->SetCellValue('A3', 'a3');
  29. $objPHPExcel->getActiveSheet() ->SetCellValue('A4', 'a4');
  30. $objPHPExcel->getActiveSheet()->SetCellValue('A5', 'a5');

  31. $objPHPExcel- >getActiveSheet()->SetCellValue('B1', 'b1');

  32. $objPHPExcel->getActiveSheet()->SetCellValue('B2', 'b2');
  33. $objPHPExcel->getActiveSheet( )->SetCellValue('B3', 'b3');
  34. $objPHPExcel->getActiveSheet()->SetCellValue('B4', 'b4');
  35. $objPHPExcel->getActiveSheet()-> SetCellValue('B5', 'b5');

  36. $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'c1');

  37. $objPHPExcel->getActiveSheet ()->SetCellValue('C2', 'c2');
  38. $objPHPExcel->getActiveSheet()->SetCellValue('C3', 'c3');
  39. $objPHPExcel->getActiveSheet()-> ;SetCellValue('C4', 'c4');
  40. $objPHPExcel->getActiveSheet()->SetCellValue('C5', 'c5');

  41. //Output document

  42. $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);

  43. //Set the header information and output it to the browser

  44. //header('Content-Type: application/vnd.ms-excel ');
  45. //header("Content-Disposition:attachment; filename=demo.xls");
  46. //header('Cache-Control: max-age=0');
  47. //$objWriter->save ('php://output');

  48. //Save to a certain location

  49. $objWriter->save(dirname(__FILE__) . '/demo.xls');< /p>
Copy code


Related labels：
PHP导出excel php使用phpexcel导出excel文件
source：php.cn
Previous article：php socket uses smtp to send emails with attachments Next article：How to configure smtp to send emails in php under linux
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
Latest Articles by Author
Latest Issues
How to export partial rows of a MySQL table from WHERE clause? How to export certain rows of MySQL table using where clause from PHP script? I have a MyS...
From 2023-10-21 11:41:17
0
2
271
How to handle Uncaught Error: PHP/Composer class not found? I'm starting a project with oop as a beginner and I'm trying to use some classes that I th...
From 2023-09-04 13:46:14
0
1
178
Print new lines into cells of CSV file I'm using php to generate a CSV file. I need to wrap text within a cell (can be achieved u...
From 2023-08-22 18:17:10
0
2
182
If cookies are so dangerous, why do most websites still use them? Nowadays, some browser plug-ins can be used to easily obtain the user's cookies and export...
From 2022-03-25 10:41:39
0
0
716
About php dbf operation Since I need to export it to a dbf file recently, I checked the information and learned th...
From 2020-06-07 19:43:32
0
0
680
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！