Syntax

<DefaultMemberAttribute("Item")>
Public Interface IWorksheets 

[DefaultMemberAttribute("Item")]
public interface IWorksheets 

Example

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);    } }

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

Remarks

Requirements

Namespace: SpreadsheetGear

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.