We're sorry GroupDocs doesn't work properply without JavaScript enabled.

Free Support Forum - groupdocs.com

GetViewInfo returns hidden Excel worksheets in .NET

GetViewInfo returns the wrong (hidden) worksheet names for this file:
Classeur1.zip (6.1 KB)

We are using GroupDocs.Viewer 21.5.0 with this code:

        using (var viewer = new Viewer(documentPath))
        {                
            var infoOpts = ViewInfoOptions.ForHtmlView();
            infoOpts.SpreadsheetOptions = ViewOpts.SpreadsheetOptions.ForOnePagePerSheet();
            infoOpts.SpreadsheetOptions.RenderHeadings = true;
            infoOpts.SpreadsheetOptions.RenderGridLines = true;
            var info = viewer.GetViewInfo(infoOpts);

The viewing info contains information about sheet 1 and 2 (feuil1 and feuil2)

When adding this line, all sheets are shown correctly:

            infoOpts.RenderHiddenPages = true;

Basically RenderHiddenPages is not working as expected if set to “false”.
As we don’t want to render hidden pages, the hidden worksheets should not appear, only the visible ones.

@Clemens_Pestuka

This issue has been logged in our bug tracker with ID VIEWERNET-3328. We’ll le you know when it will be fixed.

1 Like

@Clemens_Pestuka

This issue has been fixed. The fix will be included in the next version that is planned to release by the end of this week. Please note that the release can be shifted to the next week in case of unexpected issues. We’ll let you know when the new version will be available.

1 Like

@vladimir.litvinchik

Wow that was super fast :+1:
Thanks you :slight_smile:

1 Like

@Clemens_Pestuka

You’re welcome!

@Clemens_Pestuka

GroupDocs.Viewer for .NET v21.6 that includes fix for this issue has been published. You can find the new version at

Have a nice day!

1 Like