Syncfusion Dashboards. Cloud-based. The only BI solution you need for your business.
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:
Here is the sample for your reference:
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 ?
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 ?
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.
you are using older version of Syncfusion, it is recommended to upgraded to
latest version 188.8.131.52 with more bugs fixes, enhancements and features which
is available for download under following link.
you face any issues even after upgrading to latest version, please contact our
support team at firstname.lastname@example.org
to get a prompt assistance on this.
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)
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.