 |
 |
 |
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace : IWorksheets Interface |
|
|
|
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace : IWorksheets Interface |
Represents a collection of worksheets in a workbook.
For a list of all members of this type, see IWorksheets members.
[Visual Basic]
<DefaultMemberAttribute ("Item")>
Public Interface IWorksheets [C#]
[DefaultMemberAttribute ("Item")]
public interface IWorksheets [C++]
[DefaultMemberAttribute ("Item")]
public __gc __interface IWorksheets [C++/CLI]
[DefaultMemberAttribute ("Item")]
public interface class IWorksheets Only normal worksheets are included in this collection. Chart sheets, dialog sheets, Visual Basic modules and Excel 4 Macro Sheets are excluded.
[C#]
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]
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
Namespace: SpreadsheetGear
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
Assembly: SpreadsheetGear (in SpreadsheetGear.dll)
IWorksheets Members | SpreadsheetGear Namespace
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.