title: How do I create an array of the contents of a excel column
body: <p>I have 10 values in column A of a excel spreadsheet (it will be more) is there a way to take the values of the column and put them into an array? </p>
  
  <p>And if possible would it be possible to put the values in a different order than they are in in the spreadsheet. For example, if my spreadsheet values are "Apple" "Orange" and "Banana", then I would like my array to look something like, position 0 "Orange" position 1 "Banana" and position 2 "Apple". </p>
  
  <p>Does anybody know how this might be done? By the way, it needs to be scalable from 10 to 1000 values without editing the code much</p>