Copy a Worksheet from one Excel Workbook to another -- c#

  • Thread starter Thread starter shan_chennai
  • Start date Start date
S

shan_chennai

I have the followign requirement..

I have a worksheet Named 'Sales' in a excel Workbook named "WorkBook1".
There is another workbook by Name "Workbook2" which has many
worksheets. There is a chance that 'Sales' already exists in
"Workbook2".

I need to copy the worksheet 'sales' from 'Workbook1' to 'Workbook2'.

The following cases have to be taken care off..
1. If 'Sales' exist in 'workbook2' then rename it to some other name
and copy the 'sales' from 'workbook1' into 'workbook2'. After copying,
the renamed worksheet can be deleted.

CAN SOME1 HELP ME WITH A C# Code on how to achive this ??

PLEASE HElP ASAP !!!

Regards
SHAN
 
Back
Top