title: Using column names in spreadsheet no index, using vb,net
body: <p>I have been writing some code to extract data from a an application and parse it to a spreadsheet.</p>
  
  <p>My spreadsheet looks like this:</p>
  
  <pre><code>Scenario     ClientName         ClientNumber
  
  5555        Smith               s0001
  
  6776        Charles           d6666
  </code></pre>
  
  <p>I have this code:</p>
  
  <p>Dim ObjExcel As New Excel.Application
              Dim sWindow As New WinWindow
              ObjExcel.Visible = False
              Dim stext As String</p>
  
  <pre><code>            ObjExcel.Workbooks.Open("c:\data\calcresults.xlsx")
              Dim ObjWS As Excel.Worksheet = ObjExcel.Worksheets("IP")
  
              Dim iNextRow As Integer = ObjWS.UsedRange.End(Excel.XlDirection.xlDown).Row + 1
  
              ObjWS.Cells(iNextRow,1 ) = "d66666"
              ObjWS.Cells(iNextRow, 2) = "s77898"
  </code></pre>
  
  <p>would like use to Column Name not index, for example:</p>
  
  <p>ObjWS.Cells(iNextRow,"Scenario" ) = "new row data, first column"</p>
  
  <p>any ideas how can i do this?</p>