真的非常抱歉,给您回复晚了。
在WinForm平台下,支持合并XLSheet的单元格。
为了合并单元格,需要使用MergeCells属性添加合并的区域。
代码参考:
- //Select range to Merge
- XLCellRange _ColRange = new C1.C1Excel.XLCellRange(4, 6, 0, 8);
- XLCellRange _RowRange = new C1.C1Excel.XLCellRange(9, 21, 3, 4);
- // Set Text for Merged Cells
- c1XLBook1.Sheets[0][4, 0].Value = "Merged Cells";
- c1XLBook1.Sheets[0][9, 3].Value = "Merged Cells";
- //Merge Cells
- c1XLBook1.Sheets[0].MergedCells.Add(_ColRange);
- c1XLBook1.Sheets[0].MergedCells.Add(_RowRange);
复制代码
您还可以给合并的单元格设置样式:
- //Define and Apply Styles for Merged Cellss
- XLStyle _Colstyle = new C1.C1Excel.XLStyle(c1XLBook1);
- _Colstyle.BackColor = Color.Yellow;
- XLStyle _Rowstyle = new XLStyle(c1XLBook1);
- _Rowstyle.BackColor = Color.AliceBlue;
- c1XLBook1.Sheets[0][4, 0].Style = _Colstyle;
- c1XLBook1.Sheets[0][9, 3].Style = _Rowstyle;
复制代码 |