Skip rendering of empty columns

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

The Solution

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

using (Viewer viewer = new Viewer("sample.xlsx"))
    HtmlViewOptions viewOptions = HtmlViewOptions.ForEmbeddedResources();
    viewOptions.SpreadsheetOptions.SkipEmptyColumns = true;

© Aspose Pty Ltd 2001-2022. All Rights Reserved.