Advertisement
Guest User

generating XLSX file

a guest
Oct 17th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. require_once 'a/Classes/PHPExcel/IOFactory.php';
  2. require_once 'a/Classes/PHPExcel.php';
  3.  
  4. $formula = '=INDEX({"zz","yy","xx"},MATCH(MAX({11,22,34}),{11,23,34}))';
  5.  
  6. $objPHPExcel = new PHPExcel();
  7.  
  8. $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Range #2')
  9. ->setCellValue('C2', 5)
  10. ->setCellValue('C3', 11)
  11. ->setCellValue('C4','')
  12. ->setCellValue('C5', $formula);
  13.  
  14.  
  15. $objPHPExcel->getActiveSheet()->setTitle('Formulas');
  16. $objPHPExcel->setActiveSheetIndex(0);
  17. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  18. $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement