Reading Excel file from JavaScript

Question

I have following code for reading excel in javascript :

<html>
<head>
<script type="text/javascript">
function readData(x,y)
{

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

      alert(excel);

      var excel_file = excel.Workbooks.Open("D:\File1.xlsx");
      Excel.Visible = true;

      alert(excel_file);

      var excel_sheet = excel_file.Worksheets("DEPT INC UPDATE");

      alert(excel_sheet);

      var data = excel_sheet.Cells(x,y).Value;

      alert(data);

      return data;


}



</script>
</head>
<body>

<input type="button" value="SimpleButton" onclick="readData(2,3);" />
</body>
</html>

But dunno where it is going wrong ??

Peter Perháč · Accepted Answer · 2011-08-04 09:42:20Z

1

your input element is a submit button, but is not inside a form. When readData returns the data, nothing ever makes any use of it. and as to the rest, i dunno. you don't say where it's going wrong. does it show any one alert box?

answered Aug 4, 2011 at 9:42

Peter Perháč

20.8k23 gold badges129 silver badges153 bronze badges

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

1 Comment

Peter Perháč Over a year ago

then it looks like the line Excel.Visible = true; could be the culprit. Since, it never get to the alert right after that. mind that JavaScript is case sensitive. If you intended to say excel.Visible = true; then just change the upper-case E to e

Pratik · Accepted Answer · 2014-08-07 14:21:33Z

0

i think there is an error in giving the path. Use double backward slashes instead of single.

In your case..

D:\File1.xlsx

Hope this might be helpful..:)

edited Aug 7, 2014 at 14:21

Pratik

11.8k22 gold badges71 silver badges99 bronze badges

answered May 20, 2013 at 15:27

Kiran

1

Collectives™ on Stack Overflow

Reading Excel file from JavaScript

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related