copy contents of range object (Excel column) to an array via javascript
<p>what I want to do is access an excel file, take the contents of a column and then store it in an array. I'm guessing this can be done by iterating through each element of the range object and copying it to an array. My current code is shown below:</p>

<pre class="lang-js prettyprint-override"><code>    function GetData(){

          var excel = new ActiveXObject("Excel.Application");
          var excel_file = excel.Workbooks.Open("C:\\Data.xls");
          var excel_sheet = excel.Worksheets("Sheet2");

          //returns a RANGE object
          var myrow = excel_sheet.Columns(1);

          //doing this puts a single range object in myarray
          var myarray = new Array(myrow);

         //try printing the contents of the range object
          for (mycell in myrow){
              document.getElementById('div1').innerHTML = mycell;
          }
   }
</code></pre>
