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 (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
-
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
-
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
-
Jane.Bai
-
- Posts: 1156
- Joined: Tue Nov 29, 2016 1:47 am