Unable to fetch worksheet tabs

2 posts, 0 answers
  1. chaitanya
    chaitanya avatar
    1 posts
    Member since:
    May 2019

    Posted 14 May 2019 Link to this post

    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"  '.

     

     

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1220 posts

    Posted 16 May 2019 Link to this post

    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
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top