请教怎样使用C#控制Excel组合行

[as12a]

using Microsoft.Office.Interop.Excel;

版本是11.0,也就是Office2003，批注，函数，宏什么的都解决了

组合行的功能怎么实现，最好附上代码

[xinbin1122]

span

[hyblusea]

// 合并单元格
private void mergeUnit(string sStartUnit, string sEndUnit, _Worksheet worksheet)
{
    Range rg = worksheet.get_Range( sStartUnit, sEndUnit);
    rg.Select();
    rg.Merge(Type.Missing);
    rg.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
    //rg.Font.Size = 10;
    rg.Font.Bold = true;
    //rg.Interior.ColorIndex = 15;
}

// 组合Excel 行
private void groupRow(string sStartUnit, string sEndUnit, _Worksheet worksheet)
{
    Range rg = (Excel.Range)worksheet.Rows[sStartUnit + ":" + sEndUnit, Type.Missing];
    rg.Select();
    rg.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}

[silentwins]

 Excel.Range range = xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, 2]);
                    range.MergeCells = true;

[liherun]

mark