You can do it by VBA
Copying a worksheet in VBA is easy. If it is going into the same workbook
then use this
Sheets("Master").copy
Sheets("Sheet1").Copy after:=Sheets(Sheets.Count)
Set NewSht = ActiveSheet
for copying multipel sheets
for i = 1 to sheets.count
Sheets(i).Copy after:=Sheets(Sheets.Count)
Set NewSht = ActiveSheet
next i
OR we have some c# code
string src = @"Book1.xlsx";
string dst = @"Book2.xlsx";
object missing = Missing.Value;
ApplicationClass app = new ApplicationClass();
WorkbookClass wb1 = (WorkbookClass) app.Workbooks.Open(src, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing,missing);
WorkbookClass wb2 = (WorkbookClass)app.Workbooks.Open(dst, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Worksheet sheet1 = (Worksheet) wb1.Worksheets["Sheet1"];
Worksheet sheet2 = (Worksheet)wb2.Worksheets["Sheet1"];
try
{
sheet1.Copy(sheet2,missing );
}catch (Exception ex){
//
}
finally{
app.Quit();
}
Regards,
Robin Ahuja
Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator