ExcelRW formatting

[Steve L.]

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]

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!