合并单元格，并赋值

来源：互联网发布：知乎中药学读后感编辑：程序博客网时间：2024/05/17 02:15

/// <summary>
  /// 合并单元格，并赋值，对每个WorkSheet操作
  /// </summary>
  /// <param name="beginRowIndex">开始行索引</param>
  /// <param name="beginColumnIndex">开始列索引</param>
  /// <param name="endRowIndex">结束行索引</param>
  /// <param name="endColumnIndex">结束列索引</param>
  /// <param name="text">合并后Range的值</param>
  public void MergeCells(int beginRowIndex,int beginColumnIndex,int endRowIndex,int endColumnIndex,string text)
  {
   for(int i=1;i<=this.WorkSheetCount;i++)
   {
    workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(i);
    range = workSheet.get_Range(workSheet.Cells[beginRowIndex,beginColumnIndex],workSheet.Cells[endRowIndex,endColumnIndex]);

    range.ClearContents();  //先把Range内容清除，合并才不会出错
    range.MergeCells = true;
    range.Value = text;
    range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
    range.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
   }
  }

  /// <summary>
  /// 合并单元格，并赋值，对指定WorkSheet操作
  /// </summary>
  /// <param name="sheetIndex">WorkSheet索引</param>
  /// <param name="beginRowIndex">开始行索引</param>
  /// <param name="beginColumnIndex">开始列索引</param>
  /// <param name="endRowIndex">结束行索引</param>
  /// <param name="endColumnIndex">结束列索引</param>
  /// <param name="text">合并后Range的值</param>
  public void MergeCells(int sheetIndex,int beginRowIndex,int beginColumnIndex,int endRowIndex,int endColumnIndex,string text)
  {
   if(sheetIndex > this.WorkSheetCount)
   {
    this.KillExcelProcess();
    throw new Exception("索引超出范围，WorkSheet索引不能大于WorkSheet数量！");
   }

   workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(sheetIndex);
   range = workSheet.get_Range(workSheet.Cells[beginRowIndex,beginColumnIndex],workSheet.Cells[endRowIndex,endColumnIndex]);

   range.ClearContents();  //先把Range内容清除，合并才不会出错
   range.MergeCells = true;
   range.Value = text;
   range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
   range.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
  }