Represents a collection of worksheets in a workbook.

Syntax

Visual Basic (Declaration)
<DefaultMemberAttribute("Item")> Public Interface IWorksheets

C#
[DefaultMemberAttribute("Item")] public interface IWorksheets

Example

C# Copy Code

C#	Copy Code
class Program { static void Main() { // Create a new empty workbook set. SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet(); // Create a new empty workbook in the workbook set. SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add(); // Add a second worksheet. workbook.Worksheets.Add(); // Rename worksheet "Sheet1" to "Hello" workbook.Worksheets["Sheet1"].Name = "Hello"; // Rename worksheet "Sheet2" to "World" workbook.Worksheets["Sheet2"].Name = "World"; // Save to C:\MyData.xls. workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97); // Close the workbook, removing it from the workbook set. workbookSet.Workbooks.Close(); // Open the saved workbook from memory. workbook = workbookSet.Workbooks.Open("C:\\MyData.xls"); // Output the sheet names separated by a space ("Hello World"). System.Console.WriteLine(workbook.Worksheets[0].Name + " " + workbook.Worksheets[1].Name); } }

class Program

{

   static void Main()

   {

       // Create a new empty workbook set.

       SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet();

       // Create a new empty workbook in the workbook set.

       SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add();

       // Add a second worksheet.

       workbook.Worksheets.Add();

       // Rename worksheet "Sheet1" to "Hello"

       workbook.Worksheets["Sheet1"].Name
= "Hello";

       // Rename worksheet "Sheet2" to "World"

       workbook.Worksheets["Sheet2"].Name
= "World";

       // Save to C:\MyData.xls.

       workbook.SaveAs("C:\\MyData.xls",
SpreadsheetGear.FileFormat.XLS97);

       // Close the workbook, removing it from the workbook set.

       workbookSet.Workbooks.Close();

       // Open the saved workbook from memory.

       workbook = workbookSet.Workbooks.Open("C:\\MyData.xls");

       // Output the sheet names separated by a space ("Hello World").

       System.Console.WriteLine(workbook.Worksheets[0].Name + "
" + workbook.Worksheets[1].Name);

   }

}

Visual Basic Copy Code

Visual Basic	Copy Code
Class Program Shared Sub Main() ' Create a new empty workbook set. Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet() ' Create a new empty workbook in the workbook set. Dim workbook As SpreadsheetGear.IWorkbook = workbookSet.Workbooks.Add() ' Add a second worksheet. workbook.Worksheets.Add() ' Rename worksheet "Sheet1" to "Hello" workbook.Worksheets("Sheet1").Name = "Hello" ' Rename worksheet "Sheet2" to "World" workbook.Worksheets("Sheet2").Name = "World" ' Save to C:\MyData.xls. workbook.SaveAs("C:\MyData.xls", SpreadsheetGear.FileFormat.XLS97) ' Close the workbook, removing it from the workbook set. workbookSet.Workbooks.Close() ' Open the saved workbook from memory. workbook = workbookSet.Workbooks.Open("C:\MyData.xls") ' Output the sheet names separated by a space ("Hello World"). System.Console.WriteLine((workbook.Worksheets(0).Name + " " + workbook.Worksheets(1).Name)) End Sub 'Main End Class 'Program

Class Program

    Shared Sub Main()

        ' Create a new empty workbook set.

        Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet()

        ' Create a new empty workbook in the workbook set.

        Dim workbook As SpreadsheetGear.IWorkbook = workbookSet.Workbooks.Add()

        ' Add a second worksheet.

        workbook.Worksheets.Add()

        ' Rename worksheet "Sheet1" to "Hello"

        workbook.Worksheets("Sheet1").Name = "Hello"

        ' Rename worksheet "Sheet2" to "World"

        workbook.Worksheets("Sheet2").Name = "World"

        ' Save to C:\MyData.xls.

        workbook.SaveAs("C:\MyData.xls", SpreadsheetGear.FileFormat.XLS97)

        ' Close the workbook, removing it from the workbook set.

        workbookSet.Workbooks.Close()

        ' Open the saved workbook from memory.

        workbook = workbookSet.Workbooks.Open("C:\MyData.xls")

        ' Output the sheet names separated by a space ("Hello World").

        System.Console.WriteLine((workbook.Worksheets(0).Name + " " + workbook.Worksheets(1).Name))

    End Sub 'Main

End Class 'Program

Remarks

Only normal worksheets are included in this collection. Chart sheets, dialog sheets, Visual Basic modules and Excel 4 Macro Sheets are excluded.

Requirements

Namespace: SpreadsheetGear

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.	Help Powered by Innovasys
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.

Syntax

Example

Remarks

Requirements

See Also

Reference

SpreadsheetGear
IWorksheets Interface
Members Example See Also Send Feedback