Gets the number of elements contained in the DDSheets collection.

Syntax

Visual Basic (Declaration)
Public ReadOnly Property Count As Integer

Visual Basic (Usage)	Copy Code
`Dim instance As DDSheets Dim value As Integer value = instance.Count`

C#
public int Count {get;}

Return Value

Integer.

Example

C# Copy Code

C#	Copy Code
`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();`

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 Copy Code

Visual Basic	Copy Code
`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()`

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()

Remarks

This property is read-only.

ActiveReports.XlsExport	Request technical support
Count Property
See Also Example

Syntax

Return Value

Example

Remarks

See Also

Reference