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 07, 2017 3:49 pm

Hello.

We need four functionalities : Drill, Un-drill and open/close an existing drill.
Could you tell us how to do that ?

Drill.png
Drill.png (103.06 KiB) Viewed 2461 times



Best Regards,

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Nov 08, 2017 3:17 am

Hello,

Thanks for your inquiry. Please refer to the below code snippet to accomplish your task.
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(fileName, ExcelVersion.Version2010);
            Worksheet sheet = workbook.Worksheets[0];
            sheet.GroupByRows(2, 9, false);
            //sheet.GroupByRows(2, 9, true);
            sheet.UngroupByRows(2,9);
            workbook.SaveToFile("result.xlsx");


Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Nov 10, 2017 8:47 am

Hello VincentB,

Greetings from E-iceblue!
Has your issue been resolved?
Your feedback will be greatly appreciated.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Mon Nov 13, 2017 12:56 pm

Hello,

It's work perfectly.

Thanks.

Sincerely,

Vincent

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Nov 15, 2017 1:27 am

Hi VincentB,

Glad to hear that.
Please feel free to contact us if you need further assistance.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS