how to open excel using javascript

Question

I tried the below code to open excel file using javascript. I tried in IE, Chrome, and Firefox but it's not opening the file.

<html>
<body>
<form name="form1">
  <input type=button onClick="test()" value="Open File">
  <br><br>
</form>
<script type="text/javascript">
  function test() {
    var Excel = new ActiveXObject("Excel.Application");
    Excel.Visible = true;
    Excel.Workbooks.Open("teste.xlsx");
  }
</script>
</body>
</html>

Thanks in Advance!

Is ActiveX enabled in the browser? I hope not, but...

Federico klez Culloca
– Federico klez Culloca

2017-12-06 08:55:51 +00:00
Commented Dec 6, 2017 at 8:55 — Federico klez Culloca
– Federico klez Culloca, Commented Dec 6, 2017 at 8:55
thanks i enable that and its working now

Jaydeep Bobade
– Jaydeep Bobade

2017-12-06 09:59:40 +00:00
Commented Dec 6, 2017 at 9:59 — Jaydeep Bobade
– Jaydeep Bobade, Commented Dec 6, 2017 at 9:59

Mahi · Accepted Answer · 2017-12-06 09:45:10Z

2

Try using Absolute Path of the file you are trying to open

eg:

Excel.Workbooks.Open("E:\\test.xlsx");

answered Dec 6, 2017 at 9:45

Mahi

214 bronze badges

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

Comments

Sudipta Kumar Maiti · Accepted Answer · 2017-12-06 10:37:06Z

1

ActiveXObject is only supported by IE, other browsers don't support it.

Excel.Workbooks.Open("teste.xlsx");

There is no path specified for teste.xlsx, provide appropriate file path. The file should be accessed by the browser in the client system, so path should be set accordingly like C:\\Temp\\teste.xlsx (something similar with appropriate system drive).

edited Dec 6, 2017 at 10:37

answered Dec 6, 2017 at 9:09

Sudipta Kumar Maiti

1,7091 gold badge13 silver badges19 bronze badges

1 Comment

Sudipta Kumar Maiti Over a year ago

The file should be in the client system and browser tries to access from client location only, so path should be set accordingly.

Collectives™ on Stack Overflow

how to open excel using javascript

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related