复制列

/// <summary>
  /// 复制列（在指定列右边复制指定数量列）
  /// </summary>
  /// <param name="columnIndex"></param>
  /// <param name="count"></param>
  public void CopyColumns(int columnIndex,int count)
  {
   try
   {
    for(int n=1;n<=this.WorkSheetCount;n++)
    {
     workSheet = (Excel.Worksheet)workBook.Worksheets[n];
//     range1 = (Excel.Range)workSheet.Columns[columnIndex,this.missing];
     range1 = (Excel.Range)workSheet.get_Range(this.IntToLetter(columnIndex)+"1",this.IntToLetter(columnIndex)+"10000");

     for(int i=1;i<=count;i++)
     {
//      range2 = (Excel.Range)workSheet.Columns[this.missing,columnIndex + i];
      range2 = (Excel.Range)workSheet.get_Range(this.IntToLetter(columnIndex+i)+"1",this.IntToLetter(columnIndex+i)+"10000");
      range1.Copy(range2);
     }
    }
   }
   catch(Exception e)
   {
    this.KillExcelProcess();
    throw e;
   }
  }

  /// <summary>
  /// 复制列（在指定WorkSheet指定列右边复制指定数量列）
  /// </summary>
  /// <param name="sheetIndex"></param>
  /// <param name="columnIndex"></param>
  /// <param name="count"></param>
  public void CopyColumns(int sheetIndex,int columnIndex,int count)
  {
   if(sheetIndex > this.WorkSheetCount)
   {
    this.KillExcelProcess();
    throw new Exception("索引超出范围，WorkSheet索引不能大于WorkSheet数量！");
   }

   try
   {
    workSheet = (Excel.Worksheet)workBook.Worksheets[sheetIndex];
//    range1 = (Excel.Range)workSheet.Columns[Type.Missing,columnIndex];
    range1 = (Excel.Range)workSheet.get_Range(this.IntToLetter(columnIndex)+"1",this.IntToLetter(columnIndex)+"10000");

    for(int i=1;i<=count;i++)
    {
//     range2 = (Excel.Range)workSheet.Columns[Type.Missing,columnIndex + i];
     range2 = (Excel.Range)workSheet.get_Range(this.IntToLetter(columnIndex+i)+"1",this.IntToLetter(columnIndex+i)+"10000");
     range1.Copy(range2);
    }
   }
   catch(Exception e)
   {
    this.KillExcelProcess();
    throw e;
   }
  }