CODEWITHSUNDEEP
javascriptexcelinternet-explorer-11
PythonNewbie
PythonNewbie

Reputation: 228

Javascript Excel OpenFile

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

Upvotes: 4

Views: 60925

Answers (2)

Jebasingh
Jebasingh

Reputation: 11

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>

Upvotes: 1

Simon Adcock
Simon Adcock

Reputation: 3562

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>

Upvotes: 8

Related Questions