Page History

{description}
{excerpt}The [Worksheets|Worksheets] class represents the set of worksheets in an Excel workbook. This object is used to manage \(add, copy, remove, etc.\) the worksheets in the workbook To return a {{Worksheets}} object, use [Workbook.Worksheets|Workbook.Worksheets].{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class Worksheets : System.Collections.Generic.IEnumerable<Worksheet>
{signature}{signature:vb.net}
<DefaultMember("Item")> _
	Public NotInheritable Class Worksheets
		Implements System.Collections.Generic.IEnumerable(Of Worksheet)
{signature}
{properties}
||Name||Description||
|[Count|Worksheets.Count]|{excerpt-include:Worksheets.Count|nopanel=true}|
{indexers}
||Name||Description||
|[Item(Int32)|Worksheets.Item(Int32)]|{excerpt-include:Worksheets.Item(Int32)|nopanel=true}|
|[Item(String)|Worksheets.Item(String)]|{excerpt-include:Worksheets.Item(String)|nopanel=true}|
{methods}
||Name||Description||
|[CopySheet(Worksheet, Int32, String)|Worksheets.CopySheet(Worksheet, Int32, String)]|{excerpt-include:Worksheets.CopySheet(Worksheet, Int32, String)|nopanel=true}|
|[CreateChartsheet(ChartType, String)|Worksheets.CreateChartsheet(ChartType, String)]|{excerpt-include:Worksheets.CreateChartsheet(ChartType, String)|nopanel=true}|
|[CreateChartsheet(ChartType, String, Int32)|Worksheets.CreateChartsheet(ChartType, String, Int32)]|{excerpt-include:Worksheets.CreateChartsheet(ChartType, String, Int32)|nopanel=true}|
|[CreateWorksheet(String)|Worksheets.CreateWorksheet(String)]|{excerpt-include:Worksheets.CreateWorksheet(String)|nopanel=true}|
|[CreateWorksheet(String, Int32)|Worksheets.CreateWorksheet(String, Int32)]|{excerpt-include:Worksheets.CreateWorksheet(String, Int32)|nopanel=true}|
|[Delete(Int32)|Worksheets.Delete(Int32)]|{excerpt-include:Worksheets.Delete(Int32)|nopanel=true}|
|[Delete(String)|Worksheets.Delete(String)]|{excerpt-include:Worksheets.Delete(String)|nopanel=true}|
|[GetEnumerator()|Worksheets.GetEnumerator()]|{excerpt-include:Worksheets.GetEnumerator()|nopanel=true}|
|[InsertSheet(String, Int32)|Worksheets.InsertSheet(String, Int32)]|{excerpt-include:Worksheets.InsertSheet(String, Int32)|nopanel=true}|
|[MoveSheet(Worksheet, Int32)|Worksheets.MoveSheet(Worksheet, Int32)]|{excerpt-include:Worksheets.MoveSheet(Worksheet, Int32)|nopanel=true}|
|[Select(Object())|Worksheets.Select(Object())]|{excerpt-include:Worksheets.Select(Object())|nopanel=true}|