Radspreadsheet navigation

[Regis L]

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, 

 

[Helen]

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

[Norbert]

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.

 

[Norbert]

With Version 2016.2.607 it works.