This is a migrated thread and some comments may be shown as answers.

dynamic import excel to spreadsheet

0 Answers 117 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
sabyasachi
Top achievements
Rank 1
sabyasachi asked on 17 Jul 2018, 08:03 AM

I try to import dynamic import of a excel into the spreadsheet for the droopdown selected index changed but i could not able to upload this one successfully

here my code

<script>

    $("#spreadsheet").kendoSpreadsheet({
        excel: {
            // Required to enable Excel Export in some browsers
            proxyURL: "https://demos.telerik.com/kendo-ui/service/export"
        }
    });
    var data = [
                       { text: "Spreed sheet 1", value: "1" },
                       { text: "Spreed sheet 2", value: "2" },
                       { text: "Spreed sheet 3", value: "3" }
    ];
    function onOpen() {
        //kendoConsole.log("event: open");
    };

    function onClose() {
        //  kendoConsole.log("event: close");
    };

    function onChange() {
        //kendoConsole.log("event: change");
    };
    function onDataBound(e) {
        //if ("kendoConsole" in window) {
        //   kendoConsole.log("event :: dataBound");
        //}
    };

    function onFiltering(e) {
        // if ("kendoConsole" in window) {
        //  kendoConsole.log("event :: filtering");
        //}
    }
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    
    //var sheet = spreadsheet.activeSheet();
    //sheet.setDataSource(data1);
    function onSelect(e) {
        //if ("kendoConsole" in window) {
        if (e.item) {
            alert();
                return $.ajax({
                    method: "GET",
                    url: "ExcelToJson",// the return json will be var data1 = [
  {
      "a": 1.0,
      "b": 2.0,
      "c": 3.0
  }
    ]
                }).then(function (data) {
                    if (data.success == false) {
                        //ConfirmMessage.showErrorMessage(data.messages[0]);
                        return new $.Deferred().reject().promise();
                    } else {
                        console.log(data);
                       //$("#spreadsheet").html("");
                       //$("#spreadsheet").kendoSpreadsheet();
                       //var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
                       //var sheet = spreadsheet.activeSheet();
                       var data_new = data;
                        // alert(data_new);
                       spreadsheet.fromJSON(data_new);
                      //  sheet.setDataSource(data_new);
                    }
                });
           
            //$.ajax({
            //    url: "ExcelToJson",
            //    cache: false,
            //    type: "POST",
            //    success: function (html) {
            //        $("#spreadsheet").kendoSpreadsheet();
            //        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
            //        var sheet = spreadsheet.activeSheet();
            //        sheet.setDataSource(data);
            //    }
            //});
        }
    };

    $("#dropdownlist").kendoDropDownList({
        dataTextField: "text",
        dataValueField: "value",
        dataSource: data,
        filter: "startswith",
        select: onSelect,
        //change: onChange,
        //close: onClose,
        open: onOpen,
        filtering: onFiltering,
        dataBound: onDataBound
    });


    
</script>

No answers yet. Maybe you can help?

Tags
Spreadsheet
Asked by
sabyasachi
Top achievements
Rank 1
Share this question
or