Excel Generator with Column Designer

/// FileName                : SpreadsheetColumnCollection.cs
/// Author                  : Somnath Mondal
/// Created Date            : 10/03/2007
/// 
/// Modification History    :
/// **********************************************************************************************
/// Date        Author                          Description
/// **********************************************************************************************
/// 10/03/2007  Somnath Mondal.                 Created
/// **********************************************************************************************
using System;
using System.Collections;
using System.ComponentModel;
using System.Runtime.InteropServices;
using System.Collections.Generic;

namespace Somsoft.ReportDesigner
{
	/// <summary>
	/// Contains the collection of 
	/// </summary>

    public class SpreadsheetColumnCollection : CollectionBase, IEnumerable<SpreadsheetColumn>  
	{

		public SpreadsheetColumnCollection()
		{
		}

		public SpreadsheetColumn this [int index]
		{
			get
			{
				return (SpreadsheetColumn) List[index];
			}
			set
			{
				List[index] = value;
			}
		}
        public int Add(SpreadsheetColumn spreadsheetColumn)
		{
            spreadsheetColumn.Container = this;
            return List.Add(spreadsheetColumn);
		}
        public void AddRange(SpreadsheetColumn[] spreadsheetColumns)
		{
			int i=0;
            while (i <= spreadsheetColumns.Length)
			{
                this.Add(spreadsheetColumns[i]);
				i++;
			}
		}

        public void AddRange(SpreadsheetColumnCollection spreadsheetColumns)
		{
			int i=0;
            while (i < spreadsheetColumns.Count)
			{
                this.Add(spreadsheetColumns[i]);
				i++;
			}
		}

        public bool Contains(SpreadsheetColumn spreadsheetColumn) 
		{
            return List.Contains(spreadsheetColumn);
		}

		public void CopyTo(SpreadsheetColumn[] array, int index)
		{
			List.CopyTo(array, index);
		}

		public int IndexOf(SpreadsheetColumn spreadsheetColumn)
		{
			return List.IndexOf(spreadsheetColumn);
		}
        public void Insert(int index, SpreadsheetColumn spreadsheetColumn)
		{
            List.Insert(index, spreadsheetColumn);
		}
        public void Remove(SpreadsheetColumn spreadsheetColumn)
		{
            List.Remove(spreadsheetColumn);
		}
		public bool IsDuplicateKey(string name)
		{
			int count=0;
			foreach(SpreadsheetColumn col in List)
			{
				if(col.Name.ToUpper() == name.ToUpper())
					count++;
			}
			return count>0;
		}
        // This method will violate the Microsoft Design rule (UsePropertiesWhereAppropriate), 
        // but should not be a property.
        // This method has an observable side effect. 
        // Calling the method twice in succession creates different results.
        public string GetNewId()
		{
			int count=List.Count;
			string keyName = string.Empty ;
			while(true)
			{
				count++;
				keyName = "Column" + count;
				bool found = false;
				foreach(SpreadsheetColumn col in List)
				{
					if(col.Name.ToUpper() == keyName.ToUpper())
					{
						found=true;
						break;
					}
				}
				if(!found)
					break;
			}
			return keyName;
		}


        #region IEnumerable<int> Members

        public new IEnumerator<SpreadsheetColumn> GetEnumerator()
        {
            foreach (SpreadsheetColumn data in InnerList)
            {
                yield return data;
            }
        }
        //public new SpreadsheetColumnEnumerator GetEnumerator()
        //{
        //    return new SpreadsheetColumnEnumerator(this);

        //}

        #endregion
    }
}