EXCEL如何合并单元格？

[FIRSTVIP]

ASP.NET如何操作excel?迷茫，给个例子吧！

[zwp315]

Excel.Application excel = new Excel.Application ( ) ;
Excel._Worksheet oSheet;
excel.Application.Workbooks.Add ( true ) ;
excel.Visible = true ;
excel.Cells[ 1 , 1 ] = "第一行第一列" ;
excel.Cells[ 1, 2]="第二行第二列";
excel.Cells[2,1]=" 第一行第二列";

[zwztu]

http://www.microsoft.com/china/msdn/library/dnexcl2k2/html/odc_offcs.asp
参考一下这篇文章。

[FIRSTVIP]

自己UP....

[zwp315]

合并单元格：
Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;
Excel.Range oRng;

oSheet = (Excel._Worksheet)oWB.ActiveSheet;
oSheet.get_Range(oSheet.Cells[3,4],oSheet.Cells[6,8]).Value="合并单元格";
//这个很重要，
oSheet.get_Range(oSheet.Cells[3,4],oSheet.Cells[6,8]).Merge(false);

[FIRSTVIP]

我是这样解决的

Excel.Worksheet ExcelWorkSheet=(Excel.Worksheet)ExcelWorkBook.Worksheets[1];

ExcelApp.DisplayAlerts=false;//不显示警告
ExcelWorkSheet.get_Range("A1","I1").Font.Bold=true;
ExcelWorkSheet.get_Range("A1","I1").Value="dddd";
ExcelWorkSheet.get_Range("A1","I1").Merge(false);
ExcelWorkSheet.Name="test";