René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Embedding Excel in Internet Explorer

This example shows how to retrieve a value from an (OWC) excel field.

Fill a value into the A1 field, then click the button.

See also Creating an excel chart if you find this interesting and useful.

The code

<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft Excel 9">
</head>
<body>

<script>

  function get_a1() {
    alert ('the value of cell A1 is: ' + excel.range('a1').value);
    return false;
  }

</script>

<object 
  width   =  800
  height  =  400
  id      = 'excel'
  classid = 'CLSID:0002E510-0000-0000-C000-000000000046'>

 <param name=DisplayTitleBar value=false      >
 <param name=ViewableRange   value="$A$1:$D$4">
 <param name=DataType        value=HTMLData   >
</object>


<form>
  <input type=submit onclick='return get_a1()' value='Get A1'>
</form>


</body>
</html>