为什么我C#导出的EXCEL文件不能合并单元格？

[crsp]

如题？

[crsp]

代码:
object oMissing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.ApplicationClass();

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet xlWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
xlWorksheet.Cells.WrapText = true;
xlWorkbook.Worksheets.get_Item(1);
xlWorksheet.Name = "导出";
xlWorksheet.Activate();

xlWorksheet.Cells.get_Range(xlWorksheet.Cells[1, 1], xlWorksheet.Cells[1, 1]).Columns.ColumnWidth = 5;
workbook.SaveAs("bom.xls", oMissing, oMissing, oMissing, oMissing, oMissing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, oMissing, oMissing, oMissing, oMissing, oMissing);
xlApp.Quit();

[zhu_gx]

帮你顶

[朝圆夜不圆]

你没写合并的代码他怎么合并

[crsp]

程序中是可以合并的，但是导出来之后的excel，合并的属性是不能用的。

[crsp]

自己顶顶！！高人给个答案！

[朝圆夜不圆]

XlSaveAsAccessMode.xlExclusive你把保存的类型变成这个试试

[crsp]

O了，多谢！

[luork_2008]

看看结果