Share via


ChartSheet.Previous Property

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

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

Syntax

'Declaration
ReadOnly Property Previous As Object
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.ChartSheet.

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

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace