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()
' 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 |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also