Group & Ungroup Rows & Columns
Apply group and ungroup of rows & columns with intuitive APIs without using Office Interop with
Group & Ungroup RowsThe
GroupRowsmethod takes index position of rows to apply grouping. Multiple grouping is possible by using the same method again. Use
UngroupRowsmethod to do the ungrouping of rows. This method act like a cutting tool. Apply it to the middle of the row group to cut it into two. However, these two groups of rows will not become different group. For example, apply ungroup 2-4 to group of 0-9 will give the result of a group of 0-1 & 5-9.
Group & Ungroup ColumnsColumns can be group in similar manner as rows. Use
GroupColumnsmethod to group column with either specifying index position of columns or columns name in string. It is also possible to have multiple groups of columns. The ungrouping of columns with
UngroupColumnmethod does not have the same behavior as of row. This method act like a trimming tool instead. It will ungroup from the specified starting position to the end of the column group. For example, apply ungroup D-F to group of A-G will give the result of a column group of A-C. Please note that all the index position mentioned above follows zero-based indexing. Also the grouping can only be applied only as far as the cell contains value.