Spire.XLS API

IXLSRange ExpandGroup Method (GroupByType, ExpandCollapseFlags)

Expands current group.

Examples

The following code illustrates how to perform ExpandGroup in the Range with collapse option:

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Expand group with flag set to expand parent</para><para>worksheet.Range["A5:A15"].ExpandGroup(GroupByType.ByRows, ExpandCollapseFlags.ExpandParent);</para><para>//Save to file</para><para>workbook.SaveToFile("ExpandGroup.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

void ExpandGroup(
	GroupByType groupBy,
	ExpandCollapseFlags flags
)

Sub ExpandGroup ( 
	groupBy As GroupByType,
	flags As ExpandCollapseFlags
)

void ExpandGroup(
	GroupByType groupBy, 
	ExpandCollapseFlags flags
)

abstract ExpandGroup : 
groupBy : GroupByType * 
flags : ExpandCollapseFlags -> unit

Parameters

groupBy: Type: Spire.Xls GroupByType
This parameter specifies whether the grouping should be performed by rows or by columns.
flags: Type: Spire.Xls ExpandCollapseFlags
Additional option flags.

Reference

IXLSRange Interface

ExpandGroup Overload

Spire.Xls.Core Namespace

IXLSRange AddLanguageSpecificTextSet("LSTA2A2B943_0?cpp=::|nu=."); ExpandGroup Method (GroupByType, ExpandCollapseFlags)

Parameters

Reference

IXLSRange ExpandGroup Method (GroupByType, ExpandCollapseFlags)