Adding worksheets to currently active Excel workbook

[Administrator]

Hello,

I would like to add a worksheet (to which I have already added some data and a chart) to an already running instance of Excel with an already open workbook. My question is, how do I reference the correct workbook object to which to add the sheet. I would like to say something like

IWorksheet sheet = Application.ActiveWorkBook.Add;

But of course this is not allowed syntax.. Any help would be much appreciated, Thank you in advance

[Geetha M]

Hi Arnold,

Thank you for your interest in Syncfusion products.

It is possible to add a new worksheet to the existing workbook. Please refer to the code snippet given below.

IWorksheet destSheet = application.ActiveWorkbook.Worksheets.Create();

However, it you have the worksheet created and want to add, please check if the following code would work for you.

IWorksheet destSheet = application.ActiveWorkbook.Worksheets.AddCopy(sourceSheet);

Please try this and let me know if you have any questions.

Regards,
Geetha