在Windows平台上, js可以调用很多Windows提供的ActivexObject,本文就使用js来实现文档处理, 和使用js编写ActiveX做一个简单介绍.
</head>
<script type=\"text/javascript\">
function readFolder(){
var filePath = \"d:\\\\test\\\\\";
var fso = new ActiveXObject(\"Scripting.FileSystemObject\"); //加载控件
var f = fso.GetFolder(filePath);
var underFiles = new Enumerator(f.files); //文件夹下文件
for (;!underFiles.atEnd();underFiles.moveNext()){
var fn = \"\" + underFiles.item();
//alert(fn);
var content = readFile(fn,fso);
alert(content);
}
}
function readFile(path,fso){
var f1 = fso.GetFile(path);
var fh = fso.OpenTextFile(f1, 1/*reading*/);
var content = \'\';
while ( !fh.AtEndOfStream ) {
content += fh.ReadLine();
}
fh.close()
return content;
}
function writeExcel(){
var ExcelApp = new ActiveXObject(\"Excel.Application\");
var ExcelSheet = new ActiveXObject(\"Excel.Sheet\");
ExcelSheet.Application.Visible = true;
ExcelSheet.ActiveSheet.Cells(1,1).Value = \"This is column A, row 1\";
ExcelSheet.SaveAs(\"d:\\\\TEST.XLS\");
ExcelSheet.Application.Quit();
}
</script>
<body>
<input type=\"button\" value=\"遍历文件夹\" onclick=\"readFolder()\">
<input type=\"button\" value=\"写excel\" onclick=\"writeExcel()\">
</body>
</html>
本文地址:https://www.stayed.cn/item/26599
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我