Mutiple Cell Header

To create multi-row column headers in ReoGrid, you can utilize the ExtensionColumnHeader property of the worksheet. This allows you to extend the column header area vertically to accommodate multiple rows of headers, up to a maximum of 10 rows. The cells within these header rows can be merged horizontally or vertically, and you have the freedom to customize the header text and style as needed. Mutiple Cell Header

Creating Multi-Row Headers

Access the Extension Column Header: First, get a reference to the extension column header from your worksheet.

var extensionHeader = worksheet.ExtensionColumnHeader;

Set the Number of Rows: Define the number of rows for the column headers. You can do this using the RowCount property or the SetRowCount method.

extensionHeader.SetRowCount(3); // Sets the header to have 3 rows

The results are as shown in the following figure. Mutiple Cell Header

Access Cells

Cells in multi-row headers, like cells in a worksheet, have their origin coordinates (0,0) at the top left corner. Mutiple Cell Header

Merging Cells

To merge cells in multi-row headers, use the MergeCells method. You can set the rows and columns you want to combine as parameters.

extensionHeader.MergeCells(int startRow, int startColumn, int rowSpan, int columnSpan)

Create the code below.

// Merge first cell (0, 0)
extensionHeader.MergeCells(0, 0, 3, 1);

// Merge from cell in row 0, 2nd column (0, 1)
extensionHeader.MergeCells(0, 1, 1, 4);

Mutiple Cell Header

Set Cell Text

extensionHeader[0, 0].Text = "No.";
extensionHeader[0, 1].Text = "大分類";

Mutiple Cell Header

Repeat the MergeCells and Text settings to create a multi-line header.

extensionHeader.MergeCells(0, 0, 3, 1);

extensionHeader.MergeCells(0, 1, 1, 4);
extensionHeader.MergeCells(1, 1, 1, 2);
extensionHeader.MergeCells(1, 3, 1, 2);

extensionHeader.MergeCells(0, 5, 3, 1);

extensionHeader.MergeCells(0, 6, 1, 4);
extensionHeader.MergeCells(1, 6, 2, 1);
extensionHeader.MergeCells(1, 8, 2, 2);

extensionHeader[0, 0].Text = "No.";
extensionHeader[0, 1].Text = "大分類";
extensionHeader[1, 1].Text = "中分類";
extensionHeader[1, 3].Text = "中分類";

extensionHeader[0, 6].Text = "大分類";
extensionHeader[2, 1].Text = "小分類";
extensionHeader[2, 2].Text = "小分類";
extensionHeader[2, 3].Text = "小分類";
extensionHeader[2, 4].Text = "小分類";

extensionHeader[0, 5].Text = "対象";