Read xls file with JavaScript

Read xls file with JavaScript

Hello! Good Day!

Below is an example code on how to read an excel file in javascript:

function my_function(){

    var Excel;

    Excel = new ActiveXObject("Excel.Application");

    Excel.Visible = false;

    return Excel.Workbooks.Open("path of your file").ActiveSheet.Cells(l,i).Value;

}

var i=1;  // # of columns

var l=1; // # of rows

do

{

    a=my_function()

    if (a!=null)

    {

       document.write("value is " + a + "&nbsp ;&nbsp ;&nbsp ;&nbsp ;");

        i++;

    }

    else

    {

        l++;

        i=1;

        document.write("<br />");

    }

  b = my_function()

}while(a!=null || b!=null);

You can start from there.

Hope this helps!