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: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 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.