.
| Description |
|---|
| Excerpt |
|---|
The 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 |
| Signature | C# | C# |
|---|---|---|
| Wiki Markup | ||
{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}{signature:vb.net | vb.net | }
<DefaultMember("Item")> _
Public NotInheritable Class Worksheets
Implements System.Collections.Generic.IEnumerable(Of Worksheet)
|
| Properties |
|---|
...
Name
...
Description
...
{signature} {properties} ||Name||Description|| |[Count|Worksheets.Count]|{excerpt-include |
...
:Worksheets.Count |
...
| Indexers |
|---|
...
Name
...
Description
|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 |
...
| Methods |
|---|
...
Name
...
Description
=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}| |