my cshtml file
@(Html.Kendo().Spreadsheet()
.Name("spreadsheet").HtmlAttributes(new { style = "width:100%;" })
)<script>
$(document).ready( function () {
var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
$.ajax({
type: "POST",
url: '@Url.Action("GetFileFromDetails", "Spreadsheets")',
contentType: "application/json; charset=utf-8",
data: { data: myData },
dataType: "json",
success: function (recData) {
//alert(recData);
spreadsheet.fromJSON(recData.response);
},
error: function (ex) {
alert(ex);
}
});
});
</script>
my controller
[HttpPost] public ActionResult GetFileFromDetails() {
var workbook = Workbook.Load(file.InputStream, Path.GetExtension(file.FileName)); return Content(workbook.ToJson(), Telerik.Web.Spreadsheet.MimeTypes.JSON);
}
[HttpPost] public ActionResult Upload(HttpPostedFileBase file) { var workbook = Workbook.Load(file.InputStream, Path.GetExtension(file.FileName)); return Content(workbook.ToJson(), Telerik.Web.Spreadsheet.MimeTypes.JSON); }