title: Reading from Excel dynamically in C#
body: <p>I'm not sure if using the word "dynamic" is correct. Anyway, I do have some basic understanding of using the <code>Microsoft.Office.Interop.Excel</code>. The problem is, I'm having about 100 excel files in a folder, each of the excel files has different <code>sheet name, number of rows and number of columns</code>.</p>
  
  <p>As far as I understand, you need to specify the <code>range</code> and <code>sheet</code> name, i.e.: </p>
  
  <pre><code>xcel.Worksheet sheet = someExcelFiles.Sheets["SomeSheetName"] as Excel.Worksheet;
  
  Excel.Range range = sheet.get_Range("A1:A5");
  </code></pre>
  
  <p>Is there anyway so that my application can read all data in all of the excel files without having to specify the <code>sheet name</code> and <code>range</code> (row and columns)?</p>