Skip rendering of empty rows

Sometimes Excel document contains information at the beginning of the worksheet and after that, it contains some count of empty (blank) rows. In case, if the number of empty rows is considerably huge, the rendering time increases and hence, it affects the performance.

The Solution

To skip rendering of empty rows GroupDocs.Viewer provides SkipEmptyRows property of SpreadsheetOptions class, which allow omitting to render empty rows as shown in the sample below:

using (Viewer viewer = new Viewer("sample.xlsx"))
{
    HtmlViewOptions viewOptions = HtmlViewOptions.ForEmbeddedResources();
    viewOptions.SpreadsheetOptions.SkipEmptyRows = true;
    viewer.View(viewOptions);
}

More resources

View Excel Files Online

Along with full-featured .NET library we provide simple but powerful free online Apps. View Excel XLS, XLSX, and XLSB files online with GroupDocs Viewer App.

GitHub Examples

You may easily run the code above and see the feature in action in our GitHub examples: