copy contents of range object (Excel column) to an array via javascript

Question

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:

    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;
          }
   }

Alkis Kalogeris · Accepted Answer · 2013-12-18 21:00:46Z

1

Please check the following code to get data from an excel file. Hope this helps you:

CODE:

function GetData(){ 
          var excel = new ActiveXObject("Excel.Application"); 
          var excel_file = excel.Workbooks.Open("C:\\Data.xls"); 
          var excel_sheet = excel.Worksheets("Sheet2"); 
          for(var i=2;i<20;i++){
            var myrow = excel_sheet.Range("A"+i);    //to read values in row A
            document.getElementById('div1').innerHTML = myrow; 
          }
}

Tested in IE9.

edited Dec 18, 2013 at 21:00

Alkis Kalogeris

17.9k15 gold badges62 silver badges119 bronze badges

answered Mar 20, 2012 at 4:10

Kiran

20.3k11 gold badges72 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wesley Smith Over a year ago

is there also a simple method to do this in chrome and firefox?

Collectives™ on Stack Overflow

copy contents of range object (Excel column) to an array via javascript

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related