Back to all examples

Disable cells

PHP 
<?php

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

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


?>
<div class="box wide">
    <div class="box-col">
    <h4>Disable cells</h4>
    <ul class="options">
        <li>
            <button class="k-button" id="toggle">Disable / Enable 'Quantity' column</button>
        </li>
    </ul>
    </div>
</div>
<?php
$spreadsheet = new \Kendo\UI\Spreadsheet('spreadsheet');

$spreadsheet->attr('style', 'width: 100%;');

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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->enable(false);

$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>
<script>
    $("#toggle").click(function() {
        var range = $("#spreadsheet").data("kendoSpreadsheet").activeSheet().range("C3:C11");
        var enabled = range.enable();

        if (enabled === null) {
            enabled = true;
        }

        //Enable / disable specified range
        range.enable(!enabled);
    });
</script>