title: Add Excel Range to Lists without looping
body: <pre><code> xlRangeDB = xlWorkSheetDB.get_Range("A2", "BA" + lRow.ToString());
                  object[,] valueArray = xlRangeDB.Value2;
  
                  List&lt;string&gt; inputData = new List&lt;string&gt;();
                  inputData.AddRange(valueArray);
  </code></pre>
  
  <p>I would like to convert and Excel Range (xlRangeDB) to List.  I couldn't find a direct way so I first convert excel range to Array and then try to add into List.  But it doesn't work either.
  Actually I have more than 200 excel files and each file contain 70000 rows and 70 columns. I need to collect data from these files. Looping in this situation would take enormous time. Any advice. Thanks</p>