html中实现打印和Excel导出

    技术2022-05-11  52

    < html >    < head >      < base  href ="<%=basePath%>" >          < title ></ title >          < meta  http-equiv ="pragma"  content ="no-cache" >      < meta  http-equiv ="cache-control"  content ="no-cache" >      < meta  http-equiv ="expires"  content ="0" >          < meta  http-equiv ="keywords"  content ="keyword1,keyword2,keyword3" >      < meta  http-equiv ="description"  content ="This is my page" >      <!--     <link rel="stylesheet" type="text/css" href="styles.css">     -->      < style  media ="print"  type ="text/css" > .Noprint{display:none;}.PageNext{page-break-after: always;} </ style >      < script  type ="text/javascript" >     //导出到Excel    function toExcel()    {        var elTable = document.getElementById("tb");         var oRangeRef = document.body.createTextRange();         oRangeRef.moveToElementText( elTable );         oRangeRef.execCommand( "Copy" );         var appExcel = new ActiveXObject( "Excel.Application" );         appExcel.Visible = true;         appExcel.Workbooks.Add().Worksheets.Item(1).Paste();         appExcel = null;    }      //打印                var HKEY_Root,HKEY_Path,HKEY_Key;      HKEY_Root="HKEY_CURRENT_USER";      HKEY_Path="/Software/Microsoft/Internet Explorer/PageSetup/";      //设置网页打印的页眉页脚为空      function PageSetup_Null()      {         try {         var Wsh=new ActiveXObject("WScript.Shell");         HKEY_Key="header";         Wsh.RegWrite(HKEY_Root+HKEY_Path+HKEY_Key,"");         HKEY_Key="footer";         Wsh.RegWrite(HKEY_Root+HKEY_Path+HKEY_Key,"");         }  catch(e){}       }       //恢复网页打印的页眉页脚      function PageSetup_default()      {         try {         var Wsh=new ActiveXObject("WScript.Shell");         HKEY_Key="header";         Wsh.RegWrite(HKEY_Root+HKEY_Path+HKEY_Key,"&w&b页码,&p/&P");         HKEY_Key="footer";         Wsh.RegWrite(HKEY_Root+HKEY_Path+HKEY_Key,"&u&b&d");         }  catch(e){}       }        </ script >    </ head >      < body  onload ="PageSetup_Null()" >    < div  id ='block' >      < table  id ="tb" >          < tr >               < td > ID </ td >               < td > Name </ td >               < td > Describ </ td >             </ tr >             < tr >               < td > 1 </ td >               < td > name1 </ td >               < td > describ1 </ td >             </ tr >             < tr >               < td > 2 </ td >               < td > name2 </ td >               < td > describ2 </ td >             </ tr >                 </ table >      </ div >      < object  id ="WebBrowser"  classid ="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"  height ="0"         width ="0" >      </ object >          < center  class ="Noprint"   >      < input  type ="button"  value ="打印"  onclick ="document.all.WebBrowser.ExecWB(6,1)"   />      < input  type ="button"  value ="直接打印"  onclick ="document.all.WebBrowser.ExecWB(6,6)"   />      < input  type ="button"  value ="页面设置"  onclick ="document.all.WebBrowser.ExecWB(8,1)"   />      < input  type ="button"  value ="打印预览"  onclick ="document.all.WebBrowser.ExecWB(7,1)"   />      </ center >          < input  type ="button"  value ="导出到Excel"  name ="button1"  onclick ="printScreen(block)" >    </ body > </ html >  

    最新回复(0)