case \thebuggenie\core\entities\CustomDatatype::USER_CHOICE:
$value = $value instanceof \thebuggenie\core\entities\common\Identifiable ? $value->getName() : '';
break;
case \thebuggenie\core\entities\CustomDatatype::INPUT_TEXT:
case \thebuggenie\core\entities\CustomDatatype::INPUT_TEXTAREA_MAIN:
case \thebuggenie\core\entities\CustomDatatype::INPUT_TEXTAREA_SMALL:
default:
break;
}
$sheet->setCellValueByColumnAndRow($start_column, $cc, $value);
$start_column++;
}
$cc++;
}
}
ob_end_clean();
switch ($format) {
case 'xlsx':
$objWriter = new \PHPExcel_Writer_Excel2007($phpexcel);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="issues.xlsx"');
break;
case 'ods':
default:
header('Content-Type: application/vnd.oasis.opendocument.spreadsheet');
header('Content-Disposition: attachment;filename="issues.ods"');
$objWriter = new \PHPExcel_Writer_OpenDocument($phpexcel);
}
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
exit;
<?php
/**
* Created by PhpStorm.
* User: kratbro
* Date: 17.08.15
* Time: 20:51
*/
$phpExcelObject = new PHPExcel();
$phpExcelObject->getProperties()->setCreator("Jan Urbansky")->setTitle("Test the excel")->setSubject("Testing")->setDescription("This is a test document for something");
$phpExcelObject->setActiveSheetIndex(0)->setCellValue('A1', 'Hello')->setCellValue('B2', 'World')->setCellValue('C1', 'Hello')->setCellValue('D2', 'World');
$phpExcelObject->getActiveSheet()->setTitle('Simple');
$objWriter = new PHPExcel_Writer_OpenDocument($phpExcelObject);
$objWriter->save("files/mydoc.ods");