From 2013.igem.org
(Difference between revisions)
|
|
(One intermediate revision not shown) |
Line 1: |
Line 1: |
- | <html>
| + | https://docs.google.com/spreadsheet/pub?key=0ArsDNt8sj-LBdEdCREdxUTFmVXpPaTVnZm43d0RTdmc&single=true&gid=0&output=html |
- | <head>
| + | |
- | <title>
| + | |
- | Style Get data from excel sheet
| + | |
- | </title>
| + | |
- | <script language="javascript" >
| + | |
- | function GetData(cell,row){
| + | |
- | var excel = new ActiveXObject("Excel.Application");
| + | |
- | var excel_file = excel.Workbooks.Open("C:\\amitdata.xls");
| + | |
- | var excel_sheet = excel.Worksheets("Sheet1");
| + | |
- | var data = excel_sheet.Cells(cell,row).Value;
| + | |
- | document.getElementById('div1').innerText =data;
| + | |
- | }
| + | |
- | </script>
| + | |
- | </head>
| + | |
- | <body>
| + | |
- | <p> </p>
| + | |
- | <div style="background: #009955; width:'100%';" align="center">
| + | |
- | <font color="#000080" size="12pt">
| + | |
- | <b>Get data from excel sheets</b>
| + | |
- | </font>
| + | |
- | </div>
| + | |
- | <center>
| + | |
- | <p> </p>
| + | |
- | <div id="div1" style="background: #DFDFFF; width:'100%';" align="center">
| + | |
- | Click buttons to fetch data from c:\amitdata.xls
| + | |
- | </div>
| + | |
- | <input type="button" value="cell(1),row(1)" onClick="GetData(1,1);" />
| + | |
- | <input type="button" value="cell(1),row(2)" onClick="GetData(1,2);" />
| + | |
- | <input type="button" value="cell(2),row(1)" onClick="GetData(2,1);" />
| + | |
- | <input type="button" value="cell(2),row(2)" onClick="GetData(2,2);" />
| + | |
- | </center>
| + | |
- | </body>
| + | |
- | </html>
| + | |
Latest revision as of 10:54, 2 September 2013
https://docs.google.com/spreadsheet/pub?key=0ArsDNt8sj-LBdEdCREdxUTFmVXpPaTVnZm43d0RTdmc&single=true&gid=0&output=html