<html> <head> <style media=print mce_bogus="1"> .Noprint{display:none;} .PageNext{page-break-after:always;} </style> </head> <script language="javascript" type="text/javascript"> Ext.onReady(function(){ var data=[ [1, 'EasyJWeb', 'EasyJF','rokr.iteye.com'], [2, 'rokr', 'rokr','rokr.iteye.com'], [3, 'rokr', 'rokr','rokr.iteye.com'], [4, 'rokr', 'rokr','rokr.iteye.com'] ]; var sm=new Ext.grid.CheckboxSelectionModel(); var store=new Ext.data.SimpleStore({data:data,fields:["id","name","rokr","rokr"]}); var grid = new Ext.grid.GridPanel({ renderTo:"hello", title:"rokr.iteye.com", height:150, width:600, columns:[sm,{header:"项目名称",dataIndex:"name"}, {header:"开发团队",dataIndex:"organization"}, {header:"网址",dataIndex:"homepage"}], sm:sm, store:store, autoExpandColumn:2 }); }); </script> <body > <br /> <div id="hello"></div> <br/><br> <div id="newTable" style="font-size:12px;" ></div> <br><br> <span class="Noprint"> <input type="button" onClick="javascript:AllAreaExcel();" value="导出Excel"> <input type="button" onClick="javascript:OpenWord();" value="导出Word"> <input type=button value=打印 οnclick=document.all.WebBrowser.ExecWB(6,1)> <input type=button value=页面设置 οnclick=document.all.WebBrowser.ExecWB(8,1)> <input name=Button οnclick=document.all.WebBrowser.ExecWB(7,1) type="button" value="打印预览"> <OBJECT classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 id=WebBrowser width=0></OBJECT> <input type="file" name="file" id="file"/> <input type="button" id="excelimport" name="excelimport" value="Excel导入" onClick="javascript:readExcel()" /> </span> </div> <script language="javascript" type="text/javascript"> function readExcel() { if(document.getElementById("file").value.split(".")[1]=="xls"){ var oXL = new ActiveXObject("Excel.Application"); try{ var oWB = oXL.Workbooks.open(document.getElementById("file").value); }catch(e){ alert('打开文件失败!'); } var oSheet = oWB.ActiveSheet; var table=document.createElement("table"); table.setAttribute("border","1"); table.setAttribute("cellpadding","0"); table.setAttribute("cellspacing","0"); table.setAttribute("border-collapse","collapse"); table.setAttribute("width","60%"); //table.setAttribute("style-fontSize","12"); table.setAttribute("id","mytable"); document.body.appendChild(table); for(var i=0;i<oSheet.usedrange.rows.count;i++){ var row=table.insertRow(i); for(var j=0;j<(oSheet.usedrange.cells.count/oSheet.usedrange.rows.count);j++){ //oSheet.Cells(i,j).Font.Size = 10; //alert(oSheet.Cells(i+1,j+1).value); if(oSheet.Cells(i+1,j+1).value==null){ row.insertCell(j).appendChild(document.createTextNode("")); } else{ row.insertCell(j).appendChild(document.createTextNode(oSheet.Cells(i+1,j+1).value)); } } } var div=document.getElementById("newTable"); div.appendChild(table); //alert(oSheet.Rows.rows); // alert(oSheet.Cells(1,1).value);//cell的值 // alert(oSheet.usedrange.cells.count);//cell的值 // alert(oSheet.usedrange.rows.count);//使用的行数 // alert(oWB.Worksheets.count);//得到sheet的个数 oSheet=null; oWB.close(); oXL=null; }else{ if(document.getElementById("file").value==""){ window.alert("请选择Excel文件"); return false; }else{ window.alert("您选择的不是Excel文件"); return false; } } } //导入Excel function AllAreaExcel() { //创建Excel格式对象 var oXL = new ActiveXObject("Excel.Application"); //var oXL = createOXL(); //获取workbook对象 var oWB = oXL.Workbooks.Add(); //激活当前sheet var oSheet = oWB.ActiveSheet; //oSheet.Cells(1,1).Font.Size = 30; var sel=document.body.createTextRange(); //把表格中的内容移到TextRange中 sel.moveToElementText(hello); //全选TextRange中内容 sel.select(); //复制TextRange中内容 sel.execCommand("Copy"); //粘贴到活动的EXCEL中 oSheet.Paste(); //设置excel可见属性 oXL.Visible = true; //oXL.Quit(); } //导出word function OpenWord(){ var ExcelSheet = new ActiveXObject('word.Application'); // 使 Excel 通过 Application 对象可见。 ExcelSheet.Application.Visible = true; var orgNum=ExcelSheet.Documents.Add("",0,1); var myRange =orgNum.Range(0,1) var sel=document.body.createTextRange(); var oTblExport =document.getElementById("hello"); if (oTblExport != null) { sel.moveToElementText(oTblExport); sel.execCommand('Copy'); document.body.blur(); myRange.Paste(); } //window.close(); //ExcelSheet.Application.Quit(); } </script> </body> </html>