SpreadsheetGear
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

Namespace: SpreadsheetGear

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). 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

Copyright © 2003-2009 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.