请教优化js读取excel的速度
时间：2010-04-06 来源：yjyzfw
<script type="text/javascript">
function readExcel()
{
var filePath= document.all.upfile.value;
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.open(filePath);
var sheetx = oWB.worksheets.Count;//表数
var str="簿名:"+filePath+".共"+sheetx+"个表.\n";
var str1='';
var i=1; while(i<=sheetx){
var j=3;
while(j<=oWB.Worksheets(i).UsedRange.rows.Count){
var l=1;
while(l<=oWB.Worksheets(i).UsedRange.Columns.Count){
if(oWB.Worksheets(i).Cells(j,l).value)
str1+=oWB.Worksheets(i).Cells(j,l).value+"|";
l++;
}
str1+="<br>";
j++;
}
str+="表"+i+":"+oWB.Worksheets(i).name+".共"+oWB.Worksheets (i).UsedRange.rows.Count+"行"+oWB.Worksheets(i).UsedRange.Columns.Count+"列.\n";
i++;
}
oXL.UserControl = true;
oWB.Close(savechanges=false);
oXL=null;
oWB=null;
activeSheet=null;
var data = window.open("");
data.document.write(str1);
alert(str) ;
}
</script>
<form>
<input type="file" id="upfile" />
<input type="button" onclick="readExcel();" value="read">
</form> 我不知道是什么影响了速度---是循环?是条件测试?或是读取速度?
function readExcel()
{
var filePath= document.all.upfile.value;
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.open(filePath);
var sheetx = oWB.worksheets.Count;//表数
var str="簿名:"+filePath+".共"+sheetx+"个表.\n";
var str1='';
var i=1; while(i<=sheetx){
var j=3;
while(j<=oWB.Worksheets(i).UsedRange.rows.Count){
var l=1;
while(l<=oWB.Worksheets(i).UsedRange.Columns.Count){
if(oWB.Worksheets(i).Cells(j,l).value)
str1+=oWB.Worksheets(i).Cells(j,l).value+"|";
l++;
}
str1+="<br>";
j++;
}
str+="表"+i+":"+oWB.Worksheets(i).name+".共"+oWB.Worksheets (i).UsedRange.rows.Count+"行"+oWB.Worksheets(i).UsedRange.Columns.Count+"列.\n";
i++;
}
oXL.UserControl = true;
oWB.Close(savechanges=false);
oXL=null;
oWB=null;
activeSheet=null;
var data = window.open("");
data.document.write(str1);
alert(str) ;
}
</script>
<form>
<input type="file" id="upfile" />
<input type="button" onclick="readExcel();" value="read">
</form> 我不知道是什么影响了速度---是循环?是条件测试?或是读取速度?
相关阅读 更多 +
