Code666 (代码贴、代码片段)

[PHP] 用PHPExcel将数组输出为excel文件 →→→→→进入此内容的聊天室

来自 , 2020-02-26, 写在 PHP, 查看 149 次.
URL http://www.code666.cn/view/77ee3bc5
  1. <?php
  2. /** Error reporting */
  4.  
  5. /** PHPExcel */
  6. include FCPATH.'vendor/Excel/excel/PHPExcel.php';
  7. include FCPATH.'vendor/Excel/excel/PHPExcel/Writer/Excel5.php';
  8.  
  9. function download(  $column , $datalist) {
  10. // Create new PHPExcel object
  11.  
  12. $objPHPExcel = new PHPExcel();
  13.  
  14. // Set properties
  15.  
  16. $objPHPExcel->getProperties()->setCreator("Michael");
  17. $objPHPExcel->getProperties()->setLastModifiedBy("MOT");
  18. $objPHPExcel->getProperties()->setTitle("36lean email list");
  19. $objPHPExcel->getProperties()->setSubject("Emails");
  20. $objPHPExcel->getProperties()->setDescription("Array to Excel");
  21.  
  22. // Add some data
  23. $objPHPExcel->setActiveSheetIndex(0);
  24. $basic = 'A';
  25. foreach ($column as $c) {
  26.  
  27.     $objPHPExcel->getActiveSheet()->SetCellValue( $basic.'1', $c);
  28.  
  29.     $basic ++ ;
  30. }
  31.  
  32. $max_length = count( $datalist) - 1;
  33.  
  34. for ($count = 0; $count <= $max_length; $count++) {
  35.  
  36.     $basic = 65;
  37.  
  38.     var_dump( $datalist[$count]);
  39.  
  40.     foreach ($datalist[$count] as $key => $d) {
  41.  
  42.         $basic = chr( $basic);
  43.  
  44.         $objPHPExcel->getActiveSheet()->SetCellValue( $basic.($count+2) , $d);
  45.  
  46.         $basic = ord( $basic) + 1;
  47.     }
  48.  
  49.     $basic = 65;
  50. }
  51.  
  52. //$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
  53.  
  54. // Rename sheet
  55.  
  56. $objPHPExcel->getActiveSheet()->setTitle('Simple');
  57.  
  58. // Save Excel 2007 file
  59. $fhandle = opendir('data/download/');
  60.  
  61. while($file = readdir( $fhandle))
  62. {
  63.     if( is_file( 'data/download/'.$file))
  64.     {
  65.         unlink( 'data/download/'.$file);
  66.     }
  67. }
  68.  
  69. $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
  70. $filename = 'data/download/'.md5(time()).'.xls';
  71. $objWriter->save($filename);
  72.  
  73. return base_url( $filename);
  74. //header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  75. //header('Cache-Control: max-age=0');
  76.  
  77. }
  78. //该片段来自于http://yuncode.net
  79.  

回复 "用PHPExcel将数组输出为excel文件"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666