document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1.  public function actionExcel(){
  2.     $objPHPExcel = new PHPExcel();
  3.    
  4.     $objPHPExcel->setActiveSheetIndex(0)
  5.     ->setCellValue(\'A1\', \'Hello\')
  6.     ->setCellValue(\'B2\', \'world!\')
  7.     ->setCellValue(\'C1\', \'Hello\')
  8.     ->setCellValue(\'D2\', \'world!\');
  9.  
  10.     $objPHPExcel->setActiveSheetIndex(0)
  11.     ->setCellValue(\'A4\', \'Miscellaneous glyphs\')
  12.     ->setCellValue(\'A5\', \'eaeuaeioueiuyaouc\');
  13.  
  14.     $objPHPExcel->getActiveSheet()->setTitle(\'Simple\');
  15.  
  16.     $objPHPExcel->setActiveSheetIndex(0);
  17.      
  18.     ob_end_clean();
  19.     ob_start();
  20.    
  21.     header(\'Content-Type: application/vnd.ms-excel\');
  22.     header(\'Content-Disposition: attachment;filename="test.xls"\');
  23.     header(\'Cache-Control: max-age=0\');
  24.     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, \'Excel5\');
  25.     $objWriter->save(\'php://output\');
  26.   }
');