Partager via


ChartSheetBase.Previous Property

Gets a Microsoft.Office.Interop.Excel.Worksheet object that represents the previous sheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public ReadOnly Property Previous As Object
public Object Previous { get; }

Property Value

Type: System.Object
A Microsoft.Office.Interop.Excel.Worksheet object that represents the previous sheet.

Examples

The following code example uses the Next and Previous properties to display the names of the next and previous sheets for the current Microsoft.Office.Tools.Excel.ChartSheetBase.

Private Sub DisplayNextAndPrevious()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn

    Dim nextSheet As Excel.Worksheet = _
        CType(Me.Next, Excel.Worksheet)
    Dim previousSheet As Excel.Worksheet = _
        CType(Me.Previous, Excel.Worksheet)

    If Not (nextSheet Is Nothing) Then
        MsgBox("The next sheet is: " & nextSheet.Name)
    Else
        MsgBox("This sheet is the last sheet.")
    End If 

    If Not (previousSheet Is Nothing) Then
        MsgBox("The previous sheet is: " & _
            previousSheet.Name)
    Else
        MsgBox("This sheet is the first sheet.")
    End If 
End Sub
private void DisplayNextAndPrevious()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    Excel.Worksheet nextSheet = (Excel.Worksheet)this.Next;
    Excel.Worksheet previousSheet = 
        (Excel.Worksheet)this.Previous;

    if (nextSheet != null)
    {
        MessageBox.Show("The next sheet is: " + 
            nextSheet.Name);
    }
    else
    {
        MessageBox.Show("This sheet is the last sheet.");
    }

    if (previousSheet != null)
    {
        MessageBox.Show("The previous sheet is: " + 
            previousSheet.Name);
    }
    else
    {
        MessageBox.Show("This sheet is the first sheet.");
    }
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace