OpenXml.Excel.Data.ExcelDataReader.GetOrdinal C# (CSharp) Method

GetOrdinal() public method

public GetOrdinal ( string name ) : int
name string
return int
        public int GetOrdinal(string name)
        {
            for(var i = 0; i < _headers.Length; i++)
                if (string.Equals(_headers[i], name, StringComparison.InvariantCultureIgnoreCase))
                    return i;

            return -1;
        }

Usage Example

 public void DataReaderTest()
 {
     using (var reader = new ExcelDataReader(@"test.xlsx"))
     {
         Assert.AreEqual(0, reader.Depth);
         Assert.AreEqual(-1, reader.RecordsAffected);
         Assert.AreEqual(7, reader.FieldCount);
         Assert.AreEqual(5, reader.GetOrdinal("ColDecimal"));
         Assert.AreEqual(-1, reader.GetOrdinal("InvalidColName"));
     }
 }