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>