<?php
// require('http://localhost:8000/app/libs/excel/Classes/PHPExcel.php');
set_time_limit(1020);
require app_path() . '/libs/excel/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("ideconnect.com")->setLastModifiedBy("ideconnect.com")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
// Add some data
//***************************************************************************************
$excelarr = array();
$hotelbookings = Hotelbooking::where('eventname', '=', $event)->get();
$headers = Schema::getColumnListing('hotelbookings');
foreach ($hotelbookings as $hotelbooking) {
$arr = array();
foreach ($hotelbooking['attributes'] as $key => $value) {
$arr[] = $value;
}
$excelarr[] = $arr;
}
array_unshift($excelarr, $headers);
$objPHPExcel->setActiveSheetIndex(0)->fromArray($excelarr, '', 'A1');
$objPHPExcel->getActiveSheet()->setTitle('DM');
$styleArray = array('font' => array('name' => 'Calibri', 'size' => '10', 'color' => array('rgb' => 'FFFFFF'), 'bold' => true), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array('rgb' => '000000')));
// $styleArray2 = array(
// 'font' => array(
// 'name' => 'Calibri',
// 'size' => '10',
// 'color' => array(
// 'rgb' => '000000'
// ),
