This is a migrated thread and some comments may be shown as answers.

Hide all worksheets except the active worksheet

3 Answers 135 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Praveen
Top achievements
Rank 1
Praveen asked on 14 Jun 2017, 02:19 AM

Hello,

 

Can you please let me know how we can hide all worksheets in a workbook except for the active worksheet?

 

Thanks

3 Answers, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 15 Jun 2017, 02:27 PM
Hello Praveen,

As we discussed on the feedback item in our public portal, this feature is currently not supported in RadSpreadsheet. Continue following the item so you can receive notifications when its status changes.

Regards,
Tanya
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which you to write beautiful native mobile apps using a single shared C# codebase.
0
Nicklas
Top achievements
Rank 1
answered on 24 Apr 2020, 09:37 AM

Hi, replying to old topic, but this is how I solved it today when needing it to only save a excel of current sheet.

 

 

 

 

 $("#exportExcelSheet").click(function(e) {
        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

        var activeSheet = $("#spreadsheet").data("kendoSpreadsheet").activeSheet()._sheetName;        
        var sheets = $("#spreadsheet").data("kendoSpreadsheet").sheets();
        $.each(sheets, function( index, value ) {
            if(value._sheetName == activeSheet) {
                } else {
                    $("#spreadsheet").data("kendoSpreadsheet").removeSheet(sheets[index]);
                }

});


0
Martin
Telerik team
answered on 24 Apr 2020, 12:20 PM

Hi Nicklas,

Thank you for the provided feedback and for bringing this to our attention. This functionality is developed and released in our last official release but its status was not updated.

You can change the sheet visibility using APIs (check the Sheets Visibility help topic) or trough the UI using the Sheet Selector`s corresponding tab context menu.

Regards,
Martin
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Tags
Spreadsheet
Asked by
Praveen
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Nicklas
Top achievements
Rank 1
Martin
Telerik team
Share this question
or