SpreadsheetGear 2010
IName Interface
Members  Example  See Also  Send Feedback
SpreadsheetGear Namespace : IName Interface

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 BasicCopy 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

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.