C# 创建Excel多级分组

Free Spire.XLS for .NET 8.3 (社区版)

Visual Studio

步骤 1：创建一个Wordbook类对象,获取第一个工作表Workbook workbook = new Workbook();Worksheet sheet = workbook.Worksheets[0];

步骤 2：写入数据到单元格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 = '售后支持';

步骤 3：设置IsSummaryRowBelow属性为false, 即总结行显示在明细行上方sheet.PageSetup.IsSummaryRowBelow = false;

步骤 4：选择行进行分组，参数false表示展开当前分组，如需隐藏，设置成true//选择行进行一级分组sheet.GroupByRows(2, 13, false);//选择行进行二级分组sheet.GroupByRows(4,5 , false);sheet.GroupByRows(7, 8, false);sheet.GroupByRows(10,13 , false);//选择行进行三级分组sheet.GroupByRows(12,13, true);

步骤 5：定义一个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;

步骤 6：设置区域边框样式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);

步骤 7：保存文档workbook.SaveToFile('output.xlsx', ExcelVersion.Version2013);