How to add one excel sheet data into other excel sheet without any change

Hi,
If you want to copy excel worksheet data from your code you may use a lot of libraries like Aspose, Elerium or other. I used this C# Excel Writer to work with excel files and it was very useful. But it is not free. I think this code will help in your case:

 ExcelWorkbook Wbook = ExcelWorkbook.ReadXLS(@"c:\test.xls");
 ExcelWorksheet Wsheet=Wbook.Worksheets.Add("Wsheet2");
 ExcelWorksheet Wsheet=Wbook.Worksheets.Add("Wsheet2");
   for (int i=0; i< Wbook.Worksheets["Wsheet1"].Rows.Count; i++)
   {
   for (int j=0; j    {
      Wsheet.Cells[i,j] = Wbook.Worksheets["Wsheet1"].Cells[i,j];
    }
   }

Wsheet.Pictures = Wbook.Worksheets["Wsheet1"].Pictures;

hi,
i think you want to add data one sheet to another excel sheet....so this is a simple steps...
1- Right click on below sheet-1(which you want to copy) and select MOVE OR COPY...small window will open
2- Select Sheet where you want to copy. (with in same Excel ) otherwise select from Top TO BOOK (drop down list) and copy into another excel work book.
NOTE: Below Check box CREATE A COPY...check if you want to copy..and if you dont so keep uncheck.
please find the attached File.