A
asp newbie
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
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