javascript - read a column from an excel file and read each cell of that column individually
<p>i'm trying to accomplish 3 things:
1. read a column from an excel file
2. read each cell that has a value
3. store that in an array</p>

<p>i'm stuck at step 2. here is what i have so far:</p>

<pre><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 representing the first column
          var myColumn = excel_sheet.Columns(1);

          var myarray = new Array();

          /*

            I must be able to read the INDIVIDUAL contents of myColumn 
            and do something like

            for (eachCell in myColumn) {
                myarray.push(eachCell);
            }



          */


          excel.Quit();
          excel.Application.Quit();
          window.setInterval("CollectGarbage();" , 1000);
   }
</code></pre>
