title: How to get the data of a specific column from an excel file?
body: <p>Hi I've an excel file which looks like this
   id name age phne no and like this i have 35 columns.........</p>
  
  <p>I'm using a webapplication for this in which I've a <code>fileupload control</code>,a button and two textboxes</p>
  
  <pre><code>        fileuploadcontrol
          button
           textbox1
           textbox2
  </code></pre>
  
  <p>Now when I upload the excel file on button click it should read complete file .........
  and when I enter the required column in the <code>textbox1</code> I get those column details only its like this</p>
  
  <p><code>textbox1(c1,c4,c5,c30)</code> I sholud get only those column details and in the other text box if I enter the location to be saved it should be saved in that location can any one help me with this I had finished till file uploading and reading.....all I need is how to evaluate those textboxes to get my required data</p>
  
  <pre><code>           protected void Button1_Click(object sender, EventArgs e)
                 {
                  if (FileUpload1.HasFile)
                   {
                     if (FileUpload1.PostedFile.ContentType == "application/xlsx")
                      {
                         path = Server.MapPath(".") + "\\inputfiles\\" + Guid.NewGuid() + FileUpload1.FileName;
                         FileUpload1.PostedFile.SaveAs(path);
                         Label1.Text = "File Uploaded Successfully...";
                         StreamReader reader = new StreamReader(FileUpload1.FileContent);
                        string text = reader.ReadToEnd();
  
                        }
                        else
                       Label1.Text = "Upload .xlsx File";
                         }
                       else
                      Label1.Text = "Upload file";
  
                        }
  </code></pre>