Count Property (DDSheets)

Gets the number of elements contained in the DDSheets collection.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Count As Integer

public int Count {get;}

Property Value

Integer.

Remarks

This property is read-only.

Example

if (MessageBox.Show ("Your spreadsheet is " + sb.Sheets.Count.ToString() + " sheet(s) long. Okay to save?", "Save", MessageBoxButtons.YesNo) == DialogResult.Yes) 
{
    //Save the Workbook to an Excel file
    sb.Save (Application.StartupPath + @"\x.xls");
    MessageBox.Show("Your Spreadsheet, " + sb.Sheets[0].Columns(0).OwnerSheet.Name + ", has been saved to " + Application.StartupPath + "\\x.xls");
}
sb.Clear();

Visual Basic

Dim result As MsgBoxResult
result = MsgBox("Your spreadsheet is " & sb.Sheets.Count.ToString & " sheet(s) long. Okay to save?", MsgBoxStyle.YesNo)
If result = MsgBoxResult.Yes Then
    'Save the Workbook to an Excel file
    sb.Save(Application.StartupPath & "\x.xls")
    MsgBox("Your Spreadsheet, " & sb.Sheets(0).Columns(0).OwnerSheet.Name & ", has been saved to " & Application.StartupPath & "\x.xls")
End If
sb.Clear()

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DDSheets Class
DDSheets Members