Adding new sheets along with charts

[Phani Neelankantham]

I have a sheet template with some formatting and a few charts. I create a workbook with one sheet using this sheet template and the workbook''s sheet has charts from the sheet template. But when I try to add a new sheet to this workbook using
ExcelWorkBook.Worksheets.AddCopy(0)
function, the charts are not copied over but everything else is.

How do I get the newly added sheets to contain the charts?

[Phani Neelankantham]

At least a way to create a workbook with multiple sheets using a sheet template... is that possible?

>I have a sheet template with some formatting and a few charts. I create a workbook with one sheet using this sheet template and the workbook''s sheet has charts from the sheet template. But when I try to add a new sheet to this workbook using
>ExcelWorkBook.Worksheets.AddCopy(0)
>function, the charts are not copied over but everything else is.
>
>How do I get the newly added sheets to contain the charts?

[Administrator]

Hi Phani, Sorry for the delay in getting you. We do have support for following requirements. 1)Create a workbook based on template containing Charts and other formats. 2)Adding a sheet containing charts to workbook. 3)Adding multiple sheets to the workbook.You Can add a new sheet to the workbook by using Create method. workbook.Worksheets.Create(); Please take a look at the attachment and let me know if it meet your requirements. http://www.syncfusion.com/Support/user/uploads/copyingchartSheet_6727306e.zip copyingchartSheet.zip BestRegards, Bharath.