Represents a defined name.
Syntax
Visual Basic (Declaration) | |
---|
Public Interface IName |
C# | |
---|
public interface IName |
Example
C# | Copy Code |
---|
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 | Copy Code |
---|
Class Program
Shared Sub Main()
Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook("2005 Sales.xls")
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
End Class
|
Requirements
Namespace: SpreadsheetGear
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.
Assembly: SpreadsheetGear (in SpreadsheetGear.dll)
See Also