Javascript Excel OpenFile

Question

I have this code:

<html>
  <script type="text/javascript">
    function test() {
      var Excel = new ActiveXObject("Excel.Application");
      Excel.Workbook.Open("teste.xlsx");
    }
  </script>

  <body>

    <form name="form1">
      <input type=button onClick="test();" value="Open File">
      <br><br>
    </form>

  </body>
</html>

So the main problem is I keep getting this error:

On line 7 , Unable to get value of property Open
URL file:///C:/users/admin/desktop/test.hta

Simon Adcock · Accepted Answer · 2013-03-06 12:17:17Z

8

Firstly, try moving your script to the bottom of the body. You should also set your Excel variable to be visible. And there's a typo with the line Excel.Workbook.Open("teste.xlsx"); (should be Workbooks). The following is working for me in IE. I don't think it will work in other browsers:

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

answered Mar 6, 2013 at 12:17

Simon Adcock

3,5603 gold badges28 silver badges42 bronze badges

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

2 Comments

Svend Over a year ago

Will most definently not work in other browsers. But then again, been a long time since I made any HTAs.

PythonNewbie Over a year ago

well it was not as easy at it looks for me i changed the c0de for : code Excel.Workbooks.Open("C:\\Users\\Admin\\Desktop\\teste.xlsx"); code otherwise it just open a blank excel file

Jebasingh · Accepted Answer · 2019-11-21 20:17:25Z

1

This work with IE 11 and you have to enable all the ActiveX controls in the Internet options. This will open the excel and open the exact sheet what you mentioned in the sheet name.

<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("c:\\jeba\\sample.xlsx");  
    var excel_sheet = Excel.Worksheets("sheetname_1");  
    excel_sheet.activate();  
  }   
</script>

answered Nov 21, 2019 at 20:17

Jebasingh

111 bronze badge

Collectives™ on Stack Overflow

Javascript Excel OpenFile

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related