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.
Unfortunately, activation email could not send to your email. Please try again.

How to Copy the Worksheet from One Workbook to Another Workbook?

The Worksheets Add Copy method has overloads for adding a copy to the destination Worksheet from the Source Worksheet. Please refer the below code snippet which illustrates this:

C#

VB

Here is the sample for your reference:

http://www.syncfusion.com/downloads/support/directtrac/89898/CopyWorkSheet-1731694154.zip

Article ID: Published Date: Last Revised Date: Platform: Control:
1935 04/30/2011 07/18/2014 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Comments
Mahesh Parchure Feb 16, 2018

There is an issue with this, if source sheet having Header with Fond Size more than10 then that header or row not displayed in target file.

Can you please tell me solution on this issue, how do I get header in target file. 

And one more thing in source sheet, Header position not fixed it may be in 1st row or 2nd row or 3rd Row, 4th Row ..... and so on.. 

So how to get that header in target sheet ?

Reply
Mahesh Parchure Feb 20, 2018

Hi, I again modified my question

If my rdl having one text box with value "Hello" and if I place one formula in that textbox along with Hello then it is displayed like that "Hello <>

Suppose formula return value "World", Now if I ran report it displayed me Hello World, if I export to Excel it is still displayed Hello World.

But when I used SyncFusion to copy that excel sheet in some other workbook it displayed me blank row instead of "Hello World" !

Can you please help me how to access that type of cell using syncfusion ?

Abirami Varadharajan [Syncfusion] Feb 22, 2018

Hi Mahesh,

 

We are unable to reproduce the issue. We have prepared sample with both the mentioned scenario and shared for your reference which can be downloaded from the following link.

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample2142392259.zip

 

If you are using older version of Syncfusion, it is recommended to upgraded to latest version 16.1.0.24 with more bugs fixes, enhancements and features which is available for download under following link.

 

Download link: https://www.syncfusion.com/forums/136049/essential-studio-2018-volume-1-release-v16-1-0-24-is-available-for-download

 

If you face any issues even after upgrading to latest version, please contact our support team at support@syncfusion.com  to get a prompt assistance on this.

 

Regards,

Abirami.

Mahesh Parchure Feb 22, 2018

Thanks for your mail Abirami,

But now issue is when I open my excel file (which is downloaded from rdl) and just save as that file and use that new file then everything is fine.

But if I used downloaded file (without save as) then I lost my header.

I think this is because in my rdl I have header text box which displayed header and long with that(in same textbox) I add formula beside header. (I want to display some value along with my header).

It is find when download excel from rdl but as soon as I use syncfusion to copy that sheet in other workbook then in destination workbbok I lost my header !

And if I ave as that file manually and use that new file then it works using same syncfusion code ! That's something strage for me.

But anyway I try to use new version and let's see (currently I am using 13.1400.0.21)

Thank You

Mahesh Parchure

Reply
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.