title: Get values from dataset without column name
body: <p>I have a dataset filled with this excelsheet:</p>
  
  <p><a href="http://cdn.imghack.se/images/cdc24215d3d5079628a58878520c3028.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DVewJ.png" alt="enter image description here"></a></p>
  
  <p>The method:</p>
  
  <pre><code>[HttpPost]
  public ActionResult ShowExcelFile(GetExcel model)
  {
      DataSet result = null;
      var file = model.Files[0];
      if (file != null &amp;&amp; file.ContentLength &gt; 0)
      {
          // .xlsx
          IExcelDataReader reader = ExcelReaderFactory.CreateOpenXmlReader(file.InputStream);
  
          reader.IsFirstRowAsColumnNames = true; // if your first row contains column names
          result = reader.AsDataSet();
          reader.Close();
      }
  
      for (int i = 1; i &lt; result.Tables[0].Rows.Count; i++)
      {
          DataRow data = result.Tables[0].Rows[i];
          System.Diagnostics.Debug.Write(data.Table.Rows[i]["Column header name"]);
      }
      return View("ShowExcelFile");
  }
  </code></pre>
  
  <hr>
  
  <p>If I replace "Column name" with "Amortization" I get all values in column F. But the values I want is in column K. If I write a "Column header name" in K1 I will get the values that way. But is there some way without using this? I don't wanna use a value in that column (most design issues for me).</p>
  
  <p>So just for clarification: How do I get the values in cell K5:K10 with using the column header name?</p>