Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy range from one workbook to other in C#
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
Cannot copy from one workbook to another | Excel Discussion (Misc queries) | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
copy range of cells from one workbook to another | Excel Discussion (Misc queries) |