SpreadsheetGear 2023
IName Interface
Members  Example 


SpreadsheetGear Namespace : IName Interface
Represents a defined name.
Object Model
IName Interface
Syntax
'Declaration
 
Public Interface IName 
'Usage
 
Dim instance As IName
public interface IName 
Example
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);
    }
}
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IName Members
SpreadsheetGear Namespace