Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets the worksheet type.
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 Type As XlSheetType
public XlSheetType Type { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlSheetType
One of the XlSheetType values.
Examples
The following code example uses the Type property to display whether the current worksheet is a worksheet, a dialog sheet, or a chart in a message box.
This example is for a document-level customization.
Private Sub ShowType()
Select Case Me.Type
Case Excel.XlSheetType.xlWorksheet
MsgBox("This is a worksheet.")
Case Excel.XlSheetType.xlDialogSheet
MsgBox("This is a dialogsheet.")
Case Excel.XlSheetType.xlChart
MsgBox("This is a chart.")
End Select
End Sub
private void ShowType()
{
switch (this.Type)
{
case Excel.XlSheetType.xlWorksheet:
MessageBox.Show("This is a worksheet.");
break;
case Excel.XlSheetType.xlDialogSheet:
MessageBox.Show("This is a dialogsheet.");
break;
case Excel.XlSheetType.xlChart:
MessageBox.Show("This is a chart.");
break;
}
}
.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.