Load more than 30 Sheet in a xls File is error

源数组长度不足。请检查 srcIndex 和长度以及数组的下限。

说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.ArgumentException: 源数组长度不足。请检查 srcIndex 和长度以及数组的下限。

源错误:

行 48: ExcelWeb1.WebWorksheets.Clear() 行 49: 行 50: ExcelWeb1.WebWorksheets.ImportExcelFile(common.GetPath_File & dt.Tables(0).Rows(0)("userid") & "\Secret\" & newfilename) 行 51: 行 52: ExcelWeb1.RefreshControl()

源文件: D:\intranet\ViewNews.aspx.vb 行: 50

堆栈跟踪:

[ArgumentException: 源数组长度不足。请检查 srcIndex 和长度以及数组的下限。] Aspose.Excel.?.?(MemoryStream ?) +836 Aspose.Excel.?.?(String ?) +115 Aspose.Excel.Web.Data.?..ctor(String fileName) +85 Aspose.Excel.Web.Data.?.ImportExcelFile(String fileName) +28 intranet.ViewNews.Page_Load(Object sender, EventArgs e) in D:\intranet\ViewNews.aspx.vb:50 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 

Could you please post your file here? Thanks.

the file
thanks

Thanks for your report. We have found this error and fixed it. A hotfix will be released in the next week.

When Will Update?

This bug is fixed. Because we are adding formula feature to Aspose.Excel.Web, we don’t release a new fix to do more testing.

Is this issue urgent for you? A new version will be pulished within one week.

Please download the latest fix. This problem is fixed.