c#导出EXCEL合并单元格代码并且内容居中

 

Excel.Worksheet xlsheet = (Excel.Worksheet)xlbook.Worksheets[1];
Excel.Range range = xlsheet.get_Range(xlapp.Cells[1, 1], xlapp.Cells[1, dt.Columns.Count]);

range = xlsheet.get_Range(xlsheet.Cells[dt.Rows.Count , 1], xlsheet.Cells[dt.Rows.Count , 5]); //取得合并的区域
range.MergeCells = true;//每次合并单元格这句代码都要
range = xlsheet.get_Range(xlsheet.Cells[dt.Rows.Count + 1, 1], xlsheet.Cells[dt.Rows.Count + 1, 5]); //取得合并的区域
range.MergeCells = true;//每次合并单元格这句代码都要