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.

ExcelRW formatting

Thread ID:

Created:

Updated:

Platform:

Replies:

29434 May 25,2005 10:47 AM May 25,2005 11:31 PM Windows Forms 1
loading
Tags: XlsIO
Steve L.
Asked On May 25, 2005 10:47 AM

Is there a way to specify just one tab rather than 3 tabs are generated in the ExcelRW worksheet? Also, is there a way to specify a title for that single tab? Thanks!

Administrator [Syncfusion]
Replied On May 25, 2005 11:31 PM

Hi Steve, The three tabs is just the default setting, you can change it using code like this //New instance of Excel is created.[Equivalent to launching MS Excel] ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; //A new workbook is created.[Equivalent to creating a new workbook in MS Excel] // The number of default worksheets is the application setting in MS Excel. IWorkbook myWorkbook = excelEngine.Excel.Workbooks.Create(1); //Change name myWorkbook.Worksheets[0].Name = "New Name"; Thanks, Stephen. >Is there a way to specify just one tab rather than 3 tabs are generated in the ExcelRW worksheet? Also, is there a way to specify a title for that single tab? > >Thanks!

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.

;