Full Name:
How to: Add New Worksheets to Workbooks

Short Name:
How to: Add New Worksheets to Workbooks

Type of Entity:
C#

Abstract:
The Add method enables you to add a new worksheet to the collection of worksheets in the workbook. However, when you add the worksheet programmatically, the new worksheet is a native Microsoft.Office.Interop.Excel.Worksheet object that contains native Excel objects without any data-binding capabilities, events, or code. If you want to add a Microsoft.Office.Tools.Excel.Worksheet host item, you should add the worksheet at design time. For more information, see Programmatic Limitations of Host Items and Host Controls.

MSDN Source URL:
http://msdn2.microsoft.com/6fczc37s.aspx