Back to all examples
PHP
<?php

ini_set('display_startup_errors',1);
ini_set('display_errors',1);
error_reporting(-1);

require_once '../lib/Kendo/Autoload.php';

$spreadsheet = new \Kendo\UI\Spreadsheet('spreadsheet');

$sheet = new \Kendo\UI\SpreadsheetSheet();
$sheet->name("Food Order")
      ->mergedCells(array("A1:G1", "C15:E15"));

$spreadsheet->addSheet($sheet);

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

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

$cell->value("Invoice #52 - 06/23/2015");
$cell->fontSize(32);
$cell->textAlign("center");
$cell->background("rgb(96,181,255)");
$cell->color("white");


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

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

$cell->value("ID");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Product");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Quantity");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Price");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Tax");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Amount");
$cell->textAlign("center");
$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(167,214,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("216321");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Calzone");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("1");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("12.39");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C3*D3*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C3*D3+E3");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("546897");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Margarita");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("2");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("8.79");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C4*D4*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C4*D4+E4");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("456231");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Pollo Formaggio");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("1");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("13.99");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C5*D5*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C5*D5+E5");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("455873");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Greek Salad");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("1");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("9.49");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C6*D6*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C6*D6+E6");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("456892");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Spinach and Blue Cheese");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("3");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("11.49");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C7*D7*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C7*D7+E7");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("546564");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Rigoletto");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("1");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("10.99");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C8*D8*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C8*D8+E8");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("789455");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Creme Brulee");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("5");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("6.99");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C9*D9*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C9*D9+E9");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("123002");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Radeberger Beer");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("4");
$cell->textAlign("center");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("4.99");
$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C10*D10*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C10*D10+E10");
$cell->format("$#,##0.00");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->value("564896");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Budweiser Beer");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("3");
$cell->textAlign("center");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("4.49");
$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C11*D11*0.2");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("C11*D11+E11");
$cell->format("$#,##0.00");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(229,243,255)");
$cell->color("rgb(0,62,117)");


$row = new \Kendo\UI\SpreadsheetSheetRow();

$sheet->addRow($row);

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(255,255,255)");
$cell->color("rgb(0,62,117)");


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

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->value("Tip:");
$cell->textAlign("right");
$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("SUM(F3:F11)*0.1");
$cell->format("$#,##0.00");

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");


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

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

$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->index(1);
$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->index(2);
$cell->value("Total Amount:");
$cell->fontSize(20);
$cell->textAlign("right");
$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

$cell->index(5);
$cell->fontSize(20);
$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");
$cell->formula("SUM(F3:F14)");
$cell->format("$#,##0.00");

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

$cell->index(6);
$cell->background("rgb(193,226,255)");
$cell->color("rgb(0,62,117)");

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

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

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

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

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

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

echo $spreadsheet->render();
?>

<!-- Include JSZip to enable Excel Export-->
<script src="../content/shared/js/jszip.min.js"></script>