JavaScript get excel file data

By the use of JavaScript we can get the excel file data as well. Here is the example which gets the data from the excel file with the cell and row index values.

To explain this we have created a simple HTML page into which we have four buttons which calls the method GetData(cell,row) as defined in the JavaScript.

First line of the function creates a new reference object of ActiveXObject for excel application. In the second line we have located the excel file and third line describes which sheet's data we are going to use. Now we can get the data at the specific cell and row position from this sheet. It works with Internet Explorer browser.

Excel file data is as  :

Here is the full example code as follows :

Output :

Click on the button "cell(1), row(1)"

Click on "Yes". It will show you the cell(1), row(1) value i.e "amit".

Click on next button to fetch data from the cell(1) and row(2)

Above image shows fetched data from cell(1) and row(2). Click on next button to fetch data from the cell(2) and row(1)

Above image shows fetched data from cell(2) and row(1). Click on next button to fetch data from the cell(2) and row(2)

Above image shows fetched data from cell(2) and row(2).

Download Source Code