Partial worksheet rendering not working for large Excel sheet in .NET

Hi,

I’m getting the following error when trying to render only the first page of a rather large Excel file:
Failed to create image. Use 'SpreadsheetOptions.ForSplitSheetIntoPages()' for partial worksheet rendering.

It did not really matter if I had the suggested line of code or not, the error stayed the same.

            using (var viewer = new Viewer("LargeTable.xlsx"))
            {
                var options = new PngViewOptions("singlePage.png");
                options.SpreadsheetOptions = SpreadsheetOptions.ForSplitSheetIntoPages(40);
                viewer.View(options, 1);
            }

Also using different values for ForSplitSheetIntoPages() did not make any difference.
Passing “1” as parameter to the View command, to only render the first page, also made no change.

LargeTable.zip (3.6 MB)

@Clemens_Pestuka

This issue is reproduced at our end. Hence, we’ve logged it in our internal issue tracking system with ID VIEWERNET-2501 for further investigation and resolution. As there’s any further update, you’ll be notified .

1 Like

The issues you have found earlier (filed as VIEWERNET-2501) have been fixed in this update. This message was posted using Bugs notification tool by atirtahir3