Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Using the PHPExcel library

Using the PHPExcel library

WBOY
Release： 2016-07-25 08:42:24
Original
935 people have browsed it

Please introduce the PHPExcel library before use

  1. /**
  2. * Excel writing, based on PHPExcel library
  3. * @param array $data
  4. * @param $file
  5. * @return bool
  6. * @throws PHPExcel_Exception
  7. *
  8. */
  9. function excel_insert(array $data,$file){
  11. // $data = [
  12. // 'Warehouse'=>[
  13. // ['Warehouse number','Warehouse noun',1],
  14. // ['Warehouse number','Warehouse noun',1],
  15. // ['Warehouse number','Warehouse noun',1] ,
  16. // ['Warehouse number','Warehouse noun',1],
  17. // ['Warehouse number','Warehouse noun',1],
  18. // ],
  19. // 'Warehouse 2'=> [
  20. // ['Warehouse number','Warehouse noun',1],
  21. // ['Warehouse number','Warehouse noun',1],
  22. // ['Warehouse number','Warehouse noun',1 ],
  23. // ['Warehouse number','Warehouse noun',1],
  24. // ['Warehouse number','Warehouse noun',1],
  25. // ],
  26. // ];
  27. // excel_insert ($data,'s.xlsx');
  29. if(!$data||!$file){
  30. return false;
  31. }
  33. $sheet_id = 0;
  34. //Create excel operation object
  35. $objPHPExcel = new PHPExcel();
  36. //Get the file property object and provide setting resources for the following
  37. $objPHPExcel->getProperties()->setCreator("Mianyang Carbon Cloud Information Technology Co., Ltd.")
  38. ->setLastModifiedBy( "Mianyang Carbon Cloud Information Technology Co., Ltd.")
  39. ->setTitle("Input_Goods_message")
  40. ->setSubject("Topic 1")
  41. ->setDescription("Any one described")
  42. -> ;setKeywords("Keywords separated by spaces")
  43. ->setCategory("Category");
  44. for($i=1;$i $objPHPExcel->addSheet (new PHPExcel_Worksheet($objPHPExcel,'sheet'.$i));
  45. }
  46. foreach($data as $sheetName => $sheetData){
  47. $Sheet = $objPHPExcel->setActiveSheetIndex($sheet_id);
  48. $ Sheet->setTitle($sheetName);
  49. $insert_id = 1;
  50. foreach($sheetData as $rowData){
  51. if(is_array($rowData)&&$rowData){
  52. foreach($rowData as $id => $cellData){
  53. if(is_numeric($id)&&(is_string($cellData)||is_numeric($cellData))){
  54. $Sheet->setCellValue(chr(65+$id).$insert_id,$cellData );
  55. }else{
  56. return false;
  57. }
  58. }
  59. $insert_id++;
  60. }else{
  61. return false;
  62. }
  63. }
  64. $sheet_id++;
  65. }
  66. try{
  67. $objWriter = PHPExcel_IOFactory::createWriter($objPH PExcel , 'Excel2007');
  68. $objWriter->save($file);
  69. }catch (Exception $e){
  70. return false;
  71. }
  72. }
Copy code

Usage:
  1. $data = [
  2. 'Warehouse'=>[
  3. ['Warehouse number','Warehouse noun',1],
  4. ['Warehouse number','Warehouse noun',1],
  5. ['Warehouse number','Warehouse noun',1],
  6. ['Warehouse number','Warehouse noun',1],
  7. ['Warehouse number','Warehouse noun',1],
  8. ],
  9. ' Warehouse 2'=>[
  10. ['Warehouse number','Warehouse noun',1],
  11. ['Warehouse number','Warehouse noun',1],
  12. ['Warehouse number','Warehouse noun',1 ],
  13. ['Warehouse number','Warehouse noun',1],
  14. ['Warehouse number','Warehouse noun',1],
  15. ],
  16. ];
  17. excel_insert($data,'s.xlsx') ;
Copy code

PHPExcel


Related labels：
使用PHPExcel库
source：php.cn
Previous article：Filter dangerous html code in form submission with php Next article：PHP verification code file class
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
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
How to make floated elements stack vertically instead of horizontally in CSS? I'm trying to make a webpage with two columns, with main content on one side and additiona...
From 2024-04-06 20:45:26
0
2
386
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