title: Parsing an excel file and reading a cell
body: <p>I got an excel file. I have uploaded the screenshot. I need to write a .NET application (console application) to parse the excel file. You can see a cell titled "Function Name". My .NET app should find that particular cell and read the contents in that column such as Template, InstanceFromTemplate, Task and so on. If it reads Task, it should call CreateTask function like Task(); If it reads InstanceFromTemplate, it should call InstanceFromTemplate function like TaskInstanceFromTemplate();</p>
  
  <p>I have written code for those functions. I only need help on how to parse the excel sheet, go to that particular column, read the cells containing function names under that column and call that appropriate function. Any help would be appreciated. </p>
  
  <p>Algorithm is like</p>
  
  <ol>
  <li>open excel file</li>
  <li>search for a header cell titled Function Name</li>
  <li>Read the first cell under the header cell</li>
  <li>If the first cell reads , call  function (code for GetAllTemplate function is already there) Only need to call it afte finding it</li>
  <li>If the second cell , call  function. </li>
  <li>Last cell under the header cell Function Name is reached. So, exit</li>
  </ol>