title: How to read or loop each sheets on csv/xls using FileStream and StreamReader on C#
body: <p>This example code below is an example on how do I read headers and each line of csv/xls using FileStream and StreamReader in C#. It's all working, but only with one sheet.</p>
  <pre><code>                using (var fs = new FileStream(fi.FullName, FileMode.Open, FileAccess.Read, FileShare.None))
                  {
                      using (var sr = new StreamReader(fs, Encoding.Default))
                      {
                          line1 = sr.ReadLine();
                          string[] headers = line1.Split(&quot;,&quot;); //THIS LINE WILL READ HEADERS
                          
                          if (headers.Length &gt; 0)
                          {
                              while ((line = sr.ReadLine()) != null)
                              {
                                  //HERE WILL READ EACH LINE 
                              }
                          }
                      }
                  }
  </code></pre>
  <p>Now I have multiple sheets. The question is how do I read or jump to another sheets.</p>
  <p>With the code above what do I need to add?</p>
  <p>Example pic for
  <a href="https://i.stack.imgur.com/BHfrl.png" rel="nofollow noreferrer">multiple sheets</a></p>