Free Support Forum - aspose.com

Grouping data on a worksheet

Greetings again!

I am doing research on one more thing. Grouping rows (or columns too, I suppose) so that they can be collapsed and expanded appropriately.
In Excel VBA you might do something like this:

Rows(“2:5”).Select

Selection.Rows.Group

Is this a method anywhere? I’ve looked through the documentation and this forum (naturally) before making a post.

Thanks for all the hard work!

Dear tuc,

Thanks for your consideration.

Currently Aspose.Excel support this feature in designer file, but has not provided a method to do so. I will investigate this feature. Now if you need this feature, you can group rows/columns in your designer file.

I have not purchased your product yet, however, I would like to know if your product supports the following features:
1) Create a Hierarchical Sheet and save that Sheet to hard disk and you open the file with
MS Excel the hierarchical structure will still be there.
2) If #1 is true, can I add rows to child views(of hierarchy) and assign formulas(including
aggregate) to individual cells of the new row.
3) What are the different ways to add data to the grid?


You can email me directly at jbetances@hotmail.com
Thank you for your assistance.

Hi, thanks for your consideration.

It is encouraged to discuss here for technical issues.

1)Yes. Now Aspose.Excel supports this feature in your designer file. And the API support will be available at the end of this month.
2)Yes, you can.
3)No difference.

You can try the following code:

Excel excel = new Excel();

//Open designer file with hierarchical structure
excel.Open(“d:\group.xls”);

excel.Worksheets[0].Cells[“A1”].PutValue(123);
excel.Save(“result.xls”, SaveType.OpenInExcel, FileFormatType.Default, this.Response);