Multiple Rows Grouping

Aspose.Cells Product Family
1

Hi

I would like to Grouping rows in multiple levels when i am using this code
Cell.GroupingRows(10,14) to grouping rows. I am not able to create multiple levels of grouping
with this code. Can anybody give your suggestions regarding that.

Thanks in advance.

Viswa

2

Hi,

Well, I don't find any problem grouping rows in multi levels. Following is my sample code which works fine:

Sample code:

Workbook designer = new Workbook();
Worksheet worksheet = designer.Worksheets[0];
//Add some text
for (int i = 0; i < 100; i++)
{
for (int j = 0; j < 3; j++)
{
worksheet.Cells[i, j].PutValue("Dummy content");

}
}

worksheet.Cells.GroupRows(10,14);
worksheet.Cells.GroupRows(11, 13);
designer.Save("f:\\test\\grptemplate.xls");

The created file is attached.

For further reference, please check the following doc:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/groupingungrouping-rows-and-columns.html

If you still find any issue, kindly post your sample code with template excel file, we will check it soon. Also, tell us which version of the component you are using?

Thank you.