Unable to fetch worksheet tabs

[chaitanya]

Hi, 

 I am new to Kendo UI Spread Sheet Component. Trying to fetch worksheet tab names while importing.

On importing a .xlsx with worksheet tabs, i am trying to fetch  worksheet tabs names with 

' $("#spreadsheet").data("kendoSpreadsheet").sheets(); '  but for the first time i am getting result as a default for every import ' _sheetName: "Sheet1"  '.

 

 

[Veselin Tsvetanov]

Hello Chaitanya,

To get the names of the Sheets on the imported xlsx file, I would suggest you to use the excelImport event of the Spreadsheet:

excelImport: function(e) {
  var spread = e.sender;

  e.promise.done(function() {
    var sheets = spread.sheets();

    sheets.forEach(function(sheet) {
        console.log(sheet.name());
    });
  });
}

Here you will find a small sample implementing the above suggestion.

Regards,
Veselin Tsvetanov
Progress Telerik