OutineLevel

Aspose.Cells Product Family
1

In Excel/VBA you can do the following:
<span style=“font-size: 10pt; font-family: “Courier New”;”>Range(RowNdx & “:” &
RowNdx).EntireRow.OutlineLevel = 2

I have reports with multiple levels of totaling. The data comes from a stored procedure which assigns the proper outline level to each row. In VBA, I would just assign the outline level on each row based on the value from the stored procedure.

Is there any way to do the same thing in Aspose.Cells? I could go through and do multiple groupings on multiple levels, but the code for that would be much uglier.

Thanks

2

Hi,

Well, I am afraid , we don’t support to add or manipulate Excel macros/vba. I think you may try to apply multiple grouping of rows / columns as you are doing already.


Sorry for any inconvenience.