title: Import Excel data into PowerShell variables
body: <p>I have an Excel File which has an unknown number of records in it, and these 3 columns:</p>
  
  <pre><code>Variable Name, Store Number, Email Address
  </code></pre>
  
  <p>I use this in QlikView to import data for certain stores and then create a separate report for each store in the list. I then need to email each report to each individual store (store number will be in the report file name).</p>
  
  <p>So in PowerShell I would like to read the Excel File and set variables for each store:  </p>
  
  <pre><code>$Store1 = The Store Number in Row 2 of the Excel File  
  $Store1Email = The Store Email in Row 2 of the Excel File  
  $Store2 = The Store Number in Row 3 of the Excel File  
  $Store2Email = The Store Email in Row 3 of the Excel File  
  etc. for each Storein the file (can be any number of stores).  
  </code></pre>
  
  <p>Please note the "Variable Name" in the excel file must be ignored (that is for QLikView) and the PowerShell variables must be named as per my above examples, each time incrementing the number.</p>