<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <mce:script type="text/javascript"><!-- function exp(){ var fso, drv,ff, s =""; s=document.getElementById("name").value; fso = new ActiveXObject("Scripting.FileSystemObject"); drv = fso.GetFolder(s); //var objFSO = new ActiveXObject("Scripting.FileSystemObject"); // Get a reference to drive C //var objDriveC = objFSO.GetDrive('e:'); // Get a reference to the root folder //var objRoot = objDriveC.RootFolder; // Get a reference to the first folder in the SubFolders collection //var colAllFolders = new Enumerator(objRoot.SubFolders); //var objFolder1 = colAllFolders.item(); // Get a reference to the Files collection for this folder //var colFiles = new Enumerator(drv.Files); var colFiles = new Enumerator(drv.Files); // Iterate through all the files in this collection str=""; for (; !colFiles.atEnd(); colFiles.moveNext()) { objFile = colFiles.item() //Response.Write('Name: ' + objFile.Name + ' '); //Response.Write('ShortName: ' + objFile.ShortName + ' '); //Response.Write('Size: ' + objFile.Size + ' bytes '); //Response.Write('Type: ' + objFile.Type + '<BR>'); //Response.Write('Path: ' + objFile.Path + ' '); //Response.Write('ShortPath: ' + objFile.ShortPath + '<BR>'); //Response.Write('Created: ' + objFile.DateCreated + ' '); //Response.Write('Accessed: ' + objFile.DateLastAccessed + ' '); //Response.Write('Modified: ' + objFile.DateLastModified + '<P>'); // alert("name="+ objFile.Name); str+="<span>"+objFile.Name+"</span><br>"; } document.getElementById("test").innerHTML=str; } function method1(tableid) {//整个表格拷贝到EXCEL中 var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); //创建AX对象excel var oWB = oXL.Workbooks.Add(); //获取workbook对象 var oSheet = oWB.ActiveSheet; //激活当前sheet var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); //把表格中的内容移到TextRange中 sel.select(); //全选TextRange中内容 sel.execCommand("Copy"); //复制TextRange中内容 oSheet.Paste(); //粘贴到活动的EXCEL中 oXL.Visible = true; //设置excel可见属性 } function method2(tableid) //读取表格中每个单元到EXCEL中 { var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); //创建AX对象excel var oWB = oXL.Workbooks.Add(); //获取workbook对象 var oSheet = oWB.ActiveSheet; //激活当前sheet var Lenr = curTbl.rows.length; //取得表格行数 for (i = 0; i < Lenr; i++) { var Lenc = curTbl.rows(i).cells.length; //取得每行的列数 for (j = 0; j < Lenc; j++) { oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText; //赋值 } } oXL.Visible = true; //设置excel可见属性 } function getXlsFromTbl(inTblId, inWindow) { try { var allStr = ""; var curStr = ""; //alert("getXlsFromTbl"); if (inTblId != null && inTblId != "" && inTblId != "null") { curStr = getTblData(inTblId, inWindow); } if (curStr != null) { allStr += curStr; } else { alert("你要导出的表不存在！"); return; } var fileName = getExcelFileName(); doFileExport(fileName, allStr); } catch(e) { alert("导出发生异常:" + e.name + "->" + e.description + "!"); } } function getTblData(inTbl, inWindow) { var rows = 0; //alert("getTblData is " + inWindow); var tblDocument = document; if (!!inWindow && inWindow != "") { if (!document.all(inWindow)) { return null; } else { tblDocument = eval(inWindow).document; } } var curTbl = tblDocument.getElementById(inTbl); var outStr = ""; if (curTbl != null) { for (var j = 0; j < curTbl.rows.length; j++) { //alert("j is " + j); for (var i = 0; i < curTbl.rows[j].cells.length; i++) { //alert("i is " + i); if (i == 0 && rows > 0) { outStr += " \t"; rows -= 1; } outStr += curTbl.rows[j].cells[i].innerText + "\t"; if (curTbl.rows[j].cells[i].colSpan > 1) { for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) { outStr += " \t"; } } if (i == 0) { if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) { rows = curTbl.rows[j].cells[i].rowSpan - 1; } } } outStr += "\r\n"; } } else { outStr = null; alert(inTbl + "不存在!"); } return outStr; } function getExcelFileName() { var d = new Date(); var curYear = d.getYear(); var curMonth = "" + (d.getMonth() + 1); var curDate = "" + d.getDate(); var curHour = "" + d.getHours(); var curMinute = "" + d.getMinutes(); var curSecond = "" + d.getSeconds(); if (curMonth.length == 1) { curMonth = "0" + curMonth; } if (curDate.length == 1) { curDate = "0" + curDate; } if (curHour.length == 1) { curHour = "0" + curHour; } if (curMinute.length == 1) { curMinute = "0" + curMinute; } if (curSecond.length == 1) { curSecond = "0" + curSecond; } var fileName = "leo_zhang" + "_" + curYear + curMonth + curDate + "_" + curHour + curMinute + curSecond + ".csv"; //alert(fileName); return fileName; } function doFileExport(inName, inStr) { var xlsWin = null; if (!!document.all("glbHideFrm")) { xlsWin = glbHideFrm; } else { var width = 6; var height = 4; var openPara = "left=" + (window.screen.width / 2 - width / 2) + ",top=" + (window.screen.height / 2 - height / 2) + ",scrollbars=no,width=" + width + ",height=" + height; xlsWin = window.open("", "_blank", openPara); } xlsWin.document.write(inStr); xlsWin.document.close(); xlsWin.document.execCommand('Saveas', true, inName); xlsWin.close(); } // --></mce:script> </head> <body> <h1>查看目录下所有文件</h1> 输入查询的目录:<input type="text" id="name">例如：C:\<br> <input type="button" value="生成文件列表" οnclick="exp()"> <input type="button" value="导出为excel" οnclick="method1('excel')"> <div id="excel"> <strong>项目JAR包配置</strong> <div id="test" style="border:solid 1px" mce_style="border:solid 1px"> </div> </div> </body> </html>
生成输入目录下的所有文件名.html
最新推荐文章于 2021-06-07 17:21:48 发布
扫一扫
1547
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
