<?php
require '/home/ontopgames/db-conHive.php';
require "../models/SampleModel.php";
$sampleModel = new SampleModel($pdo);
$sampleList = $sampleModel->getAllSamples();
/** PHPExcel */
include '/home/ontopgames/public_html/328/beehive/XML/PHPExcel.php';
include '/home/ontopgames/public_html/328/beehive/XML/PHPExcel/IOFactory.php';
/** PHPExcel_Writer_Excel2007 */
include '/home/ontopgames/public_html/328/beehive/XML/PHPExcel/Writer/Excel2007.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("");
$objPHPExcel->getProperties()->setLastModifiedBy("");
$objPHPExcel->getProperties()->setTitle("BeehiveSheet");
$objPHPExcel->getProperties()->setSubject("BeehiveSheet");
$objPHPExcel->getProperties()->setDescription("A list of behives and their mite information");
// Add some data
$i = 2;
//$downloadList = clone $sampleList;
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->mergeCells('A1:B1');
$objPHPExcel->getActiveSheet()->mergeCells('C1:D1');
$objPHPExcel->getActiveSheet()->mergeCells('E1:F1');
$objPHPExcel->getActiveSheet()->mergeCells('G1:H1');
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hive_Id');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Collection Date');
$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Current Period');
$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Mite Count');
