Question

71

Javascript Excel OpenFile

rated 0 times [ 73] [ 2] / answers: 1 / hits: 56173 / 11 Years ago, wed, march 6, 2013, 12:00:00

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

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

christianu

Add To Favorites

Follow

Total Points: 481

Total Questions: 124

Total Answers: 99

Location: Trinidad and Tobago

Member since Thu, Dec 1, 2022

2 Years ago

christianu questions

1 Having a trouble with Google OAuth2 (app has no backend, so client side only)

Mon, May 9, 22, 00:00, 2 Years ago

1 Change Icon on click with JS

Thu, Mar 10, 22, 00:00, 2 Years ago

1 Svelte: is there a way to cache the api result in a way that it won't trigger the api call everytime the component renders?

Sun, Sep 27, 20, 00:00, 4 Years ago

1 Javascript / React use of square brackets

Sun, Jul 5, 20, 00:00, 4 Years ago

1 Cannot POST to Express router (404 error)

Wed, Jun 17, 20, 00:00, 4 Years ago

View All

answered 11 Years ago jadon · Accepted Answer

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>