The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

ChartSheetCollection.RemoveAt(Int32) Method

Removes the chart sheet at the specified position from the collection.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

void RemoveAt(
    int index
)
Sub RemoveAt(
    index As Integer
)
void RemoveAt(
    int index
)
Sub RemoveAt(
    index As Integer
)

Parameters

Name Type Description
index Int32

An integer that is the zero-based index of a chart sheet to be deleted from a workbook.

Parameters

Name Type Description
index Int32

An integer that is the zero-based index of a chart sheet to be deleted from a workbook.

Remarks

The RemoveAt method disposes of an element removed from the collection. To remove the specified chart sheet from the collection, use the ChartSheetCollection.Remove method. You can also hide a chart sheet using the ChartSheet.Visible or ChartSheet.VisibilityType property.

Note

A workbook must always contain at least one visible sheet.

To add a chart sheet to a workbook, use the ChartSheetCollection.Add or ChartSheetCollection.Insert method.

Examples

Dim worksheet As Worksheet = workbook.Worksheets("chartTask1")

' Create the first chart sheet.
workbook.ChartSheets.Add()

' Create the second chart sheet.
workbook.ChartSheets.Add(ChartType.Pie, worksheet("B2:C7"))

' Remove the first chart sheet.
workbook.ChartSheets.RemoveAt(0)
See Also