Kendo Copy Data from Excel

Copy Data from Excel

by vrluckyin India

HTML

<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2016.2.607/styles/kendo.common.min.css">
<link rel="stylesheet" href="//kendo.cdn.telerik.com/2016.2.607/styles/kendo.rtl.min.css">
<link rel="stylesheet" href="//kendo.cdn.telerik.com/2016.2.607/styles/kendo.silver.min.css">
<link rel="stylesheet" href="//kendo.cdn.telerik.com/2016.2.607/styles/kendo.mobile.all.min.css">
<script src="//code.jquery.com/jquery-1.12.4.min.js"></script>
<script src="//kendo.cdn.telerik.com/2016.2.607/js/jszip.min.js"></script>
<script src="//kendo.cdn.telerik.com/2016.2.607/js/kendo.all.min.js"></script>
<div id="grid" tabindex="0"></div>

JavaScript

$("#grid").kendoGrid({
				excel: {
                fileName: "EquipmentsList.xlsx",
            },
        columns: [
            {
                field: "IsEngOk", title: "Eng Ok", width: 70,
                template: '<input type="checkbox" class="EngineeringOk" name="IsEngOk" #= IsEngOk ? \'checked="checked"\' : "" # #= IsLocked ? disabled="disabled" : "" #></input>',
                filterable: false,
                locked: true
            },
            {
                field: "POSerialNum",
                title: "PO #",
                width: 120,
                hidden: true
            },
            {
                field: "ActivityCode",
                title: "Act Code",
                locked: true,
                width: 120
            },
            {
                field: "Rev",
                title: "Rev",
                width: 60,
                locked: true
            },
            {
                field: "SystemCode0Title",
                title: "Sys_Id",
                width: 120,
                locked: true
            },
            {
                field: "SystemCode1",
                title: "Sys 1",
                width: 100,
                locked: true
            },
            {
                field: "EqpName",
                title: "Eqp Name",
                width: 120,
                locked: true
            },
            {
                field: "TagTitle",
                title: "Tag",
                width: 120,
            },
            {
                field: "EquipmentNum",
                title: "Eqp #",
                width: 120
            },
            {
                field: "EqpType",
                title: "Type",
                width: 150
            },
            {
                field: "Qty",
                title: "Qty",
                width: 80
            },
            {
                field: "Material",
                title: "Material",
                width: 120
           ...