日期:2014-05-16 浏览次数:20379 次
?21 ,js导出图片到excel
<HTML> <HEAD> <TITLE>将页面中指定表格的数据导入到Excel中</TITLE> <SCRIPT LANGUAGE="javascript"> function AutomateExcel() { var oExcel = new ActiveXObject("Excel.Application"); //创建Excel对象 var oWork = oExcel.Workbooks.Add(); //新建一个Excel工作簿 var oSheet = oWork.ActiveSheet; //指定要写入内容的工作表为活动工作表 var table = document.all.myTbl; //指定要写入的数据源的id var myRow = table.rows.length; //取数据源行数 var myCell = table.rows(0).cells.length; //取数据源列数 for (i=0;i<myRow;i++){//在Excel中写行 for (j=0;j<myCell;j++){//在Excel中写列 //定义格式 oSheet.Cells(i+1,j+1).Font.Bold = true;//加粗 oSheet.Cells(i+1,j+1).Font.Size = 10;//字体大小 if(table.rows(i).cells(j).innerHTML.toLowerCase().indexOf('<img')!=-1){//如果其HTML代码包括<img oSheet.Cells(i+1,j+1).Select();//选中Excel中的单元格 oSheet.Pictures.Insert(table.rows(i).cells(j).getElementsByTagName('img')[0].src);//插入图片 } else{ oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;//向单元格写入值 } } } oExcel.Visible = true; oExcel.UserControl = true; } </SCRIPT> </HEAD> <BODY> <table border="1" width="500" id="myTbl" bgcolor="blue"> <tr bgcolor="white"> <td> 姓名</td> <td>年龄</td> <td>地址</td> <td>照片</td> </tr> <tr bgcolor="white"> <td>张三</td> <td>22</td> <td>北京海淀</td> <td><img src="logo1.gif" border="0"></td> </tr> <tr bgcolor="white"> <td>李四</td> <td>23</td> <td>上海浦东</td> <td><Img src="logo2.gif" border="0"></td> </tr> </table> <input type="button" name="export" onclick="AutomateExcel();" value="导出到Excel"> </BODY> </HTML>
?
22,vml 制作随鼠标变大小的圆
<html Xmlns:v="urn:schemas-microsoft-com:vml"> <style> <!-- v\:* {behavior:url(#default#VML);} --> </style> <body onmousemove='with(document.all.test.style){width=event.x;height=event.y;}'> <v:oval id=test style="width: 100; height: 100"> <v:stroke weight="1px" color="navy"/> </v:oval> </body> </html>
?
23,js做的结构流程图
<html> <head> <title>组织结构图</title> <style> .ItemCss { position:absolute; width:24px; border:1px solid #999999; font-size:12px; padding:5px; height:70px; z-index:9; background-color:#FFFFFF; line-height:16px; } a { text-decoration:none; color:#333333; } .divhline { position:absolute; z-index:17; padding:0px; margin:0px; border-top:1px solid #999999; } .divvline { color:blue; position:absolute; background-color:#999999; width:1px; z-index:17; } </style> <script language="javascript"> var dItem = new Array(); var w = 600; var h = 40; var iw = 60; var ih = 70; var boxh = 70; var startleft = 350; var starttop = 30; var hr = "<hr size=\"1\" noshade>" var labledv = "<div class=\"ItemCss\" style=\"" var hdv = "<div class=\"divhline\" style=\"width:"; var vdv = "<div class=\"divvline\" style=\"height:" + h + "px;\""; var endsdv = "\">"; var enddv = "</div>"; var htm = ""; var len; var maxn=0; //深度初始变量 function createStruct() { dItem[0] = "1|教育部|0|"; //设置要显示的结构内容-以“|”间隔 dItem[1] = "2|东部教育局|1|"; //注意第三项为父级节点 dItem[2] = "3|西部教育局|1|"; dItem[3] = "4|东部高校|2|"; dItem[4] = "5|东部高中|2|"; dItem[5] = "6|商务代表|5|"; dItem[6] = "7|东部初中|2|"; dItem[7] = "8|西部高校|3|"; dItem[8] = "9|西部高中|3|"; len = dItem.length; //获取结构数组的长度 Set_Item(0,0); //设置开始的节点 Set_Max(); Write_Item(0,0,0,1