copy range from one excel sheet to other fails.

B

berkeleydb_user

Guys

I need to copy data from an uploaded excel into master excel . I'm
doing
this but the excel objects are not getting cleaned up. I see 2
instances of
Excel running in 'Task Manager'. Whats the best way to copy range of
data
from one excel workbook to other workbook. HEre is my code;

Excel.Application srcExcel = new Excel.ApplicationClass();
Excel._Workbook srcWb = srcExcel.Workbooks.Open(fName, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
Excel._Worksheet srcWsh = (Excel._Worksheet)srcWb.Sheets.get_Item(2);

Excel.Application dstExcel = new Excel.ApplicationClass();
Excel._Workbook dstWb = dstExcel.Workbooks.Open(eventdir,
Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
Excel._Worksheet dstWsh = (Excel._Worksheet)dstWb.Sheets.get_Item(2);

// following seems to work but excel objects are not getting cleaned up
((Excel.Range)dstWsh.get_Range("C4", "N26")).Value2
=
((Excel.Range)srcWsh.get_Range("C4",
"N26")).Value2;

// this one gives error.
//Excel.Range r1 = (Excel.Range)srcWsh.get_Range("C4:N26",
Type.Missing);
//Excel.Range r2 = (Excel.Range)dstWsh.get_Range("C4:N26",
Type.Missing);
//r2.Value2 = r1.Value2;
//r1.Copy(r2);

pl help.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top