SpreadsheetGear Namespace : IName Interface |
Represents a defined name.
For a list of all members of this type, see IName members.
[Visual Basic]
Public Interface IName
[C#]
public interface IName
[C++]
public __gc __interface IName
[C++/CLI]
public interface class IName
[C#]
class Program
{
static void Main()
{
// Create a workbook.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook("2005 Sales.xls");
// Enumerate the defined names.
foreach (SpreadsheetGear.IName name in workbook.Names)
System.Console.WriteLine("Name={0} Formula={1} FormulaR1C1={2}", name.Name, name.RefersTo, name.RefersToR1C1);
}
}
[Visual Basic]
Class Program
Shared Sub Main()
' Create a workbook.
Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook("2005 Sales.xls")
' Enumerate the defined names.
Dim name As SpreadsheetGear.IName
For Each name In workbook.Names
System.Console.WriteLine("Name={0} Formula={1} FormulaR1C1={2}", name.Name, name.RefersTo, name.RefersToR1C1)
Next 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)
IName 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.