Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Nov 16, 2021 11:00 pm

Good Afternoon,
I am currently trying to port over some existing Excel interop code. I have come across something that is being used in the existing code base that I cannot find an equivalent for in Spire.XLS.
I am hoping you might be able to help me with an alternative means of achieving a similar goal. The snippet (using interop) I am attempting to replace is as follows...
Code: Select all
            Worksheet currentWs = (Worksheet)_workbook.Worksheets[1];
            currentWs.Outline.ShowLevels(level, 0);


Is there something I can use to replace the above?

Thank you

Bandonia
 
Posts: 34
Joined: Tue Nov 16, 2021 9:40 pm

Wed Nov 17, 2021 10:20 am

Hello,

Thanks for your inquiry.
Please refer to the following code to set the Outline Group. If there is any question, please feel free to contact us.
Code: Select all
sheet.GroupByRows(1, 8,false);

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Return to Spire.XLS