Back to all examples
PHP
<?php
require_once '../lib/Kendo/Autoload.php';
$spreadsheet = new \Kendo\UI\Spreadsheet('spreadsheet');

$sheet = new \Kendo\UI\SpreadsheetSheet();
$filter = new \Kendo\UI\SpreadsheetSheetFilter();
$filter->ref("A3:G49");

$sheet->name("OrdersLog")
  	  ->filter($filter)
      ->mergedCells(array("A1:G1", "A2:F2"));

$spreadsheet->addSheet($sheet);

$row = new \Kendo\UI\SpreadsheetSheetRow();
$row->height(50);
$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("ORDERS LOG");
$cell->fontSize(18);
$cell->textAlign("center");
$cell->background("rgb(144,164,174)");
$cell->color("white");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("REPORT");
$cell->textAlign("right");
$cell->background("rgb(176,190,197)");
$cell->color("white");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->index(6);
$cell->background("rgb(176,190,197)");
$cell->color("white");
$cell->formula("TODAY()");
$cell->format("mmm-dd");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("ID");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("DATE");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("TIME");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("CLIENT");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("COMPANY");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("SHIPPING");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("DISCOUNT");
$cell->textAlign("center");
$cell->background("rgb(236,239,241)");
$cell->bold("true");
$cell->color("black");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10223");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("09:30");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Terry Lawson");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.02");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10247");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("15:15");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Charles Miller");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10251");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:13");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Jennie Walker");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.1");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10226");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("17:43");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Samuel Green");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10227");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10:27");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("James Smith");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.01");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10228");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("11:12");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Nora Allen");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10229");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("13:56");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Robyn Mason");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.07");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10230");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:40");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Ralph Burke");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.06");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10231");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:25");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Patty Prince");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.02");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10232");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10:09");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Natasha Green");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10233");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("12:54");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("James Smith");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.03");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10259");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("11:28");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Francis Stevens");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10235");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("18:22");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Roger Peters");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.03");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10236");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("09:07");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Nora Allen");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.02");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10224");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("12:14");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Scott Lewis");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Circuit Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.09");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10225");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/30/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:58");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Scott Fox");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Zig Zag Coder");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.1");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10239");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("17:20");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Marian Rodriguez");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Zig Zag Coder");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.06");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10240");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:04");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Joe Lawrence");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.07");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10241");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10:49");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Francis Stevens");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10242");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("13:33");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Lynda Evans");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.05");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10243");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("16:18");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Keith Clark");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Circuit Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10244");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("19:02");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Kara Wood");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10245");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("09:46");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Juan Jacobs");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.07");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10237");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("13:51");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Samuel Green");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.15");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10265");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:36");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Alison Thompson");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Circuit Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.1");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10248");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("18:07");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Jerry Wright");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.07");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10234");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("15:38");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Nora Allen");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Plan Smart");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.1");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10238");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('6/29/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:36");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Mark Moore");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Webcom Services");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.09");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10246");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("12:31");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Patty Prince");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10252");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("16:57");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("James Smith");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.02");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10253");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("18:42");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Marian Rodriguez");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Zig Zag Coder");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.01");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10254");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("09:46");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Patty Prince");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10255");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("12:31");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Jack Sims");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Circuit Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10256");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("15:15");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Hannah Watson");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.01");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10257");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("18:07");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Gregory Morrison");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Webcom Services");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.04");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10258");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:44");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Joe Lawrence");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10249");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:44");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Edward Hall");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Zig Zag Coder");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10260");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("14:13");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Glenda White");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Webcom Services");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.05");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10261");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("16:57");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Lynda Evans");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.01");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10262");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:48");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Edward Hall");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Zig Zag Coder");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.04");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10250");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/1/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("11:28");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Jerry Wright");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.08");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10264");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("13:51");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Jerry Wright");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("2 days");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10263");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("09:07");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Charles Miller");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Complete Tech");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.1");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10266");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("17:20");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Alison Ross");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Excella");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("express");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.02");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10267");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("08:04");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Alexandra Kennedy");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Webcom Services");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("regular");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0.05");
$cell->textAlign("center");
$cell->format("0%");
 
    
$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10268");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value(date('7/2/2014'));
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("10:49");
$cell->textAlign("center");
$cell->format("hh:mm");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Agnes Hill");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("Integra Design");
$cell->textAlign("left");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("1 day");
$cell->textAlign("center");
 
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$row->addCell($cell);

$cell->value("0");
$cell->textAlign("center");
$cell->format("0%");
 
    

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(80);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(100);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(100);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(150);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(150);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(130);
$sheet->addColumn($column);

$column = new \Kendo\UI\SpreadsheetSheetColumn();
$column->width(130);
$sheet->addColumn($column);


echo $spreadsheet->render();
?>
<style>
	#spreadsheet {
		width: 100%;
	}
</style>
<!-- Include JSZip to enable Excel Export-->
<script src="../content/shared/js/jszip.min.js"></script>