From 2013.igem.org
(Difference between revisions)
|
|
| 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:\Users\Guest\Desktop\test.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
"
