2
3
4
5
6
7
[Ctrl+A 全部选择 提示:你可先修改部分代码,再按运行]
系统集成部的 excel 需要打印标签,但又懒地一个个做。备忘…
1.xsl fail
2.xmlhttprequest
var req,oXML;
/*初始化菜单条目*/
menuArray=["设备名称","设备型号","设备序号","MAC地址","设备编号","出厂日期","IP地址","检验员"]
function loadXMLDoc(url) {
if (window.XMLHttpRequest) {
req = new XMLHttpRequest();
req.onreadystatechange = processReqChange;
req.open(”GET”, url, true);
req.send(null);
} else if (window.ActiveXObject) {
req = new ActiveXObject(”Microsoft.XMLHTTP”);
if (req) {
req.onreadystatechange = processReqChange;
req.open(”GET”, url, true);
req.send();
}
}
}
function processReqChange() {
if (req.readyState == 4) {
if (req.status == 200) {
oXML=req.responseXML;
initialSonglist();
} else {
alert(”There was a problem retrieving the XML data: ” + req.statusText);
}
}
}
function initialSonglist(){
oHTML=”";
oRows=oXML.getElementsByTagName(”Row”);
for(i=1,olen=oRows.length;i
oCells=oRows[i].getElementsByTagName("Data"); oHTML+=" ” for(j=0,jlen=oCells.length;j oHTML=oHTML+"
” } oHTML+=” ” } /*oSongs=oXML.getElementsByTagName(”song”); oHTML=”"; for(i=0;i oHTML+="
” } */ document.getElementById(”oDiv”).innerHTML=oHTML; } loadXMLDoc(”2.xml”) 3.ie xml 数据岛 … 或者外部引用 /*初始化菜单条目*/ menuArray=["设备名称","设备型号","设备序号","MAC地址","设备编号","出厂日期","IP地址","检验员"] oRows=document.all.test.getElementsByTagName(”Row”); oHTML=”"; for(i=1,olen=oRows.length;i
oCells=oRows[i].getElementsByTagName("Data"); oHTML+=" “; for(j=0,jlen=oCells.length;j oHTML=oHTML+"
” } oHTML+=” ” } document.getElementById(”oDiv”).innerHTML=oHTML;
西安交大博通资讯股份有限公司设备检验标识
西安交大博通资讯股份有限公司设备检验标识