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

Question

Hi Friends How do i add data from one excel sheet into another without any changesI am having logos images i want to add all.

Alex Heig · Answer

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:	est.xls); ExcelWorksheet Wsheet=Wbook.Worksheets.Add(Wsheet2); ExcelWorksheet Wsheet=Wbook.Worksheets.Add(Wsheet2); for (int i=0; i { for (int j=0; j { Wsheet.Cells[ij] = Wbook.Worksheets[Wsheet1].Cells[ij]; } } Wsheet.Pictures = Wbook.Worksheets[Wsheet1].Pictures;

Divya Saxena · Answer

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.