using System;

 using System.Drawing;

 using Spire.Xls;

 namespace MultilevelGroup_XLS

 {

     class Program

     {

         static void Main(string[] args)

         {

             //创建一个Wordbook类对象,获取第一个工作表

             Workbook workbook = new Workbook();

             Worksheet sheet = workbook.Worksheets[];

             //写入数据到单元格

             sheet.Range["A1"].Value = "公司部门";

             sheet.Range["A3"].Value = "综合部";

             sheet.Range["A4"].Value = "行政";

             sheet.Range["A5"].Value = "人事";

             sheet.Range["A6"].Value = "市场部";

             sheet.Range["A7"].Value = "业务部";

             sheet.Range["A8"].Value = "客服部";

             sheet.Range["A9"].Value = "技术部";

             sheet.Range["A10"].Value = "技术开发";

             sheet.Range["A11"].Value = "技术支持";

             sheet.Range["A12"].Value = "售前支持";

             sheet.Range["A13"].Value = "售后支持";

             //设置IsSummaryRowBelow为false, 即总结行显示在明细行上方

             sheet.PageSetup.IsSummaryRowBelow = false;

             //选择行进行一级分组

             //参数false表示展开当前分组，若要隐藏设置成true

             sheet.GroupByRows(, , false);

             //选择行进行二级分组

             sheet.GroupByRows(, , false);

             sheet.GroupByRows(, , false);

             sheet.GroupByRows(, , false);

             //选择行进行三级分组

             sheet.GroupByRows(,, true);

             //定义一个CellStyle对象，设置并运用单元格内字体格式

             CellStyle style = workbook.Styles.Add("style");

             style.Font.IsBold = true;

             style.Color = Color.LawnGreen;

             sheet.Range["A1"].CellStyleName = style.Name;

             sheet.Range["A3"].CellStyleName = style.Name;

             sheet.Range["A6"].CellStyleName = style.Name;

             sheet.Range["A9"].CellStyleName = style.Name;

             //设置区域边框样式

             sheet.Range["A4:A5"].BorderAround(LineStyleType.Thin);

             sheet.Range["A4:A5"].BorderInside(LineStyleType.Thin);

             sheet.Range["A7:A8"].BorderAround(LineStyleType.Thin);

             sheet.Range["A7:A8"].BorderInside(LineStyleType.Thin);

             sheet.Range["A10:A13"].BorderAround(LineStyleType.Thin);

             sheet.Range["A10:A13"].BorderInside(LineStyleType.Thin);

             //保存文档

             workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);

             System.Diagnostics.Process.Start("output.xlsx");

         }

     }

 }