<script>
function readThis(){
var tempStr = "";
var filePath= document.all.upfile.value;
var oXL = new ActiveXObject("Excel.application");
var oWB = oXL.Workbooks.open(filePath);
oWB.worksheets(1).select();
var oSheet = oWB.ActiveSheet;
try{
for(var i=3;i<654;i++){
//if(oSheet.Cells(i,2).value =="null" || oSheet.Cells(i,3).value =="null" )
//break;
//var a = oSheet.Cells(i,2).value.toString()=="undefined"?"":oSheet.Cells(i,2).value;
tempStr+=(oSheet.Cells(i,2).value.replace(/\s/g,'')+"="+oSheet.Cells(i,3).value.replace(/\s/g,'')+"\n");
}
}
catch(e){
//alert(e);
document.all.txtArea.value =tempStr;
}
document.all.txtArea.value =tempStr; oXL.Quit();
CollectGarbage();
}
</script>
<html>
<input type="file" id="upfile" />
<input type="button" οnclick="readThis();" value="读取"><br>
<textarea id="txtArea" cols=500 rows=100></textarea>
</html>
2万+
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
