[SPREAD/WINFORM] 헤더 셀 병합하기

// 컬럼 헤더에서 행 수를 설정한다.
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;

// 행 헤더에서 컬럼 수를 설정한다.
fpSpread1.ActiveSheet.RowHeader.ColumnCount = 2;

// 셀 병합 컬럼 헤더 레이블을 정의한다.
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "Fiscal Year 2004";

fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 0].Text = "1st Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 2].Text = "2nd Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 4].Text = "3rd Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 6].Text = "4th Quarter";

fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 0].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 1].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 2].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 3].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 4].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 5].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 6].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 7].Text = "West";

// 컬럼 헤더 셀 병합을 정의한다.
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8);

// 셀 병합 행 헤더 레이블을 정의한다.
fpSpread1.ActiveSheet.RowHeader.Cells[0, 0].Text ="Branch #";

// 행 헤더 셀 병합을 정의한다.
fpSpread1.ActiveSheet.AddRowHeaderSpanCell(0, 0, 12, 1);