GrapeCity.Documents.Excel.XlsxSaveOptions.ExcludeEmptyRegionCells

ExcludeEmptyRegionCells Property

ExcludeEmptyRegionCells

Gets or sets whether to exclude empty cells outside the used data range when saving the workbook.

Empty cells in this context are cells that contain no data or only style information. The default value is false.

Declaration

public bool ExcludeEmptyRegionCells { get; set; }

Public Property ExcludeEmptyRegionCells As Boolean

Examples

XlsxSaveOptions options = new XlsxSaveOptions();
options.ExcludeEmptyRegionCells = true;
bool excludeEmptyRegionCells = options.ExcludeEmptyRegionCells;
workbook.Save("path/to/output.xlsx", options);