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.

Inserting a new blank worksheet in a workbook

Thread ID:

Created:

Updated:

Platform:

Replies:

98553 Mar 8,2011 02:30 PM Mar 9,2011 05:53 AM ASP.NET Web Forms (Classic) 2
loading
Tags: XlsIO
Ram Thatikonda
Asked On March 8, 2011 02:30 PM

Is there a way to insert a new blank worksheet at a particular position in an existing workbook? I know how to create a workbook -

workbook = application.Workbooks.Create(tabs);

I would appreciate response from Syncfusion!

Thanks!


NOLONGERWITHCOMPANYAmanda Kabak
Replied On March 8, 2011 05:32 PM

Hey, you can do this by creating a worksheet at the end and then moving it to whatever index you want:

This creates a new page called Summary and moves it to the first position.
application.Workbooks[0].Worksheets.Create("Summary");
application.Workbooks[0].Worksheets["Summary"].Move(0);
application.Workbooks[0].Worksheets[0].Activate();



John Bowlin Bosco K [Syncfusion]
Replied On March 9, 2011 05:53 AM

Hi Ram,

Thank you very much for your interest in Syncfusion Products.

Using Essential XlsIO, a blank worksheet can be added to a particular location in the worksheet with the help of move method by specifying the position where to place the created worksheet. We have created a sample and it has been attached for your reference. Please try the sample and let us know if this helps you.

Please let us know if you require any further clarifications.

Thanks,
Pauline Bosco.



AddBlankSheetSample_98533_73ed9411.zip

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.

;