SpreadsheetEditOptions.ExcludeHiddenWorksheets Property - GroupDocs.Editor for .NET

SpreadsheetEditOptionsExcludeHiddenWorksheets Property

Allows to exclude hidden worksheets in the input Spreadsheet document, so they will be totally ignored. Default is false - hidden worksheets are available and processed as normal.

Namespace: GroupDocs.Editor.Options
Assembly: GroupDocs.Editor (in GroupDocs.Editor.dll) Version: 21.10.0.0

Syntax

C++

public bool ExcludeHiddenWorksheets { get; set; }

Public Property ExcludeHiddenWorksheets As Boolean
	Get
	Set

public:
property bool ExcludeHiddenWorksheets {
	bool get ();
	void set (bool value);
}

member ExcludeHiddenWorksheets : bool with get, set

Property Value

Type: Boolean

Remarks

Several binary Spreadsheet formats (like XLSX) support hidden worksheets (tabs) concept. Document of such format, if it has more then one worksheet, may contain additional hidden worksheets. By default such hidden worksheets are available for processing, but with this option it is able to ignore them, like these hidden worksheets are absent and don't exist. When this option is enabled, you cannot select hidden worksheet with the 'WorksheetIndex' property.

Reference

SpreadsheetEditOptions Class

GroupDocs.Editor.Options Namespace