We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Copy or move a worksheet from one workbook to another

I''ve been trying to copy a worksheet to another workbook and I can''t seem to find an easy way to do this. I''m going to try to copy by a range. If that works, I will do it, but one would think there is a way to call a method like CopyTo(WorkSheetCollection) or something of that nature. Thanks --Mark

3 Replies

AD Administrator Syncfusion Team August 1, 2004 10:52 PM

Hi Mark, Sorry for the delay in responding. Currently there is no way to copy a worksheet to another workbook. I have contacted the development team regarding this issue and will update you will more information as soon as I hear from them. Thank you for your patience. Best regards, Stephen. >I''ve been trying to copy a worksheet to another workbook and I can''t seem to find an easy way to do this. > >I''m going to try to copy by a range. If that works, I will do it, but one would think there is a way to call a method like CopyTo(WorkSheetCollection) or something of that nature. > >Thanks >--Mark


ND nirav desai July 19, 2005 01:42 AM

Hi Stephen, I''ve been trying to copy data of one worksheet to another worksheet in other workbook using Syncfusion tool version 3.2. I am using Range method of worksheet to copy and paste the data from source sheet to destination sheet.Below is the code: ExcelEngine vacEngine=new ExcelEngine(); IApplication vacApplication=vacEngine.Excel; vacApplication.Workbooks.Open("C:\\ExcelData\\VAC document.xls"); IWorkbooks m_objBooksVAC=vacApplication.Workbooks; IWorkbook m_objBookVAC = m_objBooksVAC[0]; // Create a sheets objects.` IWorksheets m_objSheetsVAC=m_objBookVAC.Worksheets; //Source sheet from where data is required to copy. IWorksheet m_objSheet_VACSource = m_objSheetsVAC[o.DR_ExcelTableName.ToString()]; //Destination sheet IWorksheet m_objSheet_VACDestination=m_Workbook.Worksheets["VAC & Total Return"]; sRange=o.DR_Range; iColSt=1; iColEnd=9; sRowSt =1; sRowEnd =100; m_objSheet_VACDestination.Range[sRowSt,iColSt,sRowEnd,iColEnd].Value2 = m_objSheet_VACSource.Range[sRowSt,iColSt,sRowEnd,iColEnd].Text; When I execute the above code it does not throw any error but data is not pasted to the destination sheet. Please let me know the solution for the same.


AD Administrator Syncfusion Team July 20, 2005 02:11 AM

Hi Nirav, I will look into the issue with copying ranges across workbooks and update you shortly. However, here is a sample to copy a whole worksheet across workbooks. Sample Thanks, Stephen. >Hi Stephen, > >I''ve been trying to copy data of one worksheet to another worksheet in other workbook using Syncfusion tool version 3.2. > I am using Range method of worksheet to copy and paste the data from source sheet to destination sheet.Below is the code: > >ExcelEngine vacEngine=new ExcelEngine(); >IApplication vacApplication=vacEngine.Excel; >vacApplication.Workbooks.Open("C:\\ExcelData\\VAC document.xls"); >IWorkbooks m_objBooksVAC=vacApplication.Workbooks; >IWorkbook m_objBookVAC = m_objBooksVAC[0]; > >// Create a sheets objects.` >IWorksheets m_objSheetsVAC=m_objBookVAC.Worksheets; >//Source sheet from where data is required to copy. >IWorksheet m_objSheet_VACSource = m_objSheetsVAC[o.DR_ExcelTableName.ToString()]; > >//Destination sheet >IWorksheet m_objSheet_VACDestination=m_Workbook.Worksheets["VAC & Total Return"]; >sRange=o.DR_Range; >iColSt=1; >iColEnd=9; >sRowSt =1; >sRowEnd =100; >m_objSheet_VACDestination.Range[sRowSt,iColSt,sRowEnd,iColEnd].Value2 = m_objSheet_VACSource.Range[sRowSt,iColSt,sRowEnd,iColEnd].Text; > >When I execute the above code it does not throw any error but data is not pasted to the destination sheet. > >Please let me know the solution for the same.

Loader.
Live Chat Icon For mobile
Up arrow icon