Radspreadsheet navigation

4 posts, 0 answers
  1. Regis L
    Regis L avatar
    2 posts
    Member since:
    Oct 2009

    Posted 25 May 2016 Link to this post

    1. Is there a server/client code for loading multiple excel files into multiple sheets ?

    2. Is there a server/client code for navigating between sheets ( only see get_ActiveSheet() in client code)

    3. When exporting excel file from Spreadsheet, it only export current active sheet data to an excel file, is a way to export all the sheet data into an excel file ?

    Regards, 

     

  2. Helen
    Admin
    Helen avatar
    1052 posts

    Posted 30 May 2016 Link to this post

    Hello,

    Up to your questions.

    1. You may load one excel file with many sheets by using this code:
    spreadsheet.fromFile(file);
    as shown in the example below:
    https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx

    2. We haven't such a method. All available methods are listed here:

    http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/objects/radspreadsheet

    3. When exporting data from spreadsheet, all sheets are exported. You may test the behavior here:

    https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx

    - add few sheets
    - click the 'Export to Excel' button
    All sheets are exported.

    Hope it helps.

    Regards,
    Helen
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  3. Norbert
    Norbert avatar
    2 posts
    Member since:
    Sep 2015

    Posted 09 Nov Link to this post

    Hello,

    I'll try your example "Spreadsheet - Import to Excel File". Here I get
    the following error message: "Runtime Error in Javascript: The object
    does not support the method "fromFile".

    I use Telerik.Web.UI, Version 2015.3.1111.45.

     

  4. Norbert
    Norbert avatar
    2 posts
    Member since:
    Sep 2015

    Posted 10 Nov in reply to Norbert Link to this post

    With Version 2016.2.607 it works.
Back to Top