Advertisement
kura2yamato

contoh php excel (jadul)

Oct 21st, 2019
311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.89 KB | None | 0 0
  1. <?php
  2. require_once dirname(__FILE__) . '/phpexcel/Classes/PHPExcel.php';
  3.  
  4. $objPHPExcel = new PHPExcel();
  5. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  6.                              ->setLastModifiedBy("Maarten Balliauw")
  7.                              ->setTitle("PHPExcel Test Document")
  8.                              ->setSubject("PHPExcel Test Document")
  9.                              ->setDescription("Test document for PHPExcel, generated using PHP classes.")
  10.                              ->setKeywords("office PHPExcel php")
  11.                              ->setCategory("Test result file");
  12.                              
  13. $objPHPExcel->setActiveSheetIndex(0)
  14.             ->setCellValue('A1', 'Hello')
  15.             ->setCellValue('B2', 'world!')
  16.             ->setCellValue('C1', 'Hello')
  17.             ->setCellValue('D2', 'world!');
  18.            
  19. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  20. $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
  21.  
  22. echo "done <a href='002-phpExcel.xlsx'>download</a>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement