Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width50%
Panel
titleBGColor#B0C4DE
titleContents Summary
Table of Contents
stylenone
outlinetrue
typelist
Info

This feature of ignoring empty rows is supported from version 19.1.

Info

The code uses some of the objects defined in: Working with Common Operations.

Background

Sometimes Excel document contains information at the beginning of the worksheet and after that, it contains some count of empty (blank) rows and information again e.g. summary row. Also, there is the possibility that the worksheet contains the empty columns as well. In case, if the number of empty rows or columns is considerably huge, the rendering time increases and hence, it affects the performance. 

The Solution

GroupDocs.Viewer for .NET provides the options, CellsOptions.setIgnoreEmptyRows(bool) which allow omitting to render empty rows as shown in the samples below.

Ignoring Empty Rows

HTML
<script src="https://gist.github.com/GroupDocsGists/fe5e5afdffe466edff59b3d34782927e.js"></script>