Hide all worksheets except the active worksheet

[Praveen]

Hello,

 

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

 

Thanks

[Tanya]

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

[Nicklas]

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]);
                }

});

[Martin]

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