GridWeb Error on ImportExcelFile method

Aspose.Cells Product Family
1

I receive an InvalidOperationException: Collection was modified; enumeration operation may not execute when using WebWorksheets.ImportExcelFile(memorystream). This behaviour is with a specific xlsm file

2

Hi,

Thanks for posting your problem and using Aspose.Cells for GridWeb.

Please download and try the latest version:
Aspose.Cells
for GridWeb v2.7.3.2000
and let us know your feedback.

If the problem recurs, then please provide us your source xls/xlsx files and the sample code replicating the problem

3

Ok, will provide sample. We already use that version.

4

Sample xlsm file attached

code used

xlsm file is stored in DB as byte array

Dim myStream As System.IO.MemoryStream = New System.IO.MemoryStream(_request.PricingModelRequestData)


grdWeb.WebWorksheets.EnableIterativeCalculation = True
grdWeb.WebWorksheets.ImportExcelFile(myStream)
grdWeb.WebWorksheets.ActiveSheetIndex = 1

5

Hi,

The file is loading fine, below is my code.

Please also see the screenshot for a reference.

Please set the MemorySteam.Postion = 0 and see if it loads fine as shown in my code.

C#


string filepath = @“F:\Shak-Data-RW\Downloads\Job73±+AA+pricing+model+v+2012+02+20.xlsm”;


byte[] bytes = System.IO.File.ReadAllBytes(filepath);


//Create a memory stream

MemoryStream ms = new MemoryStream();

ms.Write(bytes, 0, bytes.Length);


ms.Position = 0;


this.GridWeb1.WebWorksheets.EnableIterativeCalculation = true;


this.GridWeb1.WebWorksheets.ImportExcelFile(filepath);

Screenshot:
6

Does it work when you change ImportExcelFile with the memorystream? so ms instead of filepath?

I did some extra testing, when I use ImportExcelFile with the filepath, i am getting the same error.
When I set enableAJAX = false the error is gone.

Thanks

7

Hi,

There are some issues when imported using memory stream. I have attached the screenshot for a reference.

Below is my code.

We have logged this issue in our database. Development team will look into this issue and once, the issue is fixed, we will update you asap.

This issue has been logged as CELLSNET-40426.

C#


string filepath = @“F:\Shak-Data-RW\Downloads\Job73±+AA+pricing+model+v+2012+02+20.xlsm”;


byte[] bytes = System.IO.File.ReadAllBytes(filepath);


//Create a memory stream

MemoryStream ms = new MemoryStream();

ms.Write(bytes, 0, bytes.Length);


ms.Position = 0;


this.GridWeb1.WebWorksheets.EnableIterativeCalculation = true;


this.GridWeb1.WebWorksheets.ImportExcelFile(ms);

Screenshot:
8

Hi,

We have fixed this bug: “shape file does not displayed correctly ”.

Please downlad and try the latest version: Aspose.Cells.GridWeb 2.7.5.2001

9

The issues you have found earlier (filed as CELLSNET-40426) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.