Bind Spreadsheet with imported excel

[Omar]

I have a Spreadsheet which already Bind to an object (see below code). I want to open a file (import) and Bind it with my existing binding.

@(Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheetsbar(false)
.Toolbar(x => x.Data(false).Insert(false))
.HtmlAttributes(new { style = "width:100%;" })
.Rows(5000)
.Events(e => e.ExcelImport("ImportProduct"))
.Sheets(sheets =>
{
sheets.Add()
.Name("Product")
.DataSource<MyCompany.DTO.Logistics.Planning.ProductSearchResultDTO>(ds => ds
.Ajax()
.Batch(true)
.Read(r => r.Action("ProductBulkSearchResults", "Logistics").Data("getCriteria"))
.Update(u => u.Action("ProductBulkUpdate", "Logistics").Data("getCriteria"))
.Events(e => e.Change("onChange"))
.Model(m =>
{
m.Id(p => new { p.ProductID, p.ORGID });
})
)
.Columns(columns =>
{
columns.Add().Width(100);
columns.Add().Width(415);
columns.Add().Width(0);
columns.Add().Width(0);
columns.Add().Width(145);
})
;
})
)

[Ivan Danchev]

Hello Omar,

A file can be imported in the Spreadsheet through the fromJSON method, which you can see in action in the following demo. As you can see in the Upload's success handler:

success: function (e) {
                // Load the converted document into the spreadsheet
                spreadsheet.fromJSON(e.response);
            }

the data is loaded from the response and it does not use the existing binding. Calling this method simple removes all the existing data and loads the one saved in the response. So binding the Spreadsheet to an object and importing a file are two different approaches of loading data.

Regards,
Ivan Danchev
Telerik by Progress