Exemplo n.º 1
0
 protected function phpExcelTest(TestEvent $event)
 {
     $objPHPExcel = new PHPExcel();
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'Hello')->setCellValue('B2', 'world!')->setCellValue('C1', 'Hello')->setCellValue('D2', 'world!');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A4', 'Miscellaneous glyphs')->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
     $objPHPExcel->getActiveSheet()->setCellValue('A8', "Hello\nWorld");
     $objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(-1);
     $objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
     $objWriter->save($event->getData('rootDir') . '/../web/downloads/testExcelBySubscriber.xlsx');
 }
 private function createStatistic(bool $answer, TestEvent $testEvent)
 {
     $stat = new Statistics();
     $stat->setResults($answer);
     $stat->setTask($testEvent->getTask());
     $test = $testEvent->getTest();
     $stat->setTest($test);
     $stat->setVariantIds($testEvent->getVarIds());
     $this->_entityManager->persist($stat);
     $this->_entityManager->flush();
 }
 protected function addRootDirToEventData(TestEvent $event)
 {
     $event->addRootDirToData($this->rootDir);
     return $event;
 }