excel阅读javascript代码挂起 [英] excel reading javascript code is hanging

问题描述

我编写了用于读取Excel工作表的javascript代码，它对于具有30行值的Excel工作表运行良好，但是我尝试运行具有大约3500行值的Excel工作表，因此即使无法取消输出页面，它也会变得挂起.尽管我没有为数组大小设置任何限制，但是为什么要挂它呢?
请任何人帮我解决.

I wrote the javascript code for reading excel sheet and it was running well for excel sheet having 30 rows values but i tried to run excel sheet having approximately 3500 rows values so it becomes hang even output page couldn''t been canceled.Although i have not set any limit for array size but why its hanging?
Please can anyone help me to resolve it.

var Excel;
Excel = new ActiveXObject("Excel.Application");
Excel.Visible = false;
var a=Excel.Workbooks.Open("C:/desktop/info.xlsx").sheets(1);
for(var r=1;r<=a.usedrange.rows.count;r++)
{
abc[r-1]=new Array()
for(var c=1;c<=a.usedrange.columns.count;c++)
abc[r-1][c-1]=a.Cells(r,c).Value;
}

推荐答案

好吧，对于大量值，人们非常希望它可能需要一些时间-给人留下被绞死的印象.

批量获取并读取.也许，您可以放置​​某种过滤器以减少记录.

Well, for large number of values it is quite expected that it might take some time - giving an impression of getting hanged.

Fetch in batches and read. Maybe, you can put some sort of filter to bring less records.

不，我必须一次读取所有值，还有其他解决方案吗?

No,i have to read all values at a time, any other solution?

这篇关于excel阅读javascript代码挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！