MergeCels合并单元格.docVIP

MergeCells合并单元格 C#操作Excel 2011-03-21 14:42:58 阅读18 评论0 ??字号：大中小?订阅 ?/// summary??/// 合并单元格，并赋值，对指定WorkSheet操作??/// /summary??/// param name=beginRowIndex开始行索引/param??/// param name=beginColumnIndex开始列索引/param??/// param name=endRowIndex结束行索引/param??/// param name=endColumnIndex结束列索引/param??/// param name=text合并后Range的值/param??private void MergeCells(Excel.Worksheet sheet,int beginRowIndex,int beginColumnIndex,int endRowIndex,int endColumnIndex,string text)??{???if(sheet == null)????return; ???range = sheet.get_Range(sheet.Cells[beginRowIndex,beginColumnIndex],sheet.Cells[endRowIndex,endColumnIndex]);???????range.ClearContents();??//先把Range内容清除，合并才不会出错???range.MergeCells = true;???range.Value = text;???range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;???range.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;??} //产生一个Excel.Application的新进程Excel.Application app = new Excel.Application();if (app == null) {statusBar1.Text = ERROR: EXCEL couldnt be started!;return ;}app.Visible = true; //如果只想用程序控制该excel而不想让用户操作时候，可以设置为falseapp.UserControl = true;Workbooks workbooks =app.Workbooks;_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet); //根据模板产生新的workbook// _Workbook workbook = workbooks.Add(c:\\a.xls); //或者根据绝对路径打开工作簿文件a.xlsSheets sheets = workbook.Worksheets;_Worksheet worksheet = (_Worksheet) sheets.get_Item(1);if (worksheet == null) {statusBar1.Text = ERROR: worksheet == null;return;}// This paragraph puts the value 5 to the cell G1Range range1 = worksheet.get_Range(A1, Missing.Value);if (range1 == null) {statusBar1.Text = ERROR: range == null;return;}const int nCells = 2345;range1.Value2 = nCells;二、示例程序在Visual Studio .NET中建立一个C# WinForm工程. 添加Microsoft Excel Object Library引用: 右键单击Project , 选“添加引用” 在COM 标签项，选中 locate Microsoft Excel Object Library 点确定按钮完成添加引用。 On the View menu, select Toolbox to display the Toolbox. Add two buttons and a check box to Form1. 在Form1上添加一个button1，双击 Button1