ChartSheet.Visible Property

Статья
07/25/2011

Determines whether the object is visible.

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

Syntax

'Declaration
Property Visible As XlSheetVisibility
    Get
    Set

XlSheetVisibility Visible { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlSheetVisibility

Examples

The following code example uses the Visible property to hide the current Microsoft.Office.Tools.Excel.ChartSheet.

Private Sub HideChartSheet()
    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.xl3DBarClustered
    Me.Visible = Excel.XlSheetVisibility.xlSheetHidden
End Sub

private void HideChartSheet()
{
    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.xl3DBarClustered; 
    this.Visible = Excel.XlSheetVisibility.xlSheetHidden;
}

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace