title: copying of specific range of excel cells from one worksheet to another worksheet
body: <p>I am writing a C# program which copies a range of cells from a worksheet of one workbook to a worksheet of an other workbook. But the problem I am facing is I am only able to copy and paste the whole worksheet of first workbook. I want to know how to select only a specific range(from row 5 [column 1 to column 10] to row 100 [column 1 to column 10]) and paste it in second workbook worksheet starting from row 2 column 8. </p>
  
  <p>Also i want to know how a fill a column say from C1 to C100 with some value in a direct way instead of using the loop like below</p>
  
  <pre><code>for(i=1;i&lt;2;i++)
  {
  for(j=1;j&lt;101;i++)
  {
  worksheet.cells[i,j]="Fixed";
  }
  }
  </code></pre>
  
  <p>Here is the code that i have written so far</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using Excel = Microsoft.Office.Interop.Excel;
  
  namespace ConsoleApplication3
  {
      class Program
      {
          static void Main(string[] args)
          {
              Excel.Application srcxlApp;
              Excel.Workbook srcworkBook;
              Excel.Worksheet srcworkSheet;
              Excel.Range srcrange;
              Excel.Application destxlApp;
              Excel.Workbook destworkBook;
              Excel.Worksheet destworkSheet;
              Excel.Range destrange;
              string srcPath;
              string destPath;
  //Opening of first worksheet and copying
              srcPath="C:\\Documents and Settings\\HARRY\\Desktop\\incident.csv";
              srcxlApp = new Excel.Application();
              srcworkBook = srcxlApp.Workbooks.Open(srcPath);
              srcworkSheet = srcworkBook.Worksheets.get_Item(1);
              srcrange = srcworkSheet.UsedRange;
              srcrange.Copy(Type.Missing);
  
  //opening of the second worksheet and pasting
              destPath = "C:\\Documents and Settings\\HARRY\\Desktop\\FIXED Aging incident Report.xls";
              destxlApp = new Excel.Application();
              destworkBook = destxlApp.Workbooks.Open(destPath,0,false);
              destworkSheet = destworkBook.Worksheets.get_Item(1);
              destrange = destworkSheet.Cells[1, 1];
              destrange.Select();
  
              destworkSheet.Paste(Type.Missing, Type.Missing);
              destworkBook.SaveAs("C:\\Documents and Settings\\HARRY\\Desktop\\FIXED Aging incident Report " + DateTime.Now.ToString("MM_dd_yyyy") + ".xls");
              srcxlApp.Application.DisplayAlerts = false;
              destxlApp.Application.DisplayAlerts = false;
              destworkBook.Close(true, null, null);
              destxlApp.Quit();
              srcworkBook.Close(false, null, null);
              srcxlApp.Quit();
  
          }
      }
  }
  </code></pre>