本帖最后由 格落 于 2020-12-3 09:53 编辑
代码和数据设置如下:
//OutlineColumn设置
workSheet.Outline.SummaryRow = SummaryRow.Above;
workSheet.ShowRowOutline = false;
workSheet.OutlineColumn.ColumnIndex = 1;
workSheet.OutlineColumn.ShowImage = true;
workSheet.OutlineColumn.SetCollapsed(1, true);
//数据
string start1 = "B5";
string end1 = "B20";
IRange elementRange1 = Worksheet.Range[$"{start}:{end}"];
elementRange1.Value = "合计";
elementRange1.IndentLevel = 0;
elementRange1.Merge();
string start2 = "B21";
string end2 = "B36";
IRange elementRange2 = Worksheet.Range[$"{start}:{end}"];
elementRange2.Value = "一期";
elementRange2.IndentLevel = 1;
elementRange2.Merge();
string start3 = "B37";
string end3 = "B52";
IRange elementRange3 = Worksheet.Range[$"{start}:{end}"];
elementRange3.Value = "二期";
elementRange3.IndentLevel = 1;
elementRange3.Merge(); |