Add Method (SheetViewCollection)

In This Topic

Adds a sheet to the collection.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub Add( _
   ByVal sheetView As SheetView _
)

'Usage
 
Dim instance As SheetViewCollection
Dim sheetView As SheetView
 
instance.Add(sheetView)

public void Add( 
   SheetView sheetView
)

Parameters

sheetView: SheetView object containing the sheet to add to the collection

Remarks

To add multiple sheets to the collection, use the AddRange method.

Example

This example creates two sheets and adds them to the collection of sheets one at a time so that the total number of sheets now equals three (which includes the one that is added by default and the two added to the collection).

C#
Visual Basic

Reference

SheetViewCollection Class
SheetViewCollection Members
AddRange Method