Opening Embedded Excel Workbook on Sharepoint using Javascript

Question

I am currently attempting to open an embedded excel file found on my company's sharepoint:

<!DOCTYPE html>     
<head>
<title>
Project
</title>
<script type="text/javascript"> 

var excel = new ActiveXObject("Excel.Application");
var excel_file = excel.Open("sharepoint_url/myfile.xlsx");


</script>
</head>
<body>
</body>
</html>

However, whenever I run this, I keep receiving the following error:

Subscript out of range

I was hoping someone could shed some light as to how I should approach this issue. Any help is appreciated.

thatthing · Accepted Answer · 2015-06-18 19:45:28Z

1

Try this.

<html>
<body>

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

<script type="text/javascript">
  function openmyfile() {
    var Excel = new ActiveXObject("Excel.Application");
    Excel.Visible = true;
    Excel.Workbooks.Open("sharepoint_url/myfile.xlsx");
  }
</script>

answered Jun 18, 2015 at 19:45

thatthing

6864 gold badges17 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Opening Embedded Excel Workbook on Sharepoint using Javascript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related